Comparison of two tables to get unmatched values

[Anonymous]

Hi,

I have two tables to compare all the columns. then find the unmatched vales like

Table 1:

ID	Name	Pincode	Country	Age	Work
100011	Alex	2012	France	32	YES
100012	Mari	1097	Germany	33	NO
100013	Mia	3455	USA	54	YES
100014	Randi	6788	Australia	41	YES
100015	Christian	7083	Norway	63	NO
100016	Sam	2444	Sweden	63	NO
100017	Kari	1781	India	74	YES
100018	Siri	1781	India	84	NO
100019	Linda	6354	China	47	YES
100020	Nicolai	8364	Japan	28	NO

Table 2:

ID	Name	Pincode	Country	Age	Work
100011	Alex	2012	France	43	YES
100012	Mari	1097	USA	31	NO
100013	Mia	3455	USA	54	YES
100014	Kari	6788	Australia	41	YES
100015	Christian	7083	Norway	63	NO
100016	Sam	2441	Sweden	63	NO
100017	Kari	1781	Canada	74	Yes
100018	Siri	1781	India	84	NO
100019	Linda	6354	China	57	NO
100020	Nicolai	8364	Japan	28	No
100021	Lars	4454	Norway	54	Yes

conditional columnResult in visual table

Table visual.

ID	ErrorType	Table1 value	Table 2 value
100011	Age	32	43
100012	Country, Age	Germany,33	USA, 31
100014	Name	Randi	Kari
100016	Pincode	2444	2441
100017	Country	India	Canada
100019	Age	47	57

How can i achieve this?

I tried unpivot table coulmns and merge two tables on ID. 

Then added a conditional column to compare each column from Table1 to Table 2.  But the result in visual table giving me all the comparisions. 

How can i get only differences?

[amitchandak]

@Anonymous , If you want a new table  you can try

except(TableA, TableB)

All record A not in B

[Anonymous]

Thank you for the reply. i have solved my issue.