Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading data


Hi All,

    I have excel files stored in a folder(similar kind of data on monthly). now i want to read all these files in to a qvd

    How can i acheive this

    Thankz in advance

3 Replies
Not applicable
Author

Just load all excel files

like

table:

load

xl1;

concatentae

load

xl2;

concatenate

load xl3;

store table into c:\....\xl.qvd;

Not applicable
Author

Hi,

Load Concatenate this excel file with existing qvd and then store it.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

MyTable:

LOAD * from (ooxml, embedded labels, table is Sheet1);

STORE MyTable into MyTable.qvd;


talk is cheap, supply exceeds demand