Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

(IN/OUT) select tool # (IN-DB) select in-DB --> limitation on max number of fields ?


Is there a limitation on the number of fields in the incoming database (SAP Hana) to display all the fields in the tools - select tool - or - select in -DB.  In both tools I end up with only the *Unknown field. There should be hundreds of fields to select from.



Alteryx Certified Partner

Not that I am aware of, how are you currently connecting today? Are you using the IN-DB connection? Have you been able to connect before to a different table in HANA? 


Hello @JeroenL  I don't think there is a limitation.


Every time in order to see the fields you will have to run the workflow once or the only other issue I can think of is alteryx was unable to read that specific table (possibly access issue).


Have you tried writing a query to select just 2-5 columns to ensure that it is reading the limited number of fields but not in hundreds?