Compare Data Set

[vdataqlalt]

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

[messi007 · Accepted solution]

@vdataqlalt,

Please see below:

Attached the workflow.

Hope this helps!

Regards