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...
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 : )