Concatenate some rows

[hca]

I have a table where I would like to concatenate some of the rows, the ones that have more than one row per _KEY_custom.

This is how my table looks like:

I would like the rows (in this case with _KEY_custom 1) to be concatenated so that I will only have one row including email cat. and message.

How should I write such expression?

[maxgro · Accepted solution]

in script you can use a group by

load

     _KEY_custom,

     maxstring(email) as email,

     maxstring(.....),

     // add all the other fields

     .....

from

     sometable

group by _KEY_custom;