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

Loss of functionality when opening Excel files

I haven't needed to do this for over a year, but I just tried in 2018.4 and the functionality is not there any more 😞 

 

I'm trying to open an Excel file and customise the SQL used to read the data.

 

I've found this in other posts:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-do-I-get-row-range-in-Excel-format...

 

then I found this one 😞 

 

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Input-Tool-2018-1-Excel-Range-Feature-Remove...

 

Hopefully this feature will be re-instated soon 🙂

3 Comments
jpoz
Alteryx
Alteryx
Status changed to: Coming Soon

Thank you for suggesting this! The ability to specify ranges with Excel files does still work, however you have to manually enter in the range and it is not intuitive that the functionality exists. We will be adding a user interface for this functionality in an upcoming release.

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Implemented

Thank you for your idea! This feature has been implemented in the latest release, 2020.1! Check out the release notes for this version here!

cmcclellan
13 - Pulsar

AWESOME NEWS !!!! 🙂 🙂 🙂 THANK YOU and the team 🙂