How to merge different values in to a single cell of a dimension?

[#1]

Hi All,

We have a straight table which has around 15 fields out of which 14 dimension and 1 expression.

we are facing an issue in displaying this chart in the way the End user wants.

Problem is, for few records, all 13 dimensions have single value where as one dimension(Called Root Cause) has 4 values because of which the lines get duplicated 4 times.

Data looks something below:

ID	Name	Root Cause
2	Site	Leak
2	site	damage
2	Site	Dirty
2	Site	Rejected

But End Users want to see it like below:

ID	Name	Root Cause
2	Site	Leak, Damage,Dirty,Rejected

Could someone please help with the above?

Thanks & Regards

Jyothi

[sunny_talwar]

Instead of using the Root Cause as a dimension, use it in a expression and use the following expressions:

=Concat([Root Cause],  ',')

HTH

Best,

Sunny

[sunny_talwar · Accepted solution]

PFA a sample application:

Best,

Sunny

[Anonymous]

use

=concat([Root Cause],',')

See below app

Thanks

BKC

[#5]

Hi Jyothi,

Concat([Root Cause], ',') as RootCause

Group by ID

[#6]

Thanks alot for the Quick response. It worked

[#7]

Hi Avinash,

I tried your suggestion too. but it does not let me do this in the script. I get an error saying Invalid Expression.

[sunny_talwar]

Not a problem! Glad to help.

Best,

Sunny