0 Replies Latest reply: Jun 20, 2017 11:33 AM by Sateesh s RSS

    directory name not to hard code

    Sateesh s

      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')



                  '$(File)' as Name,

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

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

                  FileTime( '$(File)' ) as FileTime


               autogenerate 1;

           next File