4 Replies Latest reply: Aug 9, 2017 12:02 PM by Joydip Chakraborty RSS

    FileList can't solve variable correctly

    Luigi Miceli

      Hi All,

       

      this code works:

       

      For each File in FileList('C:\T\*.xlsx');

      LOAD Field

      FROM

      [$(File)]

      (ooxml, embedded labels, table is Sheet1);

      next File;

       

       

       

      this code gives me an error:

       

      SET Tpath = 'C:\T\*.xlsx';

       

      For each File in FileList($(Tpath));

      LOAD Field

      FROM

      [$(File)]

      (ooxml, embedded labels, table is Sheet1);

      next File;

       

       

      Untitled.jpg

       

       

       

      any suggestion?

       

      thanks!