Dynamic Parameter to Oracle Query

[shsridh2]

Hi Team,

I have set of parameters and its values in Excel. I need to read those values from the Excel and use those values in the Query.

How do we achieve this?

Serial No	Parameter Set	Value
1	SHARE_NODE_ID	123
2	NODE_ID	456
3	SALES_ACCT_ID	789
4	GB_ID	4444
5	COUNTRY_ID	34
6	Sales Number	23
7	LEVEL_6	IND_ABC

These values need to be embedded in the query to pull the data from oracle table.

Regards,

Shankar Sridhar 

[ChrisTX]

Check out the in-Database tools.  You'll need to convert your Excel rows into sections of a SQL WHERE clause, then pass in the query to the Dynamic Input in-DB tool.

You can find a few examples by searching this message board for "Dynamic Input in-DB" (including the quotes)

Product documentation for the IN-DB tools:

https://help.alteryx.com/11.0/index.htm#In-DatabaseOverview.htm%3FTocPath%3DIn-Database%7C_____0

Chris