syntax on multifield tool

[lliberm1]

the general question is i have both string and numeric fields that i want to compare (to confirm strings are equal and numeric is within a margin of error).

i dont want to add a ton of formulas comparing one field specifically to the other field individually so i thought a multifield tool may be helpful since the columns are similarly named just with a suffix.

fields are like this... 1, 2, 3, 4...1 aaa, 2 aaa, 3 aaa, 4 aaa... and im trying to add new fields 1 var, 2 var, 3 var, 4 var etc to confirm differences (if numeric) or they match if string.

i am trying to add output logic to compare two columns (a multifield tool for each of the numeric and string groups)

is there a way to reference the comparison using something like this...

if [_CurrentField_]=[_CurrentFieldName_+" aaa"] then...

[atcodedog05]

Hi @lliberm1 

Multi-field formula tool can reference only one dynamic column at a time as far as I know. Hence below formula wouldn't work. You would need to use a workflow like below which is dynamic with n number of columns.

Workflow:

Hope this helps : )