Update value (Using Action tool) from result of formula tool

[AudieCruz]

I have a small part of the workflow that returns a list of projects. The result is formatted as a IN statement for SQL ('123456','234567'). 

 I want to user that as a source to update a second SQL input. Meaning "A.Field = ('789456'), and I would update ('789456') with the result of the first part. 

I can technically do it by formatting it in such a way that I can interface using the dropdown tool, but I don't want to have a prompt on the app. I just want to have it updated directly. 

Hopefully this is enough information to have an answer. Let me know if further detail is needed. 

 

[LukeM · Accepted solution]

Hi @AudieCruz 

This sounds like a job for the Dynamic Input tool.

Have a look at configuring it to update the where clause with your list of IDs.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/249...

Hope this helps!

Luke

[AudieCruz]

@LukeM Thank you. I'm looking into it, and I believe it should solve my issue. Once I validate, I'll mark it as solved. 

Thank you again. 

Edit: I validated the results and they match. Thank you for the help. Marked as solved. 

[LukeM]

No problem @AudieCruz - happy to help!