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 |
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