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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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

Sometimes formulas get pretty long. There are cases of deeply nested conditionals, concatenation of long strings, cases where multiple casts and parses are used, etc. where formulas get pretty large and unwieldy. The current system of wrapping lines and managing the size of the properties pane can be a hassle, especially if you are trying to use any sort of whitespace formatting to make the formulas more readable.

 

My solution is this is pretty simple, add a pop-out window for formulas. It could be a context menu option from right-clicking the formula box itself, a button on the bar at the top of each formula, or any number of other things.

 

A really good example of this is MS Access. You can right-click any text box that takes an expression and open it in the expression editor pop-up window. The current system is more like excel where you're stuck with whatever box size you're given.

For people recently met with RegEx, you are lucky if the expression is short and understandable or "human readable".

But there are extreme cases too where it's really a pain to solve the puzzle.

 

if you'd like to catch e-mail addresses from masses of unstructured data this will work;

 

/^([a-z0-9_\.-]+)@([\da-z\.-]+)\.([a-z\.]{2,6})$/

 

and here is the elaboration;

when colorful it's fun but barely readable still... Here is a Regexper version

 

image.png

 

This visualizer I came across at https://regexper.com/ is awesome.

 

  1. Can you please integrate this into Designer for ease of reading and understanding existing RegEx...
  2. Can it be possible to develop an interactive tool to prepare;
    • The graphical representation of our regular expression first
    • And then writing it in the same old fashion...

Please support the idea if you like...

 

I would like to have all my annotations show on top of the tools by default. I can change them one at a time, but I would like to be able to change the default setting to be "Show Annotations on the Top" always.

I really love how I can drag and drop a file directly onto the canvas from Windows Explorer and Alteryx knows to create an Input Data tool. But when I tried it with a folder today, hoping to see a Directory Input tool appear, it wouldn't do it. Could we have a similar functionality for automatically creating a Directory Input tool?

Hi All,

 

Was very happy to see the Bulk Loader introduced for Snowflake during last release. This bulk loader is specifically available for Snowflake environments that are hosted on AWS, but does not provide functionality for those environments using Azure. As Snowflake continues to build momentum, I imagine this will be a common request. Is there something in the pipeline to add this functionality?

 

For an interim solution, we will be working toward developing some generic scripts/snowsql to mimic that bulk load, but ultimately we'd love to have this as part of the tool.

 

Best,

devKev

I like the new cache option in 2018.3, but I would like it to function a little bit different. Let's say you cache at a certain point and then continue to build after that. If I reach another checkpoint and want to cache, it currently re-runs the entire workflow (ie it ignores my cache upstream and just goes back to the beginning of the workflow); instead, I would rather have it utilize the upstream cache. Personally, caching is usually an iterative effort during development where I keep caching along the way. The current functionality of the cache is not conducive to this. Thanks!

Hi

 

We have recently upgraded to 18.3 and noticed that the Filter tool expression box has lost its colour coding of expression elements. The Formula tool (which still has the 18.2 look and feel) however still has the old colour coding.

 

It would be great if the colour coding could be included for all tools with expression editing boxes.

 

Examples attached for clarity.

 

Thanks

I like the new cache option in 2018.3, but I would like a user setting added that would allow me to 1) write the cache files to a local drive and 2) have them persist when I re-open Alteryx. Currently, the files are written to the user defaulted temp space and don't persist when Alteryx is closed down. Thanks!

I'm only just starting to explore the python and html sdks, but I think this functionality would be really useful for Alteryx tools.


I foresee cases where a custom tool is developed and we want to install it for 20+ users.  Rather than having each user manually open and install the file, and troubleshooting for each of them (which could also become challenging if we want to deploy an enhancement to a tool in the future), I'd like a method (preferably via command line) to automatically install a tool for a user without any interaction/input.

This would allow for targeted tool deployment as well as large-scale tool maintenance as custom Python tools mature in the enterprise space.

Alteryx's spatial tools are really powerful and offer a lot of value for analysis.  However, when rendering a map for output, there is currently no way to place an image inside of a polygon.  This feature would be very useful for customized layers on maps and other spatial-based processes.

My rough suggestion would be to scale a selected image to the size of the polygon's bounding rectangle, and then trim the edges of the image to fit inside the polygon itself.

I use a mouse which has a horizontal scroll wheel. This allows me to quickly traverse the columns of excel documents, webpages, etc.

 

This interaction is not available in Alteryx Designer and when working with wide data previews it would improve my UX drastically. 

I've seen this question before and have run into it myself.  I'd like to see a new tool that would allow a developer (of a workflow) to choose a path of logic based upon criteria known only during the execution of a module.

 

If LEFT INPUT Count of records < 10,000 THEN Path1 (e.g. use a calgary join)

ELSE Path 2 (e.g. use a standard join)

endif

 

Thanks,

 

Mark

All the items in the 'View' menu have useful shortcuts. For instance, I'm always using Ctrl+Alt+D for the interface designer.

 

It would be nice to be able to quickly check workflow dependencies; at the moment there are far too many clicks to get there given the amount they are accessed (by myself and my colleagues at least...)

 

Quite often the window is only required briefly to check whether absolute/relative paths are used and to see inputs/outputs. It would really improve speed and ease of use if the window could be brought up with a couple of key strokes.

 

What are your thoughts?

I constantly find my using pre and post SQL Commands in the Output tool to run SQL when I don't actually have any data to output.

 

One example is when I load data into S3 and want to load it into Redshift. I have SQL code to run but no data to Output - I end up running a dummy row into a temp table.

 

So can we have an SQL tool that simply acts the same as a Pre-SQL command without the associated data output. Once the command is run we should be able to continue the workflow, so the tool should have an option input and output, like the Run Command tool.

 

 

Now that Alteryx releases updates to Designer every quarter I'll likely be updating my copy of Designer frequently. Meanwhile, my IT team doesn't want to have to update Server every quarter to stay compatible. Problem there is, when I create workflows in the latest version of Designer they can't run on the older version of Server, nor on the Gallery. 

 

Some features that would allow me to work around this: 

  1. If I could elect what version I want to use when uploading to the gallery. 
  2. If instead of having to upload workflows from within Designer (which thereby opens  the workflow in whatever version I have installed on my machine) I could upload workflows from the Gallery website by navigating to a folder on my directory and selecting a given workflow. That way I could open the workflow in Notepad beforehand and alter the version number to match Server. 

 

I'm guessing this is a niche problem that few others will encounter: 

  1. Not everyone is as big a nerd as me and will insist on updating Designer each quarter
  2. Other companies may have IT teams that update Server each quarter
  3. You can install an admin and non-admin version of Alteryx on your machine (I plan on doing this once IT responds to my internal service request).
    1. You could use the admin version for the latest and greatest version of Alteryx
    2. You could use the non-admin version to match whatever version of Server IT has installed and use that to upload (first opening the workflow in notepad to manually overwrite the version number to match server) 

Tools within a workflow needs to be able to run in parallel whereever applicable.

 

For example: Extracting 10 million rows from one source, 12 million rows from a different source to perform blending.

currently the order of execution is the order in which tools are dragged into the canvas. Hence Source1 first, Source2 second and then the JOIN.

 

Here Source1 & Source2 are completely independent, hence can be run in parallel. Thus saving the workflow execution time.

 

Execution time is quite crucial when you have tight data loading window.

 

Hopefully alteryx considers this in the next release!

  • New feature

I think we would all benefit from having IntelliSense within Alteryx. Just think about how much quicker writing formulas wold be or any time you need to reference your data within the various tools.

Maybe it was a lack of planning, but I've had a need to rename a variable within a workflow and would like to (outside of the XML view) be able to rename the variable so that downstream tools don't have to be reconfigured (e.g. formula, join, union).  

Hi there!~

 

I work as an accountant for one of the nation's largest firms. In my day-to-day work, I utilize alteryx to cleanse and format data provided by our clients in preparation for use in another program that is very specific with its imports.

 

I was recently reviewing an Alteryx workflow prepared by a colleague. Upon attempting to run it again (with new input data) I noted some data fall out and am now reviewing the workflow tool by tool (first to develop understanding of the developer's mind, and second to make changes where needed).

 

During this review, I thought it would be very cool to have a Review/Markup view, where each tool could have a checkbox that could be checked/unchecked if that specific tool was reviewed/unreviewed. There could also be a circle function that could bring attention to specific places that are of concern in a workflow. This might work similar to how when one drags an Interface tool on the canvas, appropriate connections above non-Interface tools appear, only it would be a view that could be turned on/off.

 

In addition, I have a tendency to annotate the heck out of my workflows I create -- however there isn't really a way for reviewers to do this without modifying the workflow annotations nor adding a Comment tool with comments. It's especially difficult to do the later since space might be tight. Having a comment function that only shows up in the Review/Markup view would be amazing and very appreciated as I don't want to visually alter the workflow to accommodate such comments if it can be helped.

 

It would be even more helpful if a review/markup report (maybe a temporary PDF or .yxdb) that would summarized what was summarized as "reviewed, with no comments", "reviewed, with comments', "unreviewed, with comments", "needs attention", etc.

 

Lastly, with regards to fallout data, I would like to tag/trace a record and, after running the workflow, have the last location of that record be circled in red (or some other visual cue) on the canvas. Currently, I just create a "Flag" column (or, if it works, track a specific RecordID in Alteryx and follow my best guess of where the data may have fallen off -- something that can be very time consuming when I'm not familiar with the workflow.

 

The organization I work for has experienced some of the best time savings from Alteryx and currently supplies licenses to our staff members. In particular our Audit function may need to review some client processes, which may be entirely in some part Alteryx. As our managers attain Alteryx familiarity, they may also want to review our workflows for completeness and data integrity purposes. Having these functions above would definitely be something to look into and would further drive the review function further away from other more archaic programs and increase our usage of Alteryx throughout, and I'd be happy to be part of a testing for this if possible!

 

Thanks!~

Jon

I am bringing this over from this post.

 

It would be really cool to have a workflow that you could configure to your server that we could schedule to pull down the new Cass updates and install them. Since they have to be reinstalled every two months, it would help to manage that.

 

I think that the data updates are set up with an FTP site, Cass could be done essentially the same way. Download it there and then use the command module to run the install? I may be over simplifying the process but it seems like this is something that Alteryx could tackle.

Top Starred Authors