Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Convert listdata into CSV string grouped

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

from ...source...

group by contract_ID;


talk is cheap, supply exceeds demand
1 Reply
Highlighted

Re: Convert listdata into CSV string grouped

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

from ...source...

group by contract_ID;


talk is cheap, supply exceeds demand
Community Browser