Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
like this script ?
[CAPITALCLIENTF]:
LOAD
..................
FROM
C:\pfe\DONNEES_RECAP\CAPITAL_CLIENT.qvd (qvd)
C:\pfe\DONNEES_RECAPJANV\CAPITAL_CLIENT.qvd (qvd);
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);
thx avinash