Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

hi

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.......

3 Replies

Re: hi

Hi,

Let say you have 3 files names as

File1.xls

File2.xls

File3.xls

Then try below

load *

From file*.xls;

Regards

ASHFAQ

Re: hi

Hi

Try like this

Load * from data*.xls;

or

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

LOAD Student,

     field,

     Note

FROM

$(i)

(ooxml, embedded labels, table is Feuil1);

Next

Not applicable

Re: hi

What type of file you have?

Community Browser