Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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);
But i want to partial reload the same table.
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