topic Re: Concatenate some rows in QlikView

Concatenate some rows

hca — Tue, 16 Feb 2016 09:09:13 GMT

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 — Tue, 16 Feb 2016 20:01:04 GMT

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;