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
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