Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi folks,
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
Hi,
Can you attach sample Excel file.
Thanks,
Mukram.
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
Hi, I know this thread was from back in 2018 so I'm sure no one will be reading this. What if I didn't want Qlik to concat? I'm bringing in 3 separate sheets from excel and when I bring all 3 in, it looks like its concat the last 2 together which makes it hard for me to generate accurate qvds to create viz. Is there an explicit statement to tell qlik to not concat anything and just do a strict lone import for 3 data sets?