Concatenate all the sheets in an excel work in Qlik sense

[mhappiee]

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

@jontydkpi

can you please help

Thanks in Advance

Loading from multiple Excel files and multiple sheets

[mdmukramali]

Hi,

Can you attach sample Excel file.

Thanks,

Mukram.

[dwforest]

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

https://help.qlik.com/en-US/sense/February2018/Subsystems/Hub/Content/Scripting/ScriptControlStateme...

[dreweezy]

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?