Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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