0 Replies Latest reply: Jun 20, 2017 11:33 AM by Satish S RSS

    directory name not to hard code

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

      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