Sorting SQL DB input to List Box Tool

bryanbumgardner

Hello folks,

I am using a SQL database table as the name/value input for a List Box tool. I need those selections to display in alphabetical order.

None of the tools used to upload data to SQL tables within Alteryx do so in a "natural order," that is I can't just organize it alphabetically before uploading and it will be alphabetized in the database naturally.

Best practice for SQL inputs means that the sorting queries are done when the data is called, not done automatically on the table to set the "natural order." 

Do you all know a workaround for this? Thank you! 

bryanbumgardner

I solved my own question!

Every in-DB connection you make opens a window that allows you to pick tables from the database. This comes with other views, including a raw SQL editor and a "visual" SQL view. From here you can choose to order the data however you like, both satisfying the right sort requirement and having the sorting happen when the query is called. 

Hope this helps someone else!