This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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