Using parameter in SQL statement

Question

I'm currently extracting data from a Teradata database via ODBC connection and SQL statements. I would like to added a parameter to Alteryx workflow that is used as part of the SQL being through. e.g

Select A.Field1, A.Field2

From DB.Table A

Where A.Field1 in (‘parameter’, ‘parameter’)

Any advice on how to do this?

michael_treadwell · Accepted Answer

The Dynamic Input tool is what you are looking for. It allows you to modidy a SQL Query based on fields in your Alteryx data stream.

In the tool configuration you will see a dropdown menu 'Add'. One of the options is 'SQL: Update WHERE Clause'

AndrewW · Accepted Answer

You could have the Input tool containing the SELECT statement as a macro and set up a Control Parameter and Action to pass in the parameter values, replacing the specific string in the select statement. Something like in the attached screenshot (I can't upload into this post for some reason...so had to put into a word doc)