Alteryx Designer Desktop Ideas

I like the cool new features in designer 11.x

However, to my surprise when I searched for a sum() function..... it wasn't there yet

 

Math bucket has common functions such as Average, Mod, Median and some very complex functions such as Hyperbolic Tangent (an average user don't need it)

 

But a basic mathematical logic is missing : SUMMATION

 

Please add SUM() as a function

 

In Alteryx 11 the formula tool got redesigned but multi-field and multi-row tools have been left as it. It would be nice to have formula autocomplete and other new features in these tools as well.

Probably more of a bug. Not sure if this annoyes anyone else, but when a running workflow in a different tab completes, the current windows focus is gone, even you have the pop-up notification disabled. Check the video and see what happens at 0:11 when tab 105 finishes running while I'm typing a super complicated code 😉

 

I came across a requirement where it would have been very helpful if we could have a dedicated Tool or Formula within Alteryx to perform a function similar to 'INDIRECT' formula in Microsoft Excel i.e. when you want to change the reference to a cell within a formula without changing the formula itself.

 

I had to create a Macro to accomplish this in my workflow. But it would be great if Alteryx can provide a direct solution for this in Alteryx Designer.

Currently the Filter tool not supporting the multiple variable value check like a = b = c. It would be nice if the filer tool supports multi-variable check in one go.

 

 

I've been using the Intelligence Suite to automate building models using assisted modelling, It works great. However If I then output the model to the Python tool I ran into a few issues. The Intelligence Suite relies on the EvalML library so I wanted to use the python tool to use the model created with some of EvalML's other features such as prediction explanations.

What I found was that the intelligence suite for 2021.3.5 uses EvalML version '0.13.2' which is from 2 years ago meaning a lot of the extra features are not available.

It would be great with each new Alteryx intelligence suit the EvalML package also updated. 

 

 

I recently cam across a limitation in Alteryx, where we can't download non-CSV files using Amazon S3 download tool. There is currently support only for CSV, and couple of other formats but we are using JSON files (.jl) extensively and not having the tool download the files into the workflow is disapointing as now i have to build a custom code outside Alteryx to do that before I can start my workflow.

Can this be please given prompt attention and prioritized accordingly.

I learnt Alteryx for the first time nearly 5 years ago, and I guess I've been spoilt with implicit sorts after tools like joins, where if I want to find the top 10 after joining two datasets, I know that data coming out of the join will be sorted. However with how AMP works this implicit sort cannot be relied upon. The solution to this at the moment is to turn on compatibility mode, however...

 

1) It's a hidden option in the runtime settings, and it can't be turned on default as it's set only at the workflow level

2) I imagine that compatibility mode runs a bit slower, but I don't need implicit sort after every join, cross-tab etc.

 

So could the effected tools (Engine Compatibility Mode | Alteryx Help) have a tick box within the tool to allow the user to decide at the tool level instead of the canvas level what behaviour they want, and maybe change the name from compatibility mode to "sort my data"?

 

This is purely aesthetic but it would be great to have a button to auto format tools positions on the canvas. The idea would be similar to a feature many IDE's come with to auto format code so that the indentation is corrected and duplicate return characters are removed.

We currently have the Align and Distribute capabilities which is great. This could be expanded to the entire workflow so that the canvas could look at which tools connect to which and structure their positioning around that. I think it would be a great clean up feature after finishing a workflow. 

 

On 2019.2.5.62427, interactive results grid is only available for the embedded result window but not if you open the results in new window 'Open results in New Window' -> New Window

 

This is verified by @PaulN - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Interactive-Results-Grid-not-available...

 

It also appears that interactive grid is also not available if you double click a yxdb file to open it and view the content.

 

Would be useful to have the interactive grid in both these areas instead of just the embedded result window.

 

 

 

 

It was possible to read and write .gml (geography markup language) files in Alteryx. From 2018.2 and up, only write is supported. I do not understand why such a feature was removed, considering that this has become one of the standard geoformats. Joining data from .gml and .shp files is one of the key activities when dealing with geodata. Now I have to spend time converting the files (e.g. in QGIS or ArcGis). FME can read/write .gml just fine, so why can't Alteryx?

when using the R-Tool for simple tasks (like renaming files, for example) in an interative macro - there's a delay on every iteration as the R Tool starts up R.

 

The following are repeated on every iteration (with delays):

 

Can we look at an option to forward scan an alteryx job to look for R Tools, then load R into process once to eliminate these delays on every iteration?

 

I just got out of the Advanced reporting session at the Alteryx inspire convention. Preety cool stuff. I just have a request for the alteryx developers team. Can you please add the option to select a report coming from a Render tool directly as an attachment without having to write it out first? Just select it as a field the same way you can select a field as the body of the email. That'll make my workflow more streamlined and save space, as I'm sure it'll do for a lot of fulks out there.

*This is an idea from @fmvizcaino  from the Portuguese Community*

 

• Global DateTime support

I’m sure this has happened to you.

You’re working on several workflows at a time and you’ve made some progress on one of them but not saved it yet. You then try open the same file again in error and somehow, as you’re trying to declarer by closing windows, you mistakenly close the workflow you’ve made all the changes to without saving, leaving the one open without all your changes.

I’d like a similar situation where for example, you get an error message if you try and open an excel workbook if it is already open on your desktop.

There are a fixed number of data types and I hate having to scroll through them when I set the data type in a Formula tool. Can the drop down expand into a window that shows them all at once? It doesn't take up that much real estate. They can even be grouped by type. I mocked it up in Excel.

 

 

When using Alteryx from an enterprise, the understanding of all of the known Alteryx domains should be documented.

 

https://www.alteryx.com/

https://community.alteryx.com/

https://help.alteryx.com/11.5/index.htm

http://downloads.alteryx.com/

https://gallery.alteryx.com

 

Are there more domains that should be put onto the white list or is that the total set of websites necessary to use Alteryx without firewall issues? 

 

When downloading files from Alteryx, we also want to list the types of files that we should allow users access.  For documentation, I expect that we will see PDF files.  For installs, either ZIP or EXE files?  

 

When it comes to setting rules, the more information the better.  Otherwise, users may be blocked and not able to use functions.

 

Thanks,

Mark

 

When calculating distance from a single point (or a list of points) to many other points, it can require a lot of processing time to append the single point into the same table as the multiple points (especially with very large datasets).  Seems it would be more efficient to allow the single point as in input to the distance tool and bypass the timely append step.