load scripting with two files

[souadouert]

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

[avinashelite · Accepted solution]

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]

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]

thx avinash