We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Update a table based on a value from another table

hfanda73
8 - Asteroid

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? 

 

hfanda73_0-1613514170043.png

 

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

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

@hfanda73 

I usually use Join Tool for this case.

But it will still run, just generate empty output.

0217-hfanda73.PNG

hfanda73
8 - Asteroid

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
20 - Arcturus
20 - Arcturus

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

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

0217-hfanda73-1.PNG

hfanda73
8 - Asteroid

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

 

hfanda73_0-1613529269504.png

 

Labels