Need Help

[gireesh1216]

Hi Team,

I have straight table Like Below,

I am calculaing Exceptions field in straight table like: conact(Exceptions,',')

Indiactor	Type	Emp ID	Cycle	Sox	Exceptions
Y	App	1216	Cycle 1	Yes	EX1
N	App	1216	Cycle 1	Yes	EX2,EX3,EX4

Now i want like data below:

Indiactor	Type	Emp ID	Cyce	Sox	Exceptions
Y,N	App	1216	Cycle 1	Yes	EX1,EX2,EX3,EX4

[Anil_Babu_Samineni]

Will work, If you provide work file

[gireesh1216]

Hi Anil,

Please take above data only.

All fields data are same except "Indicator" and "Exceptions" data.

[effinty2112]

Hi Gireesh

In your straight table have Type, Emp ID, Cycle & Sox as dimensions.

Measures: concat(Indiactor,',') and concat(Exceptions,',').

You can drag the expression column for Indiactor to the left to get the order of columns you want.

Hope this helps

Andrew

[Anil_Babu_Samineni]

This?

[tresesco]

This?

[qv_testing]

Use concat function for both Dimension and Expression