Compare 2 dates table and find difference

[Lumjing]

Hi can some one help me in getting the below output. I have a table thats keep updating Table A daily. but the problem is every time the new table comes in when compared with the Table A there are some differences with the record id or name or sales code. I want to find out the values that has changed. Please find attached a workflow after joining the table A and Table b I want to compare the unmatched

and put them in one row to find out the difference.

For example :

1) In Table A 1st item when compared with 21-5-2025 table we find that Name and Sales code match ie A and 10 so we will highlight bar number 1 and 2.

2) In table A since 5 and 5 are matching the mismatching column Name and sales code are highlighted

3) In Table A since sales code 45 is matching with table B. Bar number and Name are highlighted

4)In Table A since bar and sales code ie 9 and 22 are matching the difference Name is highlighted

Table A					Table B					Output
Bar number	Name	sales code	Sale date		Bar number	Name	sales code	Sale date		Bar number	Name	sales code	Sale date	Bar number 2	Name 2	sales code 2	Sale date 2
1	A	10	20-05-2025		9	M	22	21-05-2025		1	A	10	20-05-2025	2	A	10	21-05-2025
3	C	21	20-05-2025		3	C	21	21-05-2025		5	E	31	20-05-2025	5	A	32	21-05-2025
5	E	31	20-05-2025		3	M	45	21-05-2025		4	R	45	20-05-2025	3	M	45	21-05-2025
4	R	45	20-05-2025		2	A	10	21-05-2025		9	U	22	20-05-2025	9	M	22	21-05-2025
6	N	65	20-05-2025		6	N	65	21-05-2025
9	U	22	20-05-2025		7	W	32	21-05-2025
7	W	32	20-05-2025		8	X	43	21-05-2025
8	X	43	20-05-2025		5	A	32	21-05-2025

[abacon · Accepted solution]

@Lumjing Does taking the records that don't join in your first join and joining them on Sales Code, then joining the records that don't match from that one on Bar Number and unioning the 2 outputs get you the output you want? 

bacon

[abacon · Accepted solution]

@Lumjing If this worked for you, please accept it as the solution so others may find it faster.

[Lumjing]

@abacon thank you very much for the quick solution. It worked I validated the output and its working.  I had to add 4th join by name to get the desired result ..Thanks again..