Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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

Highlighted
Atom

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!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
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
Highlighted
Meteoroid

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


Thank you very much!!

Labels