0 Replies Latest reply: May 4, 2017 5:10 AM by Charlie Audebert RSS

    Load all files from a directory and differentiate them

    Charlie Audebert

      Hi,

       

      I am trying to load all files from a directory and differentiate them with the file name.

       

      I tried the script below but Qlik Sense load nothing as if there is no script at all. I don't understand why.

       

      for each File in filelist('C:\Users\NG6A463\Desktop\Test\test*.xlsx')

      LOAD
      *,
      filename() as FileName
      from $(File)
      (ooxml , embedded labels , table is Sheet1);

      next File

       

       

      In my directory I've got 3 files:

      test-1.xlsx

      test-2.xlsx

      test-3.xlsx

       

      Thanks for your help.

       

      Charlie