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

[amcgill2]

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!

[mdsalmankhan89 · Accepted solution]

Hi @amcgill2 , 

Here you go ! Hope it helps. 

Regards,

Salman

[atcodedog05 · Accepted solution]

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 🙂