Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Option to not sort Excel Sheet names

Currently, when choosing the "<List Of Sheet Names>" options for excel files, Alteryx always does an implicit sort of the sheets when outputting the list.  For some of my excel files I need to read, the order of the sheets in the excel is important.  But Alteryx will always perform a sort, without me being able to know what the original order was.  And yes, one of those fun situations where I don't control the excel sheet.

 

It would be nice when selecting this option to either preserve the order of the sheets or somehow include an additional column that numbers the order the sheet was in.

4 Comments
jpoz
Alteryx
Alteryx
Status changed to: Coming Soon

Thank you for this suggestion. This feature will be included in an upcoming release.

jpoz
Alteryx
Alteryx
Status changed to: Implemented

Thank you for this suggestion! In the 2019.4 release (https://downloads.alteryx.com) sheet names in "<List Of Sheet Names>" are now output in the order they appear in the Excel spreadsheet.

RoryFerbrache
5 - Atom

It's still sorting it for me? I'm using 2019.4

 

jpoz
Alteryx
Alteryx

@RoryFerbrache The list shown in the UI is still sorted, but the output from the tool into the workflow should be in the order it appears in the excel spreadsheet.