Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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;
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;