How to connect multiple sheets in the same workbook in Qlik Sense

[JCC]

Good day,

Could anyone help me to join or connect several sheets in the same workbook together? The reason is that there is row limits 1,048,576 on each sheet. Now I have two sheets but together there will be more than 1,600,000 rows if I try to copy and paste them into one sheet (and of course failed, because excel does not allow me to do so). In Excel itself we can use the function FROM TABLE/RANGE to make appendix for two sheets, however, how can I proceed this in Qlik Sense? Is it possible? or is there any alternative solution?

Thanks a lot in advance!

[justISO · Accepted solution]

Hi, try to load your first sheet and concatenate or add your second sheet on that. In this way you will have merged both sheet data.

f.e. something like this

LOAD
*
FROM [lib://first.xlsx]
(ooxml, embedded labels, table is [sheet1]);

concatenate
LOAD
*
FROM [lib://second.xlsx]
(ooxml, embedded labels, table is [sheet1]);