Free Trial

Alteryx Designer Desktop Discussions

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

Updating table status column

danjohnsonM
8 - Asteroid

Hi

 

In the attached workflow I have a table pre built with my status column which I want to lookup and update the second table to have the status column

 

This is part of a bigger task (about 15 columns) And i could do If statements but wouldn't be flexible if changed.

 

Any help would be appreciated

 

Thanks Dan

3 REPLIES 3
vizAlter
12 - Quasar

Hi @danjohnsonM — Try this solution... 

 

vizAlter_0-1600882006874.png

 

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

danjohnsonM
8 - Asteroid

Hi

 

Thanks for the support

 

Getting there. The status doesn't (in the real life workflow) match the 3 short (was just an example) sorry

 

I have attached a new workflow that would help

 

Thanks Dan

vizAlter
12 - Quasar

@danjohnsonM  — Hope this helps:

vizAlter_0-1600885095157.png

Now, if you have more than 3 Fields, you can simply add them as well through Join tool, like screenshot above.

 

 

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.

 

Labels
Top Solution Authors