topic Help script syntax in QlikView

Help script syntax

Thu, 10 Dec 2009 17:33:39 GMT

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,

Help script syntax

Thu, 10 Dec 2009 17:35:45 GMT

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

Help script syntax

Thu, 10 Dec 2009 17:51:52 GMT

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