concat works randomly

[draghici1109]

Hello,

I have to concatenate several records in one field using the concat() function. Yet concat works somehow randomly and concatenate the records not sorted but randomly. Here is the code:

prepTLINE:

NoConcatenate

LOAD

    TABNR,

    num#(SubField(TABSEQNR, '0', -1)) AS NumTABSEQNR,

TLINE

FROM HRT1002.qvd] (qvd);

prepMappingTLINE:

NoConcatenate

LOAD

    TABNR,

    NumTABSEQNR,

TLINE

Resident prepTLINE

order BY TABNR,NumTABSEQNR ASC;

STORE prepMappingTLINE into prepMappingTLINE.qvd] (qvd);

DROP Table prepTLINE;

// Step 3: Create mapping table using sorted QVD

SortedTLINE:

NoConcatenate

LOAD

    TABNR,

    NumTABSEQNR AS TABSEQNR,

    TLINE

Resident prepMappingTLINE

ORDER BY TABNR, NumTABSEQNR;

mTLINE:

Mapping

LOAD

    TABNR,

Concat(TLINE, ' ') AS AllTLINE

RESIDENT SortedTLINE

GROUP BY TABNR;

----

Here is the end result: 

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[marcus_sommer · Accepted solution]

You need only to specify the third (numeric) parameter of:

concat(Field/Expression, Delimiter, Sort)

[draghici1109]

thanks! I apologize... one should read the help files 

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download