You can use another kind of loop. But you will need a loop. One option is to use an ODBC connection to the excel file and use the SQLTABLES function to retrieve a list of tables that exist in the excel file. Each sheet will be a table in that list. By using th SQLTABLES function you load that list into a table and then you can iterate of the records of that table to load the data from the excel sheets. Heres' an example: https://community.qlik.com/t5/QlikView-Documents/Loading-Multiple-Excel-Sheets-Dynamically-along-wit...
Here we need an ODBC connection to the excel. As the windows change the ODBC connections has to be updated 32/64 bit. It is clumsy. Can I know is there any other ways to achieve apart from the 2 ways as above.
