Replace FALSE with a blank and true with an X

comckinley

Hi all,

I have one input file and I am simply looking to do a replace all where in one column it says FALSE, I'd like for it to be blank or " ", and if TRUE then it says "X". I can easily do it in excel and assume I am just overlooking the method to do so in Alteryx as I must do this multiple times a day.

Thank you for any guidance!

jamielaird

Hi @comckinley 

You can use a Formula tool as follows:

IF [Field] = "FALSE" THEN "" ELSE "X" ENDIF

This assumes that all the rows have a value of FALSE or TRUE and that the field has a string type.

If you want to be more explicit and return a null if the field didn't contain FALSE or TRUE use the following:

IF [Field] = "FALSE" THEN "" ELSEIF [Field] = "TRUE" THEN "X" ELSE Null() ENDIF

Have a play around with the Formula tool and I'm sure you will get the hang of it.