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