Compare Certain Columns from Different Excel Workbooks

[Conner97]

Hello,

I am trying to compare various columns, around 14 total, from 2 different workbooks. Both excel files contain different information and are presented differently, but they do share 14 columns with the same information, all based upon the same Asset ID#. My goal is to bring in the Asset ID #s that they share, then compare the 14 columns from the first file, to the same 14 files from the second file, but they are located in different spots in the excel files. I was thinking of joining them, but wanted to know if there was a better way to achieve the desired result. I appreciate any help!

[vizwithdan]

Hi @Conner97 ,

The best way to achieve this is indeed Join them together on the Asset ID#.
I would however use 2 input files (one for each data source) and place a Select tool after each Input tool and rename the fields so they are named the same where applicable.
This should give you what you need.

Thanks
@VizWithDan