Pass output of one parameter to another activity

Question

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 Answer

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.