Alteryx Designer Desktop Ideas

Hi,

It would be great if we can get the collection name by using some engine variables in the workflow. By doing so, we can use collections extensively for client specific categorizations. If we create collection for each client and if we are able to get the collection name from which collection this workflow got executed, then we will be able to track the executed workflow is performed against that respective client. This will solve the db connection establishments, i.e. based on the collection name (i.e. client name) we can build the respective client db connection the same workflow.

In GIS, spatial data is regularly stored/transmitted as text. With this comes metadata, including the projection used.

Example Issue: When extracting data from ESRI's ArcGIS REST Directories, the projection can be extracted from the information, but must be manually defined in the Make Points Tool. If you are trying to compile data from several different sources, all using different projections, you cannot automate the process. 

Suggested Solution: Add WKT to macro interface configuration options so that an Action Interface Tool can update the Create Points Tool.

Attachments:

JSON extract.png - This is a screenshot of the spatial reference metadata in a JSON formatted query from an ArcGIS REST Directory. 

action tool.png - Current configuration options for Create Points Tool in the Action Interface Tool.

The Summarize tool should have an option to ignore warnings like this:

Group Bys on Double or Float are not recommended due to rounding error.

As a user, I would like to have the ability to define the default table formatting settings for font, border, font size, font style etc within the table tool so that I do not have to redefine each time I create a table.

I understand I could copy the table after doing it once and use for subsequent tables created, however it would nice to do this once and utilize this as the default for future workflows.

These settings could be defined in a report focused section of User Settings, or defined within the tool.  For example, if in the tool, features could include a box to (make current settings default, revert back to factory default, etc.)  Another beneficial feature would be to create "presets" that could be selected from a drop down that would automatically update the customized settings to match a previously defined combination of formatting specifications.

This could be extended further to formatting rules related to columns and tables as well, saving the time spent on setting up rules previously utilized.

Hello Alteryx fans and Devs!

For the Summarise tool - would it be useful to have a "Rank" option for the potential Summarise options we can use? Just a thought!

The "Text To Columns" Tool Can do Split to Rows and Split to Columns, the name says that it can Text To Columns but it can Text To Rows also, it would be great if it has name something like "Column Splitter" as it can split data horizontally as well as vertically i.e. in form of Columns or Rows!!

It would sound cool !!!

On Right Clicking to "Comment" we should be able to convert it to "Tool Container" or "Tool Container" to "Comment". Also, it should map all the common configurations or similar. The mapping can be as such:

This example is from Comment to Tool Container,

Text --> Caption upto length 200 or so,..

Shape --> NA

Font --> NA

Text Color --> Text Color

Background Color --> Fill Color and Border Color

Text Alignment --> NA

Background Image --> NA

Transparency and Margin to Default 

When writing an expression in a Formula tool, I love that you can just type an open bracket and suggestions pop up that allow you to auto-fill the rest of the variable name. What I find frustrating, however, is that once you type the open bracket, the highlighted field automatically moves to the one where your mouse is pointing, regardless of if you have moved your mouse or not. I think it makes more sense to always highlight the first field in the list and only take mouse position into account once it has actually moved.

It is hard to describe in just a picture as opposed to a video but essentially I had my mouse below where I was typing in the screenshot below then when I typed the open bracket, the 3rd field listed automatically got selected even though I never moved my mouse.

Cc: @Hollingsworth 

The R tool has AlteryxProgress() and AlteryxMessage() functions for generating notifications in the Results window https://help.alteryx.com/current/designer/r-tool, however the Python tool does not. Since I'm writing more Python code than R code I'd like to have similar functionality available in the Python tool, e.g. an Alteryx.Progress() function and an Alteryx.Message() function.

Jonathan

Gallery is useful for sharing workflows or web-based storage. However, if you want to open a set of workflows that are not otherwise linked, but for example are part of a single project, it would be helpful to be able to save it as you might to a folder. Likewise, if you want to add a workflow to a group, you have to open all the workflows and then resave the workflow group.

Suggestion 1: Add an option in the Meta Info Tab of the Configuration window that would allow you to select/create a workflow group to add the workflow to.

Suggestion 2: Allow keyword tagging of workflows with a search option so that similar projects can be searched for and compared easily. This is already available in Server, but would be extremely helpful for small businesses where there might only be a single user, as is my case. ESRI's ArcGIS Online has this tagging capability as a reference.

It would be great if Alteryx could introduce a tool implementing a Decision Model Notation (DMN)-style Decision Table as an option to remove business logic from a workflow.

Arbitrary business rules are frequently implemented against datasets in Alteryx workflows before actual processing occurs. The implementation of complex business logic frequently results in a spider web of join, filter, formula, and union tools. 

I personally think it would work better to tab from 'Select Column' to 'Enter Expression Here' and not the 'Functions' List as probably people who are tabbing would immediately like to start typing the formula rather than going through functions, fields, etc.

It will be really useful if the Microsoft Query (aka MS Query, aka Excel Query) can be incorporated in the formula tool. This can make the workflow small and make the tool more powerful

I can't believe Alteryx doesn't have a tool or function that can convert string numbers to numeric values even when the string number has commas.

I know you can always put in a Formula or MultiField Formula to remove the commas, but this is the 21st century.  It ought to be an option in the ToNumber function and a checkbox in the Select tool when changing Type.

Hi,

I am using the Interactive Chart to create a line-chart, but I would like to have values of (X,Y AND Trace Name)

I cannot display it for the différent regions, when we move the mouse over the curve the parameter is applied only for one region.

FI: it works if i modify the xml code by adding the following code to each region:

<value>
<hoverinfo>x+y+name</hoverinfo>
</value>

Is it possible to add it directly in interactive chart ?

Thank you.

Is it possible to have a "Run Workflow" option in the right click dropdown menu?

Sometimes you may just want to run the workflow at random from the convenience of your desktop without using the Alteryx server's capacity. When that is the case, you have to open the workflow, wait for it to load in Alteryx, and click "run" from the canvas. Instead, I would like to right click the workflow's file path and click "run workflow" from a dropdown menu without opening the workflow itself. When the file is complete, I can either receive a pop up to inform me it is complete, the time it completed, and the runtime or I will just know by checking the date/time modified in my output file. And if you have disabled all output in that specific workflow or it writes out to a database, an email, a server, or somewhere else that may not be able to handle this new feature, the "run workflow" could simply gray out in the dropdown menu to indicate it is not an option for that workflow. I think this would be a very nifty feature for your .xlsx, .tde, .txt files, etc. that output in the same file directories,

Thanks for reading!

Please could we add Qubole to supported data sources,

https://www.qubole.com/

It is possible to connect to Qubole via ODBC Connection

However, this error message is often returned on a query: InboundNamedPipe GetOverlappedResult: The pipe has been ended 

I've been advised by Alteryx Support that this is likely due to the ODBC driver. 

If it's possible to add Qubole to supported data sources it would save a lot of time committed to troubleshooting this error.

All the best

One idea that could help a lot of users while preparing dashboard solutions where we might need to attach artifacts for proof or references that might have helped us in developing the dashboards.