comparing multiple fields within a table

[jogianni]

I am joining two tables on a single field. They both contain address city state and zip information. I would like to compare each field and set a flag if they are not the same. Example if address and right_address don't match for the same ID, then address_change field would be set to 1.

I've guessed the first step is a simple join on the ID. After that, is there a way to do this in one or two steps? or is it just one long multi-field formula?

[Greg_Murray · Accepted solution]

Hi, 

see below. You can add a formula tool after the join tool (not pictured) and use an if statement to indicate whether the address fields contain the same value. 

Hope that helps.

Greg

[jogianni]

Hi Greg,

Yes thank you for the response. I figured I could do it with a formula but I was just wondering if there was a pre-built 'compare' tool I wasn't aware of.