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