Discussion board where members can get started with Qlik Sense.
I have data in each sheet of work book with common fields and each sheet in excel work book is a category
No I would like to loop through all the sheets available in the work book and concatenate them while looping
I tried using the help from the following post but as Im using Qlik sense I am getting the error as it can connect only to Lib connections
I tried replacing the path with Lib but even then it is not working and is failing at odbc,
can some body help me on this
can you please help
Thanks in Advance
Loading from multiple Excel files and multiple sheets
Can you attach sample Excel file.
If loading from Excel, I use a file connector as you are loading from a single file.
Then you would need to loop through your sheets; if the fields are the same, Qlik will concatenate.
Look at For Each