How to concate single Colum values

[#1]

this is input

Customer ID	Location
101	India
101	USA
102	USA
103	UK
104	Germany
104	UK
104	India

i want output like that o/p:

Customer ID	Location
101	India,USA
102	USA
103	UK
104	Germany,UK,India

please let me know do this output , can u provide the script?

Regards,

Satya

[pover · Accepted solution]

Satya,

Use the concat() function as an expression in your chart.

concat(Location,', ')

Regards.

[#3]

Hi,

really great, now it is working thanks for your inputs.

Regards,

Satya

[martinpohl]

try this:

load

[CUSTOMER ID],

concate (Location,', ') as ConcatLocation

resident loadedtable;

Regards