Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Employee
Employee

Concatenate some rows

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:

row.JPG

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Concatenate some rows

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;

View solution in original post

1 Reply
MVP
MVP

Re: Concatenate some rows

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;

View solution in original post