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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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