Pass output of one parameter to another activity

[aswadv4]

Hi,

I am new to Alteryx. I have a requirement where the output of one activity can be provided as input to another activity.

I want to use SQL query or stored procedure activity with parameters. This activity will get the parameter from its preceding activity. Can anyone help me with this.

[Divyang21Arora · Accepted solution]

Hi @aswadv4 ,

You can achieve that using a dynamic input tool in Alteryx. Start with a text input tool where you give the values for the parameters in a column. Now in the dynamic input tool connect to the database and use the update query option in the tool. there you can update the query value based on the value you are getting from previous input. please refer to the screenshot for reference.