Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert listdata into CSV string grouped

I am looking for a solution to convert list data into a CSV string grouped in this example on Contract_ID.

This is an example of the list data:

contract_ID name type
1 Paul abc
1 Benno def
2 kees abc
2 Ron ghi

required result:

1 Paul:abc, Benno:def
2 kees:abc, Ron:ghi
1 Solution

Accepted Solutions
Gysbert_Wassenaar

load contract_ID, concat( name & ':' & type, ',') as grouped

from ...source...

group by contract_ID;


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

load contract_ID, concat( name & ':' & type, ',') as grouped

from ...source...

group by contract_ID;


talk is cheap, supply exceeds demand