Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Merge two row of a table in Qlik sense

Hi,

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

My data looks something like the below :

NameFirstnameCodeValid
Name 1Firstname1Code1yes
Name 1Firstname1Code2yes

and i want as a result

NameFirstnameCodeValid
Name 1Firstname1Code1, Code2yes

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

Tags (3)
1 Solution

Accepted Solutions
MVP
MVP

Re: Merge two row of a table in Qlik sense

In the Dimension, you can try this

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

3 Replies
MVP
MVP

Re: Merge two row of a table in Qlik sense

Concat is the right way to go...

LOAD Name,

     Firstname,

     Concat (Code, ', ') as Code,

     Valid

FROM ....

Group By Name, Firstname, Valid;

MVP
MVP

Re: Merge two row of a table in Qlik sense

In the Dimension, you can try this

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

Not applicable

Re: Merge two row of a table in Qlik sense

This one actually worked the way I wanted to ! Thanks