I am trying to compare two data sets which have a lot of values in common. I have browsed the community but nothings is working for me. I want to compare for each employee, if they have the same Project ID and corresponding Hours on both data set. I would just need a list of where they are different. I have tried several workflows but somehow it is giving me duplicate rows within the Project ID column and I cannot further. Thanks for your help.
Data set 1
| Employee Name | Emp ID | Project ID | Project Type | Hours |
| A1 | 1 | 287026-21 | C | 40 |
| A2 | 2 | 393417-01 | C | 40 |
| A3 | 3 | 303955-04 | C | 40 |
| A4 | 4 | 281392-03 | C | 32 |
| A4 | 4 | 264592-92 | P | 8 |
| A5 | 5 | 365196-13 | P | 40 |
| A6 | 6 | 287026-21 | X | 40 |
| A7 | 7 | 364636-05 | X | 40 |
| A8 | 8 | 287026-38 | L | 40 |
| A9 | 9 | 364636-04 | F | 16 |
| A9 | 9 | 394642-08 | C | 24 |
| A10 | 10 | 394642-08 | C | 40 |
| A11 | 11 | 281392-03 | C | 40 |
Data set 2
| Employee Name | Emp ID | Project ID | Project Type | Hours |
| A1 | 1 | 287026-21 | C | 32 |
| A1 | 1 | CAP/DFZ-00 | Z | 8 |
| A2 | 2 | 393417-01 | C | 40 |
| A3 | 3 | 303955-04 | C | 40 |
| A4 | 4 | 281392-03 | C | 32 |
| A4 | 4 | 264592-94 | P | 8 |
| A5 | 5 | 365196-13 | P | 40 |
| A6 | 6 | 287026-20 | X | 40 |
| A7 | 7 | 364636-05 | X | 40 |
| A8 | 8 | 287026-38 | L | 40 |
| A9 | 9 | 364636-04 | F | 16 |
| A9 | 9 | 394642-08 | C | 24 |
| A10 | 10 | 394642-08 | C | 40 |
| A11 | 11 | 281392-03 | C | 40 |
