Comparing Data Sets and Showing the Differences

[ollicai]

Hi all, 

I have been having some trouble finding a simple way to compare two data sets and highlight any difference from File 1 to File 2. The column headers will always stay the same, however, the row values may differ and is thus what I need to highlight. Thank you in advance for the help!

Example:

File 1:

Origin	Price	Color
New York	12	Yellow
Paris	15	Blue
London	17	Green

File 2:

Origin	Price	Color
New York	12	Yellow
Milan	15	Blue
London	17	Green

The output file should somehow show the below difference below.

Origin	Price	Color
New York	12	Yellow
Milan	15	Blue
London	17	Green

[BRRLL99]

This is Simple

Step : 1

Join File 1 and File 2 on Origin

Step: 2 

Union J and R anchor 

You will get your expected output