Alteryx Designer Desktop Discussions

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

Update Oracle Query with Action Tools

Teos
5 - Atom

Hello,

 

I am trying to update a query with 3 inputs from users using analytics app. I have tried the Dynamic Input tool and Direct connection. But something seems to be wrong and the query is not updated. Attached is a test workflow. 

 

Teos_0-1619017824557.png

 

1 REPLY 1
echuong1
Alteryx Alumni (Retired)

I cannot see your full query, but in your action tools, select the File-Value line. That is what is going to be updated.

 

In the replace specific string section, have whatever is built into your query. So if you built you query with 2018 hardcoded and that's what you're looking to replace with the user selection, it would look like the below.

 

echuong1_0-1619026844651.png

 

Labels