Compare Data in 2 Sources with a primary key

vdataqlalt

My requirement is to create a report after comparing data between two source ie compare employee data between two sources and identify the employee data is in sync between two sources.

SOURCE A

EMP_NUM   NAME    CITY

1                          JO             Dubai

2                          KO             Paris

SOURCE B

Source B

EMP_NUM   NAME    CITY

1                      JO            Newyork

2                      KO           Paris

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
2	2	Match	KO	KO	Match	Paris	Paris	Match

how can we do this? 

BrandonB

I normally like to do a transpose/crosstab approach as seen below because it makes it easier to read across your data and filter if desired. Workflow is attached for reference. 

matching.yxmd