nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Dynamic Input to Input Data Tool

testert

Hello, I have an input data tool with SQL code that has a line of code that reads "RUN_NUMBER = 1". I want to update the 1 here with a user input using an action tool, however, I don't want to replace all "1"'s in my workflow. How can I configure this? Thanks!

Developer

Input

Interface Tools

Action Tools

Accepted answers

alexnajm

You originally said 'I don't want to replace all "1"'s in my workflow', to which my original answer was accurate - having multiple "1"s in the SQL code in the single tool is a different story.

In your Action tool then, you can replace via a Formula then and use something like Replace([Destination],"RUN_NUMBER = 1","RUN_NUMBER = "+[#1]) with the user select value being the #1

All comments

alexnajm

The Action tool will only replace the "1" in the tool it is connected to - it will not replace all "1"s in your workflow!

testert

Hi there! Yes, sorry, I meant I don't want it to replace all "1"s in my query. Will it do that?

alexnajm

It will not - the Action tool will only replace in the connected tool

testert

If the action tool is connected to my input data tool that runs a SQL query with multiple boolean values (aka filters set equal to 1), how will the action tool know to only update the filter needed? For example, I only want to update the 1 in this filter "RUN_NUMBER = 1", but I have more filters like "INDICATOR = 1" that should not be impacted.

alexnajm

You originally said 'I don't want to replace all "1"'s in my workflow', to which my original answer was accurate - having multiple "1"s in the SQL code in the single tool is a different story.

In your Action tool then, you can replace via a Formula then and use something like Replace([Destination],"RUN_NUMBER = 1","RUN_NUMBER = "+[#1]) with the user select value being the #1

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15910

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703