topic Re: comma separated value based on single field in QlikView

comma separated value based on single field

vinod2086 — Wed, 25 Nov 2020 16:16:04 GMT

Hi friends,

i have a requirement

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 — Fri, 15 Apr 2016 06:21:30 GMT

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

Kushal_Chawda — Fri, 15 Apr 2016 06:26:51 GMT

Data:

LOAD ID,

Concat(distinct name1 ,',') as name1

FROM table

group by ID;

tamilarasu — Fri, 15 Apr 2016 06:39:07 GMT

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: