Columns to change

[priyarane]

Hi Community,

I have data like,

Dim	Val
A	E
B	D
C	E
D	D

and I want the out in seperate column like if Val = 'E' and it dim value should come like sum(C) as C

for Ex:

Dim1	Val
sum(A) As A	E
B	D
sum(C) As A	E
D	D

[aarkay29]

Hi Priya,

further question! so if value is E then, do you want to sum up the values for E or rename the value as sum(Value) ??

[avinashelite]

could you post a better example??

[nitin_01]

Hi Priya,

Its confusing for us to understand, please post d desired output in tabular form or in a comprehensive way to understand us.

Regards,

Nitin.

[priyarane]

No, I am not sum up the values I just need name like sum(C) As A so this one I will use in other select statement to sum up.

Concat(Dim1,',')  as select list

and I will create variable

Let vSelectList= peek('Select_List',0,'Temp_SelectList');

And variable I can use in select statement.

[aarkay29 · Accepted solution]

May be this

If(Val='E','Sum('&Val&') as '&Val,Val) as Dim1

[avinashelite]

still not clear ...you could try with the inline table to get the desired format