topic Concatenate associated values in QlikView

Concatenate associated values

Thu, 28 May 2015 10:35:17 GMT

How can I concatenate a list of values to an associated set of data? Whilst retaining the original values

For example

Table 1

Meeting notes	Meeting ID
gdggdfgdfsgdfgdfgdfggdfgdfg	12
dfgdfgfnhkuykjndfdv	13
dgwgrenfgjtyikir	14

Table 2

I need the list of attendees concatenated as per the 3rd column. I still need to retain table 1 and table 2 separately though.

Is it best to concatenate it on the front end? Or is it best to do it in the load

Meeting notes	Meeting ID	Attendees
gdggdfgdfsgdfgdfgdfggdfgdfg	12	Bob, Jack
dfgdfgfnhkuykjndfdv	13	Sam, Alex, Jane
dgwgrenfgjtyikir	14	Bob, Alex

rubenmarin — Thu, 28 May 2015 10:39:00 GMT

Hi Alex, try this:

Table1:

LOAD [Meeting notes], [Meeting ID] from...;

Left Join (Table1)

LOAD [Meeting ID], Concat(Attendee, ', ') as Attendees from .... Group by [Meeting ID]

Fri, 29 May 2015 07:31:25 GMT

It was as simple as adding another expression

concat(distinct Attendee,',')