Compare 2 dates table and find difference

Question

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 numberNamesales codeSale date Bar numberNamesales codeSale date Bar numberNamesales codeSale dateBar number 2Name 2sales code 2Sale date 21A1020-05-2025 9M2221-05-2025 1A1020-05-20252A1021-05-20253C2120-05-2025 3C2121-05-2025 5E3120-05-20255A3221-05-20255E3120-05-2025 3M4521-05-2025 4R4520-05-20253M4521-05-20254R4520-05-2025 2A1021-05-2025 9U2220-05-20259M2221-05-20256N6520-05-2025 6N6521-05-2025         9U2220-05-2025 7W3221-05-2025         7W3220-05-2025 8X4321-05-2025         8X4320-05-2025 5A3221-05-2025

Check.yxmd

abacon · Accepted Answer

@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 Answer

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