3 Replies Latest reply: Sep 16, 2011 1:25 AM by David Zenesh RSS

    loading multiple excel files

      Hi All, I'm loading mutiple excel files with the same tables by using the script below:

       

      For each ExcelFile in filelist ('*.xls')

      My_data:

      Load * From $(ExcelFile) (biff, embedded labels, header is 1 lines, table is Sheet1$);

      Next ExcelFile;

       

      The result of the reload is that Qlikview creates synthetic keys for each filed multiple by the number of files.
      I'll appreciate your advice on how to avoid the synthetic keys.
      Regards
      David