Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

load scripting with two files

I can load two files with the same structure and the same columns in a single load???

load

c1,

c2,

c2

from

c:/fil1, c:/fil2

1 Solution

Accepted Solutions
avinashelite

Is it a flat file ? if they are present in the same folder then

load

c1,

c2,

c2

from

path\*.qvd

// similarly 

path\*.xlx etc


NOTE: All the files in the folder should have the common structure

View solution in original post

4 Replies
avinashelite

Is it a flat file ? if they are present in the same folder then

load

c1,

c2,

c2

from

path\*.qvd

// similarly 

path\*.xlx etc


NOTE: All the files in the folder should have the common structure

souadouert
Specialist
Specialist
Author

like this script ?

[CAPITALCLIENTF]:

LOAD

..................

FROM

C:\pfe\DONNEES_RECAP\CAPITAL_CLIENT.qvd  (qvd)

C:\pfe\DONNEES_RECAPJANV\CAPITAL_CLIENT.qvd (qvd);

avinashelite

No, as i mentioned earlier if it is in the same folder then you could then it will work

The above code does not work ...

[CAPITALCLIENTF]:

LOAD

*

FROM

C:\pfe\DONNEES_RECAP\CAPITAL_CLIENT.qvd  (qvd)

LOAD

*

FROM

C:\pfe\DONNEES_RECAPJANV\CAPITAL_CLIENT.qvd (qvd);

souadouert
Specialist
Specialist
Author

thx avinash