Hi everyone!

I am currently working with two tables (let's refer to them as A and , wherein table B is synced to table A.

My objective is to deduplicate table A, but before doing so, I need to merge the information that is not synced in table B to prevent any data loss (essentially deduping without the deletion part).

Is there a method to achieve this?

I was contemplating using a script to handle the merge process, but I'm unsure if there's a way to identify whether a field in table B is synced or not.

Any insights or suggestions would be greatly appreciated!

Thank you in advance.