Input SQL Query Based on Another Output

Hi Team,

I have this problem in Alteryx. I have a list of Securities from Filter tool (output). I want to use this list of securities in SQL query in next step of the workflow (where clause). Could you please guide me on this.

My SQL query needs a list of Securities in WHERE clause line. I have a list of Securities as a result of previous step in the workflow. Is there a way to use this list in my SQL?

Developer Tools

Database Connection

Accepted answers

Christine_Assaad

Hello @Jaganmohan

You can also use the Dynamic input tool like below.

Step1: Use Dynamic Input to connect to your SQL DB

Step 2: Build your query visually or using SQL Editor with your where clause

Step 3: Go to Modify SQL query option and use Add --> SQL: Update Where Clause. Then configure your SQL to replace your where clause value with whatever your filter tool upstream tool has (in my case a field called ID)

ID field in upstream tool

Final Output

Hope that helps. Cheers!

All comments

ChrisTX

Here's how I do it:

Start with a Text Input tool with fields for Connection and Query. The Connection field is a pointer to a File Connection (.indbc) file.

Then I use a Select tool to expand the length of the Query field.

Then I use these tools:

Join: the left input is from the Select above. The right input is the Where clause, like:

Field name: Where Clause for SQL query
Field value: (S.FISCALYEAR = 2018 and S.DOCUMENTNUMBER IN ('515888','515999')) or (S.FISCALYEAR = 2019 and S.DOCUMENTNUMBER IN ('190111','190222'))