Update a table based on a value from another table

[hfanda73]

Hi good people,

Is there a way to update a table that is based upon a value from a field from another table using Alteryx? 

I want to process (run) the 'right hand side' only when it satisfies the condition from the 'left hand side'. Is this a task for macro?

Thanking people in advance.

Regards

Henri

[Qiu]

@hfanda73 

I usually use Join Tool for this case.

But it will still run, just generate empty output.

[hfanda73]

thanks Qiu, In my case, the 2 tables are not related. One table is to be read every 5 minutes to check if the value in a particular field has changed. If Yes, then I want to update a another table by bringing in data from a different table. I know i can do this straight from a Database using trigger, but in this case I want to do everything in Alteryx if possible.

[Qiu]

@hfanda73 
The table are just happened to be same for illustation.

Then you can check if there is record or not with filter.

[hfanda73 · Accepted solution]

i got it to work now with a macro created by http://www.chaosreignswithin.com. Many thanks for that.