SWITCH text from YES to NO and NO to YES in columns...

[ShantanuDagar]

Hey.

I have created a value checking workflow in alteryx which basically validates the values in 1 column based on a multiple conditions and sub-conditions.

Then the data is segregated in 2 parts. The first part is collection of fully correct data. While the second part is incorrect data.

But incorrect data also has just 2 possible types. (Example Yes or No. If yes is incorrect then no must be correct and vice versa)

So I want to switch all the "yes to no" and "no to yes" in that particular column to make it correct data.

Tried doing this using conditional if expression but it's throwing up errors.

[DataNath · Accepted solution]

If I'm understanding this right, you just want to switch all 'Yes' to 'No' and vice versa? @ShantanuDagar 

[MarqueeCrew · Accepted solution]

@ShantanuDagar ,

 let's try this:

Swich([Initial Flag], "Unknown", "Yes", 'No', "No", 'Yes')

 cheers,

mark

[ShantanuDagar]

works perfect.