topic Re: Combining multiple rows into one row separated by commas in App Development

Combining multiple rows into one row separated by commas

vaisgaard — Mon, 14 Oct 2019 14:06:17 GMT

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.

Michael

Re: Combining multiple rows into one row separated by commas

martinpohl — Mon, 14 Oct 2019 14:12:29 GMT

load

concat(Cause,', ') as Causecombine

resident yourdata;

Regards

Re: Combining multiple rows into one row separated by commas

JGMDataAnalysis — Mon, 14 Oct 2019 14:18:00 GMT

Something like this?

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

Re: Combining multiple rows into one row separated by commas

vaisgaard — Tue, 15 Oct 2019 09:03:55 GMT

Thank you so much Martin.

Re: Combining multiple rows into one row separated by commas

vaisgaard — Tue, 15 Oct 2019 11:13:57 GMT

Thank you for replying 🙂