Compare two fields for unique match

Hello,

Need help on comparing two fields and determining if its a match, if match is true than (in a new field) replace with true, else false.

Tried the If statements but its only replacing with the INDV ID if it matchs, else putting the FAM ID.

Please see example below.

Fam ID INDV ID

123 123 Y

124 934 N

125 564 N

Thanks for the help

Preparation

Expression

Accepted answers

JohnJPS

The "Formula" tool will create a new field; name it whatever you prefer; and make it type boolean or string; then in the "Expression" area, test equality and set the value of the variable however you prefer.

JordanB

Hi,

Please find an example workflow attached.

Let me know if this is what your were looking for.

Best,

Jordan Barker

Client Service Representative

Matching Fields Example.yxmd

JohnJPS

If you leave it as a string, then you can drop the zero characters easily; then convert to integer prior to compare; please see attached and modify as needed.