Simultaneously update 2 records

[pinedz04]

Hi!

I'm trying to create a workflow which will update simultaneously from 2 sources without creating any duplicates. Look at my samples below:

[RishiK]

@pinedz04 what is your logic for updating the fields? Based on your sources / inputs / values in other fields you can use the Multi Row Formula and Multi Field Formula tools:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Multi-Row-Formula/ta-p...
http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Multi-Field-Formula/ta-p/39658

[atcodedog05]

Hi @pinedz04 

Here is what you can do.

Workflow:

1. Using Join tool to join edit -1 columns to original data. Similarly using another Join tool to join edit -2 columns to original data.

2. Using formula tool to check whether the values changed in edit-1 or edit-2 is yes change original values. In this way any changes done in country or to be deleted will be updated.

3. Using select tool to keep only the original fields.

Hope this helps 🙂