Help script syntax

[#1]

Hello,

I have a script for data loading from a qvd file (atteched), it gives an "scorie after instruction" error while running, could anyone help, please ? Thanks

Roles:

add

DATEFFET

,

concat

(CDEROL,'') as CDEROL GROUP BY NUMPERS,DATEFFET

RolesTmp.qvd

(qvd);

LOAD NUMPERS,

[#2]

Sorry, problme pasting the script, here is the correct script :

Roles:

LOAD NUMPERS,DATEFFET,concat(CDEROL,'') as CDEROL GROUP BY NUMPERS,DATEFFET

FROM RolesTmp.qvd (qvd);

[#3]

Hi,

so far I see the statement normaly should be written in this way:

Roles:

LOAD NUMPERS,DATEFFET,concat(CDEROL,'') as CDEROL

FROM RolesTmp.qvd (qvd)

GROUP BY NUMPERS,DATEFFET;

but:

Not sure at the moment if it is possible to have a "Group By" statement with a qvd file.

Tip:

Do the concat by building the qvd file.

Rainer