How to concatenate the field values?

[RRR1]

Hi experts,

I am having the following requirement.

P_ID, P_Name

1, a

1, b

2, c

2, d

2, e

2, f

Desired Output as follow:

P_ID, P_Name

1, a:b
2, c:d:e:f

Can you please help us to implement the same.

Thanks in advance.

Regards,

Ranjith.

[PrashantSangle]

where do you want this in front end or back end script

1: front End

take table

dimension > P_ID

Measure > concat(P_Name,':')

2: back end Script > try below script

Load P_ID,Concat(P_Name,':') as P_Name group by P_ID;
Load * Inline [
P_ID, P_Name
1, a
1, b
2, c
2, d
2, e
2, f
];

Regards,

Prashant Sangle