Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mhappiee
New Contributor III

Concatenate all the sheets in an excel work in Qlik sense

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

2 Replies
mdmukramali
Valued Contributor II

Re: Concatenate all the sheets in an excel work in Qlik sense

Hi,

Can you attach sample Excel file.

Thanks,

Mukram.

dwforest
Valued Contributor

Re: Concatenate all the sheets in an excel work in Qlik sense

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...

Community Browser