0Compare 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 |
-
We can use an Incorta Materialized View for this purpose. I have a script but the format is different.
The table will have the key columns and the column name and the column value when there are difference.
-
my sources are excel files
-
IncortaVi The MV assumes the data are loaded into Incorta. If the Excel files are already loaded into Incorta, the comparison report can be generated from the MV.
-
