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.
You should be able to use a Multi-Field tool to accomplish this!
1. Select the columns that contain your Yes/No answers
2. Uncheck the box for "Copy Output Fields Add"
3. Check the box to "Change Output Type to" and select Bool
4. Use the expression IIF([_CurrentField_]="Yes",1,0) to convert Yes to 1 and No to 0 . NOTE: if you have null options in there that need to stay null, then add another IF clause to handle, such as IIF([_CurrentField_]="Yes",1,IIF([_CurrentField_]="No",0,Null()))
I selected all Text fields to apply that expression to and did not copy output fields as new fields. You might have to increase the size of the field and then use a Select to change the field type after this, but this should get you the true and false values in any text columns. Hope this helps!
@NicoleJohnson thank you - I want to create a reusable macro that will auto detect which columns are filled with "Yes" and "No" values, and use that list of columns to feed into the the multifield formula tool. I think I solved the first piece (auto detecting yes/no columns) and you have the third piece (a multi-field formula), but we are missing the second piece, which connects the two