How to compare data from 2 excel files keeping 1 column as a base (ex: Record ID)

[nidhinks]

How do u compare data from 2 excel files with multiple columns, keeping one data column as the base?

[binuacs]

@nidhinks Use a join tool to compare the fields

[kelsey_kincaid]

Hi @nidhinks ,

I recommend using a Transpose tool and then a Join tool. In the Transpose tool you can 'group by' the data column you want to use as the base, then join on that column + 'Name'. After that you can use a filter tool to identify which values match and which do not.