Forum Discussion
Arul
Super User
Super UserNew Column Derivation
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. T...
Arul , a new column like
new column =
Switch ( [Final RM Level],
"RM1",[RM1],
"RM2",[RM2],
"RM3",[RM3],
"RM4",[RM4],
"RM5",[RM5]
)
ArulSuper User
Super UserIn 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
amitchandakSuper User
Super UserArul , a new column like
new column =
Switch ( [Final RM Level],
"RM1",[RM1],
"RM2",[RM2],
"RM3",[RM3],
"RM4",[RM4],
"RM5",[RM5]
)
- Arul