
Compare Data in 2 Sources
Hi All,
My requirement is to create a report after comparing data between two sources and create a report. Is it possible using EDQ?
Eg.
Source A
EMP_NUM NAME CITY
1 JO Dubai
Source B
EMP_NUM NAME CITY
1 JO Newyork
My report should compare each employee raw by raw and create a report like below
A.EMP_NO | B.EMP_NO | EMP_NO_MATCH | A.NAME | B.NAME | NAME_MATCH | A.CITY | B.CITY | CITY_MATCH |
1 | 1 | Match | Jo | Jo | Match | Dubai | Newyork | Mismatched |
Like
Follow
3replies