topic Re: load scripting with two files in QlikView

load scripting with two files

souadouert — Tue, 21 Mar 2017 10:32:49 GMT

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

Re: load scripting with two files

avinashelite — Tue, 21 Mar 2017 10:35:02 GMT

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

Re: load scripting with two files

souadouert — Tue, 21 Mar 2017 10:38:26 GMT

like this script ?

[CAPITALCLIENTF]:

LOAD

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

FROM

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

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

Re: load scripting with two files

avinashelite — Tue, 21 Mar 2017 10:46:14 GMT

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);

Re: load scripting with two files

souadouert — Tue, 21 Mar 2017 10:48:26 GMT

thx avinash