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?
IF Contains([Where did you hear about us)], "Other") THEN "Other" ELSE __________ ENDIF
Looking to fill in the blank above 🙂