Comparing two data sets at Column level

bhakuniv
bhakuniv Registered Posts: 9 ✭✭✭✭

Hi All

I am trying to compare two datasets with the same columns and finding out the differences at a column level. The goal is to identify the number of rows(defined by a unique key) that have an exact match at each column.

refer sample data below

Dataset 1

IDNameAgeCountry
1ABC21USA
2XYZ23UK
3DEF67CHN

Dataset 2

IDNameAgeCountry
1ABC22USA
2XYZ23UK
3DEF67SWZ

Output

Count of ID
Name3
Age2
Country2

Thanks

Answers

Setup Info
    Tags
      Help me…