Forum Discussion
Same If function for several columns to populate a new column
Hi,
I have this table with Client info about an assessment. In the table 56 columns has fields that has 0,1,2,3 value, where 0,1 represents Nonactionable & 2,3 represents Actionable.
I am trying to create a new Column thet will have Actionable & Nonactionable category based on the numbers in those 56 Columns.
I am doing it by adding a conditional column (See the Image), this way I have to create 224 conditions...
My question is , is there a simple way to do this?
Thanks,
panda2018
Anonymous -
Something like
= Table.AddColumn(#"Changed Type", "Custom", each if [Column1] = 0 or [Column1] = 1 then "Action" else if [Column1] = 2 or [Column1] = 3 then "Non" else "N/A")
7 Replies
- ChrisMendoza
Resident Rockstar
Anonymous -
My guess is that you should unpivot the columns and then write an IF ( OR ( 1, 2), "NonActionable", "Actionable" )
Thank you ChrisMendoza so much!!
So If I have no Value & I want to replace with N/A wht should be my statement?
- ChrisMendoza
Anonymous -
Something like
= Table.AddColumn(#"Changed Type", "Custom", each if [Column1] = 0 or [Column1] = 1 then "Action" else if [Column1] = 2 or [Column1] = 3 then "Non" else "N/A")
- Nathaniel_C
Community Champion
Anonymous ,
See the pics... First you could change the Operator, which it cuts it to 2 conditions. You could add a third if you want to test other numbers. Just do one column, and see the second picture, you can see the code. Copy the code and paste it for as many columns as you have, or using the interface may be easier. Or use Chris' suggestion.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
