Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Concatenating fields with common key (Different records)

Hi Everyone,

I am trying to concatenate fields from different records, the "Lot" that share the same  "Order" number.

for example:

Order   | Lot

1          | 123

1          | 1234

2          | 456

2          | 789

i'd like the result to be:

Order  | Lot

1         | 123, 1234

2         | 456, 789

any ideas?

Thanks!

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: Concatenating fields with common key (Different records)

Hi Roi, concat() function can do that:

LOAD Order,

     Concat(Lot, ', ') as Lot

Resident TableName

Group by Order;

View solution in original post

2 Replies
Highlighted

Re: Concatenating fields with common key (Different records)

Hi Roi, concat() function can do that:

LOAD Order,

     Concat(Lot, ', ') as Lot

Resident TableName

Group by Order;

View solution in original post

Highlighted
Creator
Creator

Re: Concatenating fields with common key (Different records)

Thanks for the help Ruben