5 Replies Latest reply: Jul 1, 2010 8:05 AM by konstantinos-m RSS

    Load data from Excel files based on the file name

      Hello.I hope someone can help me on this. I have a folder with excel files. The file names are Sales123, Sales789 etc. I want Qlikview to load the excel files according to the 3 numbers in the filename,which represent the branch. I create a for loop which works fine:

      for Branch=123 to 789

      load Results from Sales$(Branch).xlsx (ooxml, embedded labels, table is Sheet1);

      next

      The problem is that the number of branches may change, so i have to load the branch names from another excel file which has 2 columns, BranchNo (1,2 etc),Branch (123,789 etc). How can i pass that parameter in the for loop? Thanks in advance