comparing multiple fields within a table

Question

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 Answer

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