Field by Field comparison and highlight which values has changed between 2 tables

Field by Field comparison and highlight which values has changed between 2 tables:

i ahve 2 tables with similar structure and need to compare and highlight where values has changed in the new table vs old table?

table a snapshotdate 14112022

table b snapshotdate 17112022

i need a result table with columns thats changed as 1/0 or yes/no is this possible?

Hi @Ravi85,

Welcome back!
Not much detail in your inquiry but see if this approach works for you, if not - supply a sample.

Hello @Ravi85

Did the response above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need? If it did, please mark the solution that helped you.

Thank you

Hello @Ravi85 ,

Due to the length by which this post has been active, we are tagging it as Solved.

Thanks to the contributors of this post @Melissa
For further questions related to this post, please make a new thread. Please feel free to reopen this thread if anyone would like to answer the pending inquiry above.

Thank you