topic Re: loading data in QlikView

loading data

Thu, 18 Dec 2014 14:52:14 GMT

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

Thu, 18 Dec 2014 14:56:43 GMT

Just load all excel files

table:

load

xl1;

concatentae

load

xl2;

concatenate

load xl3;

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

Thu, 18 Dec 2014 14:58:59 GMT

Hi,

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

Gysbert_Wassenaar — Thu, 18 Dec 2014 15:10:20 GMT

MyTable:

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

STORE MyTable into MyTable.qvd;