database wide y to 1 and n to 0 replacement

Question

hi

I have large database with multiple columns - all have n or y

I want to replace all y with 1 and all n with 0

tried a few formulas no luck

Col1Col2Col3Col4Col5Col6Col7Col8nnnnnnnnnnnnynnnnnynynnnnnynnnnyynnnnnnnnnynnnynnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnynyynnnnnnnnynnnnnnnnnnnnnnnnnnnnnnnynnnnnnnnnnn

JosephSerpis · Accepted Answer

Hi @ffery a Multi-Field tool might be an approach as it has the ability to apply formulas across multiple columns and apply them to dynamic/unknown fields. I mocked up a workflow let me know what you think?

atcodedog05 · Accepted Answer

Hi @ffery ,

Here is a workflow for the task.

Use this formula in Multi-Column Formula tool. Select all columns

IF [_CurrentField_]='y' THEN 1
ElseIF [_CurrentField_]='n' THEN 0 
Else Null() 
ENDIF

Input

Output

Hope this helps : )

If this helps please mark this post as a solution