comma separated value based on single field

[vinod2086]

Hi friends,

i have a requirement

ID	Name1
1	Anil
2	Sunil
2	Raju
3	ravi
4	vinod
4	ramu
3	krishna
1	raja
2	muni

for single id here it is displaying multiple name instead of displaying multiple values user wants single row and comma separated for ex

id 1 is displaying 2 times user expecting like this

id  name1

1  anil,raja

Thanks in advance

[Gysbert_Wassenaar]

Create a straight table object and use ID as dimension and =concat(distinct Name1, ',', Name1) as expression

[Kushal_Chawda]

Data:

LOAD ID,

           Concat(distinct name1 ,',') as name1

FROM table

group by ID;

[tamilarasu]

Try,

Data:
Load ID,
Concat(Name1, ', ') as Name1,
Concat(No,', ') as No,
Sum(Sal) as Sales
FROM

(ooxml, embedded labels, table is Sheet1) Group by ID;

Output: