Discussion Board for collaboration on QlikView Scripting.
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?
Go to Solution.
in script you can use a group by
maxstring(email) as email,
// add all the other fields
group by _KEY_custom;
View solution in original post