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

Featured Ideas

The eMail setup for the eMail tool and the eMail notifications are subtly different - in that the eMail notifications screen does not offer an explicit location for port.    This is important if the SMTP server does not use the default port.   You may be able to do this with : notation, but it would be better to create an explicit field for this.

 

 

No Port available on the eMail settings for EventsNo Port available on the eMail settings for EventsPort is available on eMail toolPort is available on eMail tool

Currently when you add an event to notify you of workflow failure / success - you have to enter the SMTP settings every time.    It would be more efficient to set this up as a user setting which can be used for the default across all canvasses that this user creates.

 

Annotation 2019-12-27 180328.pngSettings.png

Hi all,

 

Would it be possible to update the What's new page for 2019.4 to include the key features in this release (in my mind, one of the biggest features is the SQL formatting)?

 

Currently if you go to the What's new link in Designer, it takes you to the right webpage, but there is no content for 2019.4

 

Additionally - would it be possible to keep a few releases on this page - often people skip 2 or 3 updates so it's worth keeping the top highlights of the last 4 releases there so that people can see the new features and explore them.

 

The great thing about What's New pages is the ability to explore new features, so it's worth linking out to examples on a page like this if possible.

 

WhatsNewLink.pngWebpage.png

  • General

My team uses a shared macro repository (say F:\AlteryxMacros), and we recently ran into an issue with the default save location for macros. While we save most macros to our repository, there are times when folks save their macros elsewhere (let's say C:\MyAwesomeWorkflow). The issue we've encountered is that if you go to file >> save as with a macro, it will ALWAYS default to the macro repository, even when my macro is currently saved elsewhere (C:\MyAwesomeWorkflow). Speaking for a friend, people have accidentally saved things to the macro repository by accident. Or, they waste time navigating from the macro repository to the their current folder.

 

If a macro is saved somewhere, please change the file >> save as to default to the current folder. Thanks! 

I built some workflows which will input full or sample data in multiple Input Data tools based on changing the value of a user constant. These workflows have email events enabled after run.I want to change the email subject based on whether the workflow ran in full or sample mode. That's my use case. I know that I could do this using the Email tool and that's not going to work in my use case. If the workflow fails, there won't be an email. Also, I don't know if the Email tool is blocked by just my Gallery or by all Galleries.

 

To generalise this, I want to dynamically change email event subjects, bodies, and more by either using expressions/constants from the workflow or by having an expression editor directly in the event itself.

 

Thank you.

0 Likes

Can we have an Alteryx environment that is like a free sandbox similar in nature to Tableau's Tableau Public? It will really help people wanting to get Alteryx certified prepare for certifications without paying the expensive AUD7,795. Please help the jobseekers who would like to pick up Alteryx but cannot afford your hefty price tag just yet.

In instances where many tools need to be connected to one tool, I think a "Connect All" type of function might be useful.

 

For example if you had 4 threads of data that all ended in a select tool and needed to be connected to a Join Multiple tool, you could grab all of the select tools and the Join Multiple tool, right click, and then select "Connect All" which would connect each select tool to the Join Multiple tool.

 

I think this could be implemented a few ways:

 

1) Right-click and select action

2) Keyboard shortcut

3) Holding shift on a selection of origin tools and then clicking on the shared destination tool

 

I've added a screenshot of a quick Photoshop representation of this idea.

 

connect all feature idea.png

 

Hi Alteryx,

 

Today, Alteryx is can connect to AWS Aurora DB, but it is only for MySQL.

How about AWS Aurora PostgreSQL ? Will it be included in the next release ?

 

Best Regrads,

Samuel

It will be great if we have a round down or round up function just like excel in Alteryx. I know we can use the left function after converting the number to string, but it becomes difficult when the decimal value is huge.

Currently, the Open Recent (from the File toolbar) generates a list of the 10 most recent workflows opened in Alteryx Designer.  It would be useful to show even more (20-25?) workflows through this method as there is enough open space on the screen to do so.

  • General
0 Likes

I am using 2 or 3 displays set up to be more productive with most of my work. If only we can have snap-on features in Alteryx that support for the windows to be able to snap on multiple displays, not just floating. 

 

The problem with floating windows is they are not correctly aligned for the full-frame and some require custom resizing. to make it worse, some floating windows interchange in their resolution due to multiple resolutions of the display and the non-snap floating windows (configuration, results etc.)

I am always checking for some view (browse tools) and editing other tools. When moving around to editing other tools, the view will disappear with other selection. If there are features when we can have multiple views (result) as a reference and compare them together.

It would be great if in the metadata we can have example of data inside

Oracle (https://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#CNCPT413😞

  • DATE = yyyy-mm-dd hh:mm:ss
  • TIMESTAMP  = yyyy-mm-dd hh:mm:ss.ssssss (6 decimal seconds .. and timezone?)

Alteryx (https://help.alteryx.com/2018.3/Reference/DataFieldType.htm😞

  • DATE = yyyy-mm-dd
  • DATETIME  = yyyy-mm-dd hh:mm:ss

In an ideal world the Alteryx DATATIME would map to the Oracle DATE ... and only to the Oracle TIMESTAMP if it had fractional seconds.

 

Currently DATETIMEs get mapped to Oracle TIMESTAMP.

  • General
0 Likes

I think it would be great to introduce something like Ghost Input Data tool. The tool would refer to an Input Data tool that is used in the same workflow multiple times but is placed far from several other tools it needs to be connected to. This way the data would have to be loaded once and annoying and distracting connecting lines can be avoided.

  • General

The RegEx tool has a drop down list so that user does not need to go KnowledgeBase; the specifier list should be added to the DateTime tool so user has a quick reference.

 

Users would benefit from this concept if done elsewhere as well

As in power point, it would be great to repeat the last action done, such as drag again into the canvas the last tool that was drag, if you just selected some tools and aligned them vertically, then selected other tools, press F4 and align those too...

  • General

Allowing the containers to be manipulated in size much like the explorer box tool - it feels like sometimes the containers stretch to far and cover to much blank space - allowing for a cleaner looking workflow.    

I often encounter situations where I need to apply the same formula to several columns. Doing this requires copy/pasting the formula several times  and then updating the variable names in the formula for each output column. I wish there was a built in "Current Output Column" variable so that I could build one formula and use that for each column. 

 

For example: 

 

clipboard_image_0.png

 

  • General

I have been developing and accumulating custom functions over the years and they have proved to be very useful.  I am submitting these here.  I hope they are found to be beneficial.

Functions included in the attached file include:

  • DateTime
    • StandardDate(String) - Transforms any valid string to the standard date format yyyy-mm-dd
  • File
    • FileDirDepth(Path) - Returns the zero based depth of the path (zero being the root)
    • FileGetFolder(Path, Depth) - Returns the folder name given the zero based depth in the path (zero being the root)
  • String
    • LeftPart(String, Separator) - Returns the left part of a string up to the first separator
    • RightPart(String, Separator) - Returns the right part of a string after the first separator
    • Split(String, Delimiter, Index) - Returns the zero indexed part of a delimited string
    • CleanSpace(String) - Trims string and replaces multiple spaces with a single space
    • UnicodeToASCIIBasic(String) - Replaces all Unicode Characters with ASCII Basic equivalents
  • Test
    • InList(Variable, List) - If Variable is in List returns True. List must be pipe delimited
    • IsValidEmail(String) - Returns True if string is a valid email format
    • IsUUID(String) - Returns True if string is a valid UUID

To make these functions available in Alteryx, place the attached xml file in the folder C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn if you have a standard installation. If the install is non-standard, find the \bin\RuntimeData\FormulaAddIn folder and place the attached xml file there.  Ateryx will need a restart for the functions to be available.

  • General
Top Liked Authors