SOLVED
Compare Data Set
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
vdataqlalt
6 - Meteoroid
‎02-11-2021
12:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Datasets
1 REPLY 1
15 - Aurora
‎02-11-2021
12:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
