We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

Hello - the added feature to show the designer tool detail of the four highly used tools (Join, Formula, Filter, and Summarize tool) is an incredible addition to Connect functionality. Can this functionality expand to the In-DB version of the same tools? We leverage In-DB when possible to utilize the processing power of the database. Adding this as well to Connect would be a huge benefit to see the complete picture of a workflow.

 

 

Hello,

 

In Alteryx Designer application, in User Settings, please add an option for us to check/uncheck whether we would like to show/hide the Splash Screen upon app launch.

 

Thanks!

  • Feature Request

So lets say I have five incoming connection.  SQL, Redshift, Excel...whatever.  I know I can right click, or control-right click on each incoming connection and select cache and run workflow.  I'd imagine there would be a run and cache all incoming connections but there isn't.  I realize I can arrange all incoming connections so they arrange easily so I can box them all, but on complex workflows, this might get complicated.

Most of the finance industry is using HFM or Essbase finance solutions which is flexible in keeping the data and generating reports. Alteryx should create a direct connection with Hyperion or Essbase so that it's easier to connect with the data in those systems and it can directly feed other system reports.

  • Feature Request
0 Likes

Hello Team,

 

I have been using Alteryx for sometime now. The final output of any kind be it analytics or simple Excel outputs is expected to have some basic formatting.

 

A minimum of 3 Tools and humongous effort is need to format even basic headers and Cells with a border and color.

 

Using Table followed by Render and then column level setting for having borders for the set of data is little time consuming considering it has 0 impact on the actual data output.

 

Additionally Render tool to Excel will be in number format regardless of the data type. Same is the case for date fields.

 

Also the Render tool Layout changes impact the data as well as the column lengths adversely.

 

Can we have some simple option of overwriting a file where the formatted excel is merely overwritten with data without changing the datatype or format out the excel sheet.

 

It would be huge win if this is easily do-able wither via a new tool or as an option in the output tool.

 

 

  • Feature Request

Maybe I am a newbie, but it is really galling that the drop down tool in the interface palette wont show the values in a connected tool unless they are spun up as headers in a cross tab using a record ID ruse. Alteryx really needs to provide this very common use case. This functionality is so easy to implement and is a fundamental part of any UI. Take a field and show its values as a drop down. Please tell me I am missing something and that this is really easy. I know we can save it as a name value pair in a yxdb and then input that, but I should not have to do so many things for what is an essential function.

  • Feature Request
0 Likes

Hello All,

 

During my trial of assisted modelling, I've enjoyed how well guided the process is, however, I've come across one area for improvement that would help those (including myself) overcome any hurdles when getting started.

 

When I ran my first model, I was presented with an error stating that certain fields had classes in the validation dataset that were not present in the Training dataset.

 

Upon investigation (and the Alteryx Community!) I discovered that this was due to a step in the One Hot Encoding tool.

 

Basically, the Default setting is for all fields to be set to error under the step for dealing with values not present in the training dataset, but there is an option to ignore these scenarios.

 

My suggestion:

Add an additional step to Assisted Modelling that gives the user the option to Ignore / Error as they see fit.

If this were to be implemented then it would remove the only barrier I could find in Assisted Modelling.

 

Hope this is useful and happy to provide further context / details if needed.

Every workflow I write, I want it to avoid having references to my C: drive.  Every time I enter a tool, I have to remember to reset the Workflow Dependencies to All Relative. 

 

If the setting for Workflow Dependencies could be a persistent environment variable, I could flip the flag, and every tool added after that would use relative references.

  • Feature Request

Hello Dev Gurus - 

 

The message tool is nice, but anything you want to learn about what is happening is problematic because the messages you are writing to try to understand your workflow are lost in a sea of other messages.  This is especially problematic when you are trying to understand what is happening within a macro and you enable 'show all macro messages' in the runtime options.  

 

That being said, what would really help is for messages created with the message tool to have a tag as a user created message.  Then, at message evaluation time, you get all errors / all conversion warnings / all warnings / all user defined messages.  In this way, when you write an iterative macro and are giving yourself the state of the data on a run by run basis, you can just goto a panel that shows you just your messages, and not the entire syslog which is like drinking out of a fire hose. 

 

Thank you for attending my ted talk regarding Message Tool Improvements.

 

 

It would be great to have the below functionality in Alteryx.

A workflow is built in Alteryx and button click in Alteryx can be used to generate SQL code that can be ran on a specific database platform, such as SQL Server to run external editors such as SQL Server Management Studio. Thanks. 

Alteryx Server was recently updated to allow TLS-mediated connections to the MongoDB persistence layer. This allowed us to switch off of the embedded MongoDB to a highly-available MongoDB Atlas cluster. To our surprise after the switch, when we went to edit our workflows that make use of the persistence layer's data (Server Usage Report, etc.) to hit the new Atlas cluster, we found that the MongoDB Input tool does not support TLS connections. This absolutely needs to be changed. Based on organizational constraints, Atlas is our only option for a HA persistence layer. We absolutely have to have TLS support for the MongoDB Input tool. There is no other way for us to natively query our server persistence layer in Designer. Please bring the MongoDB Input tool into alignment with the MongoDB connections that are supported by Alteryx Server.

 

The recently added feature to sort and filter entries inside the Results Window of the Browse tool is great. However, once I open a new window with the result, the functionality dissapears and I am stuck with a static table where I can only scroll through.

 

Would it be possible to add the filter and sort funtionality to a new window as well?

  • Feature Request

While almost all interface tools allow for default values, the listbox / manually set values does not.  The idea would be for a property on each line that when displayed to the user would have one or any values checked upon entry.  The configuration might look like Name:Value:Default.  I.e.

Alabama:01:Yes

Alaska:02:No

Arkansas:03:No


I would use this to pre-populate the listbox with entries from a database that would essentially allow the user to edit his previous entry.  In this example, the user previously selected Alabama and the results were stored in a database.  When editing the record using an analytics app, I would want the user to see what he chose and the other options available.

 

daviskb_0-1595938483048.png

 

Tim_Slade_0-1595858093072.png

I want to check out which things downstream are receiving data from the true and false branches of this filter.

I could step through them one by one.

It would be much easier if I could simply select the tool and see directly which tools are connected to which output by colour, or line style.

Could the Input connector have capability to load data from an ODS / OpenDocument Spreadsheet?

 

Currently file with an ODS has to be opened using Microsoft Excel. Save file as xls or xlsx extension.

 

Also an ODS file with 373 columns/fields required to have fewer columns /fields to use the Alteryx Input connector.

 

Submitting this idea, after initially logging on the community board.

0 Likes

I find myself constantly in a situation where I am building a workflow and need to add a browse tool or branch out from the main path to test some ideas or check something and it is very annoying having to run the whole process again, I know that there is the option to cache but it the criteria is very impractical because you can't cache at different points in the workflow easily.

 

It should be possible to add some tools like browse or output to a file without having to re-run the whole workflow again.

  • Feature Request

Hi team,

There are some things that we would like to do with the download tool that currently are not possible:

 

1. use client side certificates to sign requests. This is a requirement for us in a project where we are interacting with the API of our customer's financial system. They provide us with a certificate and it is used to sign our requests, along with other authentication.Currently we have to use the external command tool to execute a powershell script using invoke-restmethod to do this interaction. I would much prefer to not have more tools in the chain.

Client certificates are described in the TLS 1.0 specification: https://tools.ietf.org/html/rfc2246 (page 43), and I believe them to be supported by cURL.

 

2. Multipart form-data. We have a number of workflows where we need to send multipart form data as part of a POST request. As this is not supported by the Download Tool, we have again used the external command tool to execute invoke-restmethod or invoke-webrequest in powershell. I don't know if modification of the Download Tool would be the best thing here, vs having either a dedicated tool for multipart form data, or having an HTTP POST specific tool that was able to handle multipart form data. What I envisage is something like the formula tool, with the ability to add an arbitrary number of cells, where we could use formula to either directly output a value from a column, synthesise a new value, or directly enter a static value). The tool would then compose this with boundaries between the parts, and calculate the content-size to add to the http request.

We have a lot of workflows with a lot going on in them, as I'm sure a lot of you do.

Sometimes, the way that Alteryx draws the connections between tools is loopy, literally.

It would be very helpful if we could explicitly control how the connectors were routed, as this would allow us to prevent them from cutting across other complex areas of the workflow.

Also if we could bundle the connectors (think tying together a bunch of cables with a cable tie) so that things that were heading to the same part of the canvas could route there as a bundle.

Exactly as the subject says: It would be incredibly useful to be able to change the colour, and possibly the line thickness of the connectors between tools.

We have workflows with huge amounts of stuff going on, as I'm sure many people do.

Being able to colour code the connections between tools would help us to trace things from place to place when stepping through the workflow.

I need to input some zip files which are password protected. There should be a method to input them without manually entering the password.

Top Liked Authors