database wide y to 1 and n to 0 replacement

[ffery]

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

Col1	Col2	Col3	Col4	Col5	Col6	Col7	Col8
n	n	n	n	n	n	n	n
n	n	n	n	y	n	n	n
n	n	y	n	y	n	n	n
n	n	y	n	n	n	n	y
y	n	n	n	n	n	n	n
n	n	y	n	n	n	y	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
y	n	y	y	n	n	n	n
n	n	n	n	y	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	n	n	n	n
n	n	n	n	y	n	n	n
n	n	n	n	n	n	n	n

[JosephSerpis · Accepted solution]

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 solution]

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