Alteryx Designer Ideas

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

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

Submission Guidelines
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Add Option/Check Box to See Column Letter/Row Number In Input & Browse Tools

Hi,

 

I get a lot of adhoc requests where the insturctions are in the actual email. As I'm going through the ask, creating the new workflow, the requester will mention "column C" or "column XY", but I'm viewing the data in Alteryx where that doesn't show. So I have to open the Excel file, find the column, get the name, go back to Alteryx to locate the column I need, run the module but get an error/no results because I forgot to close the Excel file (because the module is using the same file I just opened to validate which column I'm using).

 

It would be really cool to have an Option in the Input tool to add the Excel column lettering and numbering to show (Ex, Column A, B, C, D going left to right, Row 1, 2, 3, going top to bottom). This would just be visually showing it, not adding it to the data (because then you would lose the actual column names). If this can be done, it would be equally as useful in the Browse tool view. Have a great day!

3 Comments
12 - Quasar
12 - Quasar

There is one way you can get at the Excel column lettering from within Alteryx: A macro Smiley Happy

 

See the post at http://community.alteryx.com/t5/Data-Sources/Macro-and-example-for-generating-Excel-Column-Letters/m... beacuse we cannot currenlty attached files in replies to Ideas.

Status changed to: Inactive
 

The status of this idea has been changed to 'Inactive'. This status indicates that:

 

1. The idea has not had activity in the form of likes or comments in over a year.

2. The idea has not reached ten likes.

3. The idea is still in the 'New Idea' status. 

 

However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status. 

 

Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!