Use Case : sync data

raihanhd

example table a most updated data. data b has not been updated. but examples there are data inconsistencies. suppose table a has 25 data. now table b only has 15 data:

1. table A 1 - 10 suppose it has the same id as in table b. but table b data has not been updated even though the id is the same.

2. Table A 11 - 25 the data is different from table b. Likewise table b data from 11 - 15 the data is different from table A

3. for example in table A it was found that id 14 is the same data as id 12 in table b, as well as id 22 in table a is the same as data in id 14 in table b. but the data has not been updated. but there are things that cannot be the same, for example the phonenumber. it is unique but there is also a null phonenumber.

so what are the steps?

Turribeach

I am not really 100% clear on what you want to do. It looks like you want to merge data from two tables. But I would start with a join recipe then output all columns on both tables and use a prepare recipe with an if formula to determine what field to pick.