Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a straight table object and use ID as dimension and =concat(distinct Name1, ',', Name1) as expression
Data:
LOAD ID,
Concat(distinct name1 ,',') as name1
FROM table
group by ID;
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: