Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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