Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multilpe *.xlsx files to be loaded.

I want to load 5 xlsx file and there is column is same like columnA, columnB in each xlsx file and i want only single table to be created when i reload this files. Also i partial reload this xlsx file so please help for that.

4 Replies
Not applicable
Author

see this

http://community.qlik.com/forums/t/42349.aspx

And i thing you should search before post something.

Like


load multiple xlsx files site:www.qlik.com


in google

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

If the structure and the name (Sheet1) of all Excelsheets are the same, you can use the *:

Table:
ADD (resp. REPLACE) Load * From *.xlsx (ooxml, embedded labels, table is Sheet1);

Not applicable
Author

But i want to partial reload the same table.

tresesco
MVP
MVP

have a look at this (yes your partial load is discussed here):

http://community.qlik.com/forums/t/42349.aspx

and please let me know, if it helps or not.

regards, tresesco