group table field into list inside a field

Tue, 02 Dec 2014 00:47:43 GMT

I want to take a table group it by a few fields and create a list from another field. Below is an example of what I am trying to accomplish in my script:

document	user	sheet
a	ted	sh1
b	ted	sh2
c	ted	sh3
a	ted	sh1
b	ted	sh2
c	steve	sh3
a	steve	sh1
b	steve	sh2
c	steve	sh3
a	steve	sh4

From a table like the one above I want to build a table like the one below.

Header 1	Header 2	Header 3
a	ted	sh1,sh1
b	ted	sh2,sh2
c	ted	sh3
a	steve	sh1,sh4
b	steve	sh2
c	steve	sh3,sh3

Re: group table field into list inside a field

simenkg — Tue, 02 Dec 2014 01:06:37 GMT

Table2:

Load distinct

document as [Header 1],

user as [Header 2],

concat(distinct sheet,',') as [Header 3]

resident Table1

Group by document, user;

topic group table field into list inside a field in QlikView

group table field into list inside a field

Re: group table field into list inside a field