How can I write a formula to use Multiple Interface Tool Inputs with Single Action Tool?

Question

Hello Everyone,

I am using 3 Interface Tools, 1st is DropDown (for database Table selection), 2nd is Calendar (for StartDate), 3rd is Calendar (for EndDate). I want to pass all 3 Interface Tools' inputs to single Action Tool and then to single Input tool.

I am using 1st Interface tool DropDown which is providing list of 2 database tables. The 2nd interface tool is Calendar which provides StartDate. 3rd Interface Tool is Calendar which provides EndDate. Now, my Input Tool is getting data from SQL Query where I want to replace the TableName from SQL Query with selected input table name from 1st Interface Tool and same way I want to replace the StartDate and EndDate of SQL Query WHERE condition with Inputs from 2nd and 3rd Interface Tools. I was trying to write Formula in Action Tool under action type 'Update values with Formula', But as I am new with Alteryx I am not getting it. Can someone please help me out here?Attached is the image for what I want to achieve.  Thanks in advance.

Screenshot 2024-03-13 124013.jpg

sandesh_844 · Answer

Hey @Qiu,

I think there is some confusion with understanding my requirement. I tried to elaborate with below screen print. Hope it helps.

And as I see you have given the inputs from Action Tools to Filter Tool, whereas I want it to the single Input Tool and should replace the specific strings in Input Tools's SQL Query i.e. StartDate, EndDate and TableName as per the user selected in Interface Tools.

Qiu · Answer

@sandesh_844 
Here is a simple sample that we can update 3 values in the input file with 3 action tools.

0313-sandesh_844.yxzp

sandesh_844 · Answer

Hey Qiu,

Currently I am not able to use send inputs from my 3 Action Tools to single Input Tool because Input Tool is able to connect to only 1 Action Tool at a time.

Please correct me if I am doing something wrong or I am getting wrong.