IF CONTAINS THAN REPLACE ENTIRE CELL, IF NOT DONT CHANGE ANYTHING

[mric3]

Hello everyone,

Drawing a blank on this one - I have a column of survey data with one of the options is "Other" with free text attached to it. There are few "Other" options so we are going to group all of them in one big "Other" group to scope them out. My goal is to find cells in that column that contain the word "Other" and replace the entire cell with "Other" (obviously a simple IF CONTAINS) but then if the cell does not contain "Other", how do I tell alteryx to not make any changes to that cell?

My formula:

IF Contains([Where did you hear about us)], "Other") THEN "Other" ELSE __________ ENDIF

Looking to fill in the blank above 🙂

Thanks!

[Thableaus]

IF Contains([Where did you hear about us)], "Other") THEN "Other" ELSE [Where did you hear about us)] ENDIF

Just repeat your field and It Will stay the same.

Cheers

[mric]

Wow.... can you tell i'm a beginner? 🙂 

Thank you very much!!