Workflow to Update a Table with a Column from the Second Table

Question

Hi Alteryx Community! I am a new user to Alteryx and am working on the following question and am looking for some guidance! Thank you!

* Create a workflow to update the Property History Dimension table using the transaction from the New Property Transaction table. For example, the following Table A and Table B are used to produce Table C:

Any help with a workflow or guidance is much appreciated! Thank you!

New Property Transaction (1).yxdb

Property History Dimension (1).yxdb

mdsalmankhan89 · Accepted Answer

Hi @amcgill2 ,

Here you go ! Hope it helps.

Regards,

Salman

atcodedog05 · Accepted Answer

Hi @amcgill2

Here is how you can do it. What i can understand from your sample scenario is where ever End_date is Null in Property History Dimension using Parcel_Number as key you are lookuping for sales_date in New Property Transaction and setting that as End_date (only where End_date is Null)

Input:

Workflow & Output :

If this doesnt meet your requirement please provide more explanation on what you are looking for.

Hope this helps 🙂