Converting Y/N (or null) Data to 1/0 (or null)

[tsbryan]

I have a very large dataset that needs Y/N turned into 1/0for further analysis. There are roughly 100 variables to recode all at the same time. An additional issue is that there are also (null) values and I would like for those to remain (null)

I've attached a sample snippet of the data.

I've fiddled around with ToNumber in the Multi-Field formula but everything I have tried has not given the desired output.

Any help would be greatly appreciated.

[binu_acs · Accepted solution]

@tsbryan This can be achived using the Multi-Field formula tool

[tsbryan]

Many thanks!