topic Re: hi in QlikView

hi

Tue, 24 Jun 2014 12:24:35 GMT

i have 3 excel file data1, data2, and data3 in which there are 2 column EmpId and EmpName.

so how can i import data from these 3 file in a single load statement.......

ashfaq_haseeb — Tue, 24 Jun 2014 12:31:30 GMT

Hi,

Let say you have 3 files names as

File1.xls

File2.xls

File3.xls

Then try below

load *

From file*.xls;

Regards

ASHFAQ

MayilVahanan — Tue, 24 Jun 2014 12:52:50 GMT

Try like this

Load * from data*.xls;

for each i in 'YYY.xlsx', 'XXX.xlsx'

LOAD Student,

field,

Note

FROM

$(i)

(ooxml, embedded labels, table is Feuil1);

Tue, 24 Jun 2014 13:28:58 GMT

What type of file you have?