Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
load
concat(Cause,', ') as Causecombine
resident yourdata;
Regards
Something like this?
Test:
NOCONCATENATE
LOAD Concat(Cause, ', ', Sort) AS Causes
INLINE [
Cause, Sort
Missing value, 1
Missing signature, 2
Dataformat not correct, 3
];
Thank you so much Martin.
Thank you for replying 🙂