New Column Derivation

[Arul]

Hi all,

I have table like below, wherein I need to create new column based on the value in Final RM Level. I need to get the value from respective column and need to put into new column.

Thanks,

-Arul

[amitchandak]

@Arul , the logic is not very clear.

I thought of , but that if not work 

RM1 = if([final RM Level] = "RM1",[self score] , 0)

[Arul]

@amitchandak ,

It does not helps. I'm looking for single column for the given value in the final RM column for each row as a new column.

[amitchandak]

@Arul , I am clear on the logic. I have just given the formula that can be possibly there based on the description.

Please explain me logic of output column, I will try the formula

[Arul]

@amitchandak ,

In the above table I have RM1,RM2...etc., columns, what I need is I need to get the value from particular column based on the value which is mentioned in Final RM Level.

I hope you got my problem.

Thanks,

-Arul

[amitchandak · Accepted solution]

@Arul , a new column like

new column =
Switch ( [Final RM Level],
"RM1",[RM1],
"RM2",[RM2],
"RM3",[RM3],
"RM4",[RM4],
"RM5",[RM5]
)

[Arul]

@amitchandak ,

It helps thanks.