Merge two row of a table in Qlik sense

[#1]

Hi,

I need to merge some cells from differents rows from a table, is it possible?

My data looks something like the below :

Name	Firstname	Code	Valid
Name 1	Firstname1	Code1	yes
Name 1	Firstname1	Code2	yes

and i want as a result

Name	Firstname	Code	Valid
Name 1	Firstname1	Code1, Code2	yes

I was thinking about using the "concat" function, but it seems it wrong the dimension...

is there any way to do this with many lines?

Thanks

[sunny_talwar]

Concat is the right way to go...

LOAD Name,

     Firstname,

     Concat (Code, ', ') as Code,

     Valid

FROM ....

Group By Name, Firstname, Valid;

[sunny_talwar · Accepted solution]

In the Dimension, you can try this

Aggr(Concat(DISTINCT Code,  ', '), Name)

[#4]

This one actually worked the way I wanted to ! Thanks

[Amit]

Thank you @sunny_talwar great answer! Helped me out. Cheers.