Convert listdata into CSV string grouped

Wed, 11 Mar 2015 14:35:03 GMT

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:

required result:

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

Re: Convert listdata into CSV string grouped

Gysbert_Wassenaar — Wed, 11 Mar 2015 14:38:52 GMT

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

from ...source...

group by contract_ID;