Find and Replace Values

[djdj]

Hi Team,

I'm having difficulty utilizing the Find/Replace tool! I'm trying to convert a massive list of Yes/No to 1/0, respectively. I have hundreds of thousands of lines to modify, so I'm unable to simply use the Find/Replace tool in Excel because it will take too long.

Please see below for a simplified version of what I'm working on, and please recommend any tools in Alteryx that would be able to change a list of Yes and No to a list of 1 and 0. 

Thanks all!

Djdj

[ivoller · Accepted solution]

Formula Tool with numeric type followed by Select to remove original field and rename new field?

iif([field]=“Yes”,1,0)