Combining multiple rows into one row separated by commas

[vaisgaard]

Hi,

I have a table where I need to convert the rows into one field. The values shall be separated by a comma.

Eg.

LOAD * INLINE [
Cause
Missing value
Missing signature
Dataformat not correct
];

The end result should be a field called Causes and the value should be Missing value, Missing signature, Dataformat not correct.

I have tried looping through the values using a variable and just adding values to the same field in the load script. I just can't figure this one out.

I hope someone can help me.

BR

Michael

[martinpohl · Accepted solution]

load 

concat(Cause,', ') as Causecombine

resident yourdata;

Regards

[JGMDataAnalysis]

Something like this?

Test:
NOCONCATENATE
LOAD Concat(Cause, ', ', Sort) AS Causes
INLINE [
        Cause, Sort
        Missing value, 1
        Missing signature, 2
        Dataformat not correct, 3
];

[vaisgaard]

Thank you so much Martin.

[vaisgaard]

Thank you for replying 🙂