Concat data in the same column if rows are the same?

[user467341]

Hi everyone, I want to concat my data in the same column if the rows are the same. Let me show an example:

Tis is my table.

The output I want is:

You can see that the LEFT column data are concat with a ','. They are group based on the ID, category and ref.

Can this be done in the EXPRESSION? I do not want to modify anything at my LOAD script.

Thank you.

[MayilVahanan]

Hi

Same thing, you can achieve in Front end by Concat function

Dim: ID, Category, Ref

Exp: Concat(Distinct Left, ',')

[QlikSenseEnthusiast]

Hi ...

Try this below code...It will work definitely

FACT:

Load 

ID,

Category,

Reference,

Concat(Distinct Left, ',') as Combined_Data

FROM [lib........](qvd)

Group BY 

ID,

Category,

Reference;

Mark this as Solution if it helps...

[user467341]

Hi Mayil,

Thanks for your reply. I tried but am receiving error.

My current expression is this - IF(ISNULL(category),Left).

I tried to put the CONCAT infront but got error.

[MayilVahanan]

Hi

Try like below

Concat(Distinct IF(ISNULL(category),Left), ',')

[user467341]

Hi Mayil,

I tried that but got

Expression did not show any issue though...

[MayilVahanan]

Hi

It should be expression not dimension 

[user467341]

Hi Mayil,

Sorry what do you mean? I am putting this at the table chart dimension side (I do not want to edit the load script).

Where can I find the place to put your line in expression?

[vinieme12 · Accepted solution]

Add a calculated dimension as below

= Aggr( Concat(Distinct Left,',') , ID,Category,Ref )