Compering 2 tables

[Luk88kk]

Hello.
I have to compare 2 tables regarding to changes in them ( every differences which appear). Results of changes need to be shown in separate table or as flag in other column.
I try to use Multi row formula but no success.
I'm stuck. Could you please help me to solve this issue.

[atcodedog05]

Hi @Luk88kk 

Can you provide the expected output.

[binay2448]

Please find attached solution may be it help..

Not sure if you are asking this only

[pdave87]

@Luk88kk 

Let us know if below solution works for you. It identifies the mismatched data vs Good data. Same workflow package is attached for your test run.

[pdave87]

@atcodedog05 thanks for your support. Looking at your solution and expertise itself is a great learning. I try to go through your solutions as much as possible to make notes. Thanks.

[atcodedog05]

Hi @pdave87 

Thank you for your kind words. Glad to hear my posts are helpful to others 🙂. Happy to help and support. You solution authors are doing an amazing job of helping users with their questions and helping other solution authors learn, explore and improve 🙂.

I have the same to say I am constantly learning and improving a lot from other solution author's approaches. I guess that's the exciting part of the solution author's journey 😀

Cheers and have a nice day! 

[Luk88kk]

My aim is to get something like this:

In red I have marked the original data and in green what has been changed taking into account the data from tables 1 and 2.

There are 4 changes between the first and second table:
-row 3 - in the code - (from 85546 to 85545)
-row 8 - in the tekst - ("magnets" appeared instead of "books")
- row 11 - in the tekst and flag (flag EDL appeared and the text "books")

I would like to pull in a separate column where the changes occurred considering columns B,C,D

[atcodedog05 · Accepted solution]

Hi @Luk88kk 

Here is how you can do it.

Workflow:

Hope this helps : )

[Luk88kk]

Fantastic! It helped a lot. Thank you and have a nice day!

[atcodedog05]

Happy to help : ) @Luk88kk 

Cheers and have a nice day!