directory name not to hard code

satishsure — Mon, 19 Jun 2017 14:43:13 GMT

I am hard coding the directory name in below.Do we have any alternate way to get the current directory to pass to variable.

I need to load many files weekly once and put them into qvd.

Let Transfilespath='lib://Operation Files/ Processed Sales \';

for each File in filelist (Transfilespath&'Load_*.' &'xlsx')

FilesinFolder:

LOAD

'$(File)' as Name,

Text(right( '$(File)', Len( '$(File)' )- len( '$(Transfilespath)'))) as TransFilenameinFolder,

FileSize( '$(File)' ) as Size,

FileTime( '$(File)' ) as FileTime

autogenerate 1;

next File