Hi,
My first data source is
| EMP_ID | Name | DEPT |
| 1 | Jose | IT |
| 2 | Anna | IT |
My second data source is
| EMP_ID | Name | DEPT |
| 1 | Jose | BI |
| 4 | Steve | IT |
Now I need to compare Source 1 against Source 2 with the primary key(EMP_ID) and ensure that employee data is in sync.so the report should be similar like below.
Is it possible?
| Match_Status | A.EMPI_D | B.EMP_ID | EMP_ID.Match | A.Name | B.Name | Name.Match | A.DEPT | B.DEPT | DEPT.Match |
| In Both | 1 | 1 | Match | Jose | Jose | Match | IT | BI | Mismatch |
| In A Not B | 2 | null | Mismatch | Anna | null | Mismatch | IT | null | Mismatch |
| In B Not A | null | 4 | Mismatch | null | Steve | Mismatch | null | IT | Mismatch |
