Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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.

Tags (1)
4 Replies
Highlighted
Not applicable

Multilpe *.xlsx files to be loaded.

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

Highlighted
Partner
Partner

AW:Multilpe *.xlsx files to be loaded.

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);

Highlighted
Not applicable

AW:Multilpe *.xlsx files to be loaded.

But i want to partial reload the same table.

Highlighted
MVP
MVP

Multilpe *.xlsx files to be loaded.

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