Update a table based on a value from another table

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

Macros

In Database

In-Database

Accepted answers

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

All comments

I usually use Join Tool for this case.

But it will still run, just generate empty output.

0217-hfanda73.yxzp

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.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703