Hi, I have a stored procedure with 2 result sets and need to bring both in to the workflow. I've seen this question posted before, but it didn't appear to have an answer. Can anyone help with this? Thanks
@Allan1
We currently support Stored Procedures for the below 3 data sources
You can find more details on Stored Procedures and Alteryx here.
If you would like to bring in 2 results sets into the workflow, you will need to use two Input data tools each configured to connect to the relevant stored procedure.
Michal
Thanks Michal, but I've already seen this page and it hasn't helped me. Also, you say 'use two Input data tools each configured to connect to the relevant stored procedure', but I don't know how to differentiate between the two outputs with the 2 input tools. Please could you be a bit more detailed? Also, a related issue is that my stored procedures don't show on my stored procedure tab when using an input tool. Is there a setting I should change? Thanks
Could you please provide a bit more context on what you're trying to achieve once you bring the data from the two stored procedures into Alteryx? Also, what is the database you're connecting to?
Once you configure the Input Data tool to connect to the database of your choice, the stored procedures tab should list all of the stored procedures your user (or user credentials of which you'v used to authenticate) has access to.
Thanks Michal. My priority problem is that I have 1 stored procedure on a SQL Server that returns 2 data sets and I need both in my workflow. Is this possible? Also, my secondary issue, which is mainly just an irritation, is selecting stored procedures when opening an input tool:
Thanks
Assuming these tables have different schemas I don't think this would be possible. What I'd probably suggest is re-creating the stored procedure in Alteryx for those 2 tables. Do you know what the stored procedure does in the background?
