Hi everyone!
I am currently working with two tables (let's refer to them as A and B), 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.