Input a item number into a Workflow running from a ODBC Database Query

Hi Community,

Looking for some help please, I have a Workflow which is running from an ODBC Database Query

It's our R12 ERP back tables. I'm currently opening up the SQL Query an changing the item number / numbers one by one

See attached, I wondering if there is a dynamic way to do this, where I don't keep having to open the table (fig2) and enter each item like in (fig3)

If someone could be advise.

TIA

Karl

WF1.PNG

Workflow

Accepted answers

All comments

mbarone

I can't tell by your screenshot - are you asking if you could "feed in" a list of values to your query and have the query run for each of those values (without having to manipulate the query)?

ChrisTX

Try the Dynamic Input tool.

Here's a link to the Tool Mastery article:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Dynamic-Input/ta-p/24946

Here's an example of how I use "#Placeholder" text in my SQL query, and use the Dynamic Input tool to replace the #Placeholder values with data from the incoming data stream:

Chris

Karl_Spratt

Hi Chris,

My Database is a ODBC D/base for R12, can I create this looked at Youtube videos saying it had to be OLED8 DB

See my setup, so what I'm trying to do is tell the Dynamic Input to search for say item B instead of Item A

Can you assist here, I looked at this video but I'm lost

Alteryx - Dynamic Input Tool - YouTube

Cheers,

Karl.

WF2.PNG

rvenkatr7276

My requirement is slightly different. I have a ODBC connection to a table which needs to query based on values available in my Excel. Could you suggest me a solution please. I can create a Dynamic input using the excel and brough to the workflow, not sure how to connect the Sql query to the dynamic input brought above.

rvenkatr7276

sqlfromdynamicinput.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703