The FileDir function returns a string containing the path to the directory of the table file currently being read.
Note: This function supports only folder data connections in standard mode. See File system access restriction
Load *, filedir( ) as X from
|Will return 'C:\UserFiles' in field X in each record read.|