0

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
3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • 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.

    Like
  • my sources are excel files 

    Like
    • 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.

      Like
Like Follow
  • 5 mths agoLast active
  • 3Replies
  • 28Views
  • 3 Following

Product Announcement

Incorta 5 is now Generally Available