community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the star in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

Hi GUI Gang

 

At the moment, I have a lovely formatted XLS with corporate branding, logos, filled cells, borders etc.  The data from the Alteryx output needs to start in cell B6.  I have tried the output tools to this named range, but Alteryx destroys all the Excel formatted cells in the data block.

 

As a workaround on the forums, many Alteryx users pump out to a hidden "Output" tab, and then code =OutputA1 in the formatted sheet.  This looks messy to the users who then go hunting for the hidden tab.  Personally I end up pumping the workflow out to a temporary CSV file.  Then opening that in Excel, selecting all, and then pasting values in the pretty Excel file.

 

This is fine for one file, but I need to split the output report block by a country field and do this 100s of time for each month end.

 

Please can we have a output tool that does the same as my workaround.  Outputs directly from a workflow to a range in Excel that doesnt destroy the workbook's formatting.

 

Jay

Hello .. me again!

 

Please can you fix the copy and paste of renames across field.  It's a behavior that I see in many tool's grids and drives me mad.  Its not just select. 

 

Take the attached screen shot.  In the select tool, i've renamed "test 2" to "rename2".  Fine it works. No issue.

 

I then copy rename2 and paste into the test3 field, and it copys the entire row's data (and metadata) into that little box, tabs, spaces the lot.  I end up with something like the screenshot.  Really not sure it was meant to be designed this way, as I cant really see the point.

 

Please can you fix this bug

 

Jay

In a browse tool, sometimes I need to check any metrics haven’t been lost or omitted in different summarise tools (eg the totals still add up with different group by).

I would LOVE the quick win of selecting some cells in the browse tool results pane, and a label somewhere shows me the sum, average, count, distinct count, etc. I hate to use the line but ... “a bit like Excel does”. They even alow a user to choose what metrics they want to show in the label by right clicking. :-)

This improvement would save me having to export to Excel, check they add up just by selecting, and jumping back, or even worse getting my calculator out and punching the numbers in.

Jay

Alteryx should raise a Conversion Error if re-sizing of a string field in a Select tool results in data truncation. It does this for integers but if a string is truncated there is no indication of this in the workflow output.

  • Tool Improvement

The "Manage Data Connections" tool is fantastic to save credentials alongside the connection without having to worry when you save the workflow that you've embedded a password. 

 

Imagine if - there were a similar utility to handle credentials/environment variables. 

 

  • I could create an entry, give it a description, a username, and an encrypted password stored in my options, then refer to that for configurations/values throughout my workflows. 
    • Tableau credentials in the publish to tableau macro
    • Sharepoint Credentials in the sharepoint list connector
  • When my password changes I only have to change it in one place
  • If I handoff the workflow to another user I don't have to worry about scanning the xml to make sure I'm not passing them my password
  • When a user opens my workflow that doesn't have a corresponding entry in their credentials manager they would be prompted using my description to add it.
  • Entries could be exported and shared as well (with passwords scrubbed)

Example Entry Tableau:

AliasTableau Prod
DescriptionTableau Production Server
UserIDJPhillips
Password*********
+ 

Then when configuring a tool you could put in something like [Tableau Prod].[Password] and it would read in the value.

 

Or maybe for Sharepoint:

 

AliasTeamSP
DescriptionTeam sharepoint location
UserIDJPhillips
Password*********
URL http://sharepoint.com/myteam
+ 

 

Or perhaps for a team file location:

AliasTeamFiles
DescriptionRoot directory for team files
Path\\server.net\myteam\filesgohere
+ 

 

Any of these values could be referenced in tool configurations, formulas, macro inputs by specifying the Alias and field.

1-3-2019 12-43-52 PM.png

Sometimes I want to test portions of a workflow, independent of other portions.  I find myself adding containers, just so I can disable some of the time consuming portions that are not part of my test.  It would be nice to be able to enable/disable any portion of a workflow, on the fly.  Or maybe just disable/enable any connection with a right-click.

Thanks!

Gary

  • Tool Improvement

Who needs a 1073741823 sized string anyways?  No one, or close enough to no one.  But, if you are creating some fancy new properties in the formula tool and just cranking along and then you see that your **bleep** data stream is 9G for nine rows of data you find yourself wondering what the hell is going on.  And then, you walk your way way down the workflow for a while finding slots where the default 1073741823 value got set, changing them to non-insane sized strings, and the your data flow is more like 64kb and your workflow runs in 3 seconds instead of 30 seconds.  

 

Please set the default value for formula tools to a non-insane value that won't be changed by default by 99.99999% of use cases.  Thank you.

 

 

Often as I am scraping web sites, some clever developer has put an invisible character (ASCII or Unicode) in the data which causes terrible trouble.

I've identified 89 instances of zero-width or non-zero-width glyphs that are not visible and/or Alteryx does not classify as whitespace. There are probably more, but Unicode is big y'all.

Unfortunately, the Trim() string function only removes 4 of these characters (Tab, Newline, Carriage Feed, and Space).
REGEX_REPLACE with the \s option (which is what the Cleanse macro uses) is a little better but still only removes 20. And it removes all instances, not just leading and trailing.

I've attached a workflow which proves this issue.


@APolly: this is what I mentioned at GKO.

And I did see this post (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Elegantly-remove-all-ASCII-characters-...), but it's too brute force. Especially as Alteryx is localized and more users need those Unicode characters.

We need color coding in the SQL Editor Window for input tools.  We are always having to pull our code out of there and copy it into a Teradata window so it is easier to ready/trouble shoot.  This would save us some time and some hassle and would improve the Alteryx user experience. ( I think you've used a couple of my ideas already. This one is a good one too. )

2018-10-18_7-49-16.jpg2018-10-18_7-50-52.jpg

 

Other applications I work in reguarly utilize right-click menus.  Sometimes those menus seem annoying, but in working with Alteryx, I realize it’s actually quite smart because it eliminates unnecessary wrist movement.  In the screenshot below, I have highlighted a bunch of fields.  alteryx.pngThe boxes were previously unchecked and I wanted to check them to bring them into my workflow.  I highlight them, and if I were in a different application, I would just right click and get access to everything that is in the options menu, but in Alteryx, I have to actually move the mouse to the options menu.  This might seem super nitpicky, but as someone who is currently suffering from overuse injuries in my wrists and hands, I really appreciate minimal wrist movement.

  • Tool Improvement

Can we get the input tool to automatically convert long filenames to the 8.3 convention inside of a macro?

 

I've written a batch macro that individually opens files in order to trap files that fail to open. However, when I pass in really long file names it bombs because beyond some length the Input tool converts the path to 8.3 but that logic doesn't fire inside of my macro.

 

Example of filename:
\\ccogisgc1sat\d$\Dropbox (Clear Channel Outdoor)\Mapping\BWI MapInfo\Workspaces\Local\AEs\Archives\Cara\Sunrise Senior Living\Washington+DC_Adults+55++With+HHI+Of+$75,000++Who+Are+Caregiver+Of+Aging+Parent_Relative+Or+Planning+To+Shop+For+Nursing+Care_Assisted+Living_Retirem.TAB

When you add a tool in the canvas, the annotation is automatically set (for example the formula, or connection configuration etc). You can then customize the annotation text in the "Annotation" tool's tab. But sometimes it can be useful to revert to the "automatic" annotation, and it doesn't seem possible once you set it to something different.

 

Apparently there is currently no way to reset a tool's annotation text to the automatic value.

 

I've found a way to do it by editing the xml content of the file : as far as I know you just have to delete the <AnnotationText>[...]</AnnotationText> tag and reload the file, and the annotation gets back to the default "automatic" value, which is still present in the <DefaultAnnotationText> tag.

 

I think a simple button in the tool's annotation tab to reset it would be nice.

 

Thank you!

  • Tool Improvement

Some of the workflows I use have multiple inputs that can take a long time to initially load. The new cache function itself has been amazing, but there is one big drawback for me: I can't cache multiple tools at the same time.  Alteryx will allow me to eventually cache all of the tools I want cached, but it will take multiple times running the file.  This still saves me time in the end, but it feels a bit cumbersome to set up.

R and Python has a very fruitful competition in machine learning circles...

Why not have the python editions of all predictive tools as well so that

we can have an "all R", "all Python" and "R and Python" predictive tools that can be mixed and matched in a single workflow,

a multilingual approach...

 

 

Picture1.jpg

 

  • Tool Improvement
It would be great to see the R tool updated with the same interface as the Python tool to reduce the need to rerun the workflow when testing.

Hi there,

 

My idea comes when I've built an application, where user select filter from drop-down list. However it contains thousands of records, so it takes lot's of time to find desired record.

In Excel and MS Access when you use filter you can put many letter and filter shows rows that match the input. In Alteryx user can only put first letter, which is huge drawback to my users.

 

This is how it works in Excel:

werwe.jpg

 

Hope you like it!

In the moment we using Alteryx and Tableau to publish data from the Azure environment. In our focus is to publish the data with the ADLS Connector. For us would be perfect if as well parquet would be supported. In end we are in competition against PowerBI and these software supports parquet files.

  • Tool Improvement

Is there a possibility of changing the behavior of Event or the email tool itself to not use anonymous relays?

Our Security team does not want to white list desktops, and a lot of our customers don't use server.  Our server IPs have been whitelisted and a couple of desktops, but that's it. So looking to see if an enhancement can be considered for the Email tool and the Event set up.

 

Here is what we received from Alteryx Support:

Alteryx sends anonymous email, and there is no way to tie (or spoof) a separate IP address to the email to let the server know where it's coming from, or to make it "non-anonymous." The email tool is a very basic SMTP client that currently does not support SSL or authentication. As such if the SMTP server you are connecting to requires SSL or authentication to relay messages the tool will fail to send the intended message(s). If the server IP hasn't been blocked to send anonymous email, you can test in Designer on the server to see if you receive the same error. If it works on the server, you should be able to send emails from workflow scheduled on gallery. Since the IP of the machine itself is blocked from sending anonymous email, there is nothing we can do on our end to resolve the issue for each individual Alteryx user. IT will have to white-list any IP that wishes to send anonymous email. 

Thanks so much!!
Diana

 

Change the sample tool to have an allow all records option.  This will allow you to include the sample tool in a production workflow and will be a constant tool to allow you to debug the workflow if necessary.  This will prevent you having to delete and re-add the sample tool everytime you need to use it.  Could also have a workflow option of 'set samples to all records' which you could click on when publishing to Gallery.

  • Tool Improvement

Bring back the Cache checkbox for Input tools. It's cool that we can cache individual tools in 2018.4. 

 

The catch is that for every cache point I have to run the entire workflow. With large workflows that can take a considerable amount of time and hinders development. Because I have to run the workflow over and over just to cache all my data.

 

Add the cache checkbox back for input tools to make the software more user friendly.

Top Starred Authors