This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thank you for what you do for this tool. I am having an issue with an ODBC input. I am connected to KB SQL through my work, and when I am trying to input a table it only bring in 1 row of data. I was troubleshooting this on the internet and could not find a solution. I was wondering if any of you have had an issue similar to this, and what you did to be able to bring in all rows.
No, it did not work unfortunately. I am trying to troubleshoot this issue and cannot come to a solution on why Alteryx will only bring in the first row of data when we use this a specific odbc connection.
Are there any people I can contact directly about specific issues with Alteryx?
If you run the same query that you are using in your input tool in another query tool outside of Alteryx (DB visualizer,SQL assistant,Teradata,etc.) are you getting more than one row? If so, can you provide a screen shot of the Alteryx configuration pane for you input tool?
If I use Microsoft Access to pull the same table, I am returning all 1057 rows of records. So, yeah it seems to be an Alteryx issue, and my hunch is it has something to do with the specific KB SQL connection I am using to input the data.
I'm not sure I can do a screen shot as even though it's only one row it may have sensitive data.