topic Re: How to Group Cells? in QlikView

How to Group Cells?

Fri, 28 Feb 2014 10:47:25 GMT

In script I need some help to combine cells. Column REASON includes the values to be grouped into one cell by column "KEY". Below example.

Is there any way to do it?

Main column:

To be:

er_mohit — Fri, 28 Feb 2014 10:51:52 GMT

load

Key,Concat(Reason,'|') as Reason

from table group by Key;

hic — Fri, 28 Feb 2014 10:52:58 GMT

The Concat() function does exactly this. It can be used either in the script or in the QlikView UI.

Concat(distinct REASON, '|')

HIC

alexandros17 — Fri, 28 Feb 2014 10:54:29 GMT

LOAD Key, Concat(REASON,'|') as reasonAll

Resident Test

Group By Key;