Alteryx Designer Desktop Ideas

When typing a function (often the formula tool), you can use autocomplete to get the syntax to display, however if you are editing a previously written expression, you have remember or try to guess at the syntax.  This often leads to having to consult the documentation or adding an extra duplicate function below your code just to see the syntax (that you then have to remember to remove).  This process could be improved by showing a window that shows the function syntax while you are typing within the parentheses of the function.  This would be even more useful with nested functions to see which function you are within.

Thinking you're able to open the config file like you might a macro. You pull it open, adjust/modify it , you resave it. 

Save/Load Unique Key Tool Configuration – similar to saving/loading other tools configs  (ie: select, join, append, etc)

On the "Join Tool"  allow to click on a connection and say “switch L & R” connection.  Currently if only one connection is there you can move to the other, but if they're both there, you have to disconnect one, and then 'switch'.   

Please add either or both

1. "CustomFile/Database", similar to the TREE tool to the Text Box interface tool
2. An option to make TREE Tool "silent" or passive when using the "CustomFile/Database" option

The purpose is to provide a better way to pass data, and thus allow "Action" tool to be used, from interface responses in a previous App chained to the current App.

Use Case:

We had a workflow with 8 TREE tools and 3 of them had significant number of rows associated.  This caused frequent failures where the queries getting the multiple layers of data for the TREE would time out.

Through trial and experiment we determined this was the issue by removing TREE tools until we had consistent function.

Most if not all the TREEs and all of the 3 offending TREEs were used to modify FILTER tools, in this case each of those 3 TREEs 3 or 4 Actions driving the same number of FILTERs

So we had to find a way to break up the operation.  Ultimately I separated the 3 large volume TREE tools into a separate workflow to run first and then CHAIN to the original flow with modifications to read the responses passed from the new 1st workflow in the chain and replaced the FILTER with JOINs, effectively filtering by JOIN.

This worked but was extra work and it made me think of the many other situations where I would like to take input from an external source and affect a FORMULA or FILTER or a few other tools where an ACTION is best/only way to modify tool configuration at run time.

I think this lack of a way to use an ACTION tool with a "Non-Interface" data source has probably limited the opportunities of Applications.

Given the division of labor in an APP,

1. run all Interface tools first and modify config of other tools
2. then run the rest of the tools on the canvas

there is no way to make a run time ACTION tool as it must do its job before the core job runs. 

This adaptation of the TREE tool, which is my preference, or the adaptation of the Text Box tool, offer good solutions that should be fairly simple to code and roll out the the user base.

Hello all,

As of today, you must set which database (e.g. : Snowflake, Vertica...) you connect to in your in db connection alias. This is fine but I think we should be able to also define the version, the release of the database. There are a lot of new features in database that Alteryx could use, improving User Experience, performance and security. (e.g. : in Hive 3.0, there is a catalog that could be used in Visual Query Builder instead of querying slowly each schema)

I think of a menu with the following choices :
-default (legacy) and precision of the Alteryx default version for the db
-autodetect (with a query launched every time you run the workflow when it's possible). if upper than last supported version, warning message and run with the last supported version settings.
-manual setting a release (to avoid to launch the version query every time). The choices would be every supported alteryx version.

Best regards,

Simon

Alteryx can enhance the interactive dashboard capabilities by adding more visualization options, such as heat maps, treemaps, and network diagrams. This will allow users to create more informative and engaging dashboards, and enable them to better communicate insights to stakeholders. For example, Alteryx can add support for heat maps and treemaps, allowing users to visualize data density and distribution, or network diagrams, allowing users to visualize relationships between data points.

Alteryx should take a look at the BI platform so they can integrate the Dashboard Capability and remove the dependency of Visualization tool and become one stop solution

Alteryx can add more advanced machine learning capabilities, such as deep learning and neural networks, to its existing set of predictive modeling tools. This will allow users to perform more complex and accurate analyses, and enable them to tackle more sophisticated machine learning problems. For example, Alteryx can add support for deep learning frameworks like TensorFlow and Keras, which will allow users to use pre-trained models or create their own models for image and natural language processing.

Alteryx can improve the data connectivity options by adding more built-in connectors to various data sources such as big data platforms, cloud-based services, and IoT devices. This will enable users to easily access and import data from a wider range of sources, without the need for complex coding or manual data preparation. For example, Alteryx can add connectors to popular big data platforms like Hadoop and Spark, or cloud-based services like AWS and Azure, which will allow users to easily import data from these platforms into Alteryx for analysis.

Take this example macro

I've build in a message on the tool to inform the user that the macro is set up in test mode. What this macro does is it will either filter the records based on a condition which the user provides in the macro configuration via a text input tool, for example Contains([Name],"Goodman") or they can select a check box to override the testing mode.

What I want is the user to be notified when there is a filter condition being applied, so they can quickly identify where in the workflow data might not be the full dataset. At the moment this is achieved using the error tool, but due to be it being the error tool you are limited to only specifying the red !

Therefore my idea is to update the error tool to allow the user to specify additional indicators, such as a warning triangle, because the message I am displaying is actually a warning to the user. Additionally it would be great if you could provide custom images (for example a glass flask) to show it's in a test mode, like you can with the macro image tools.

At the moment, in order for users in our organisation to run apps, they need to be added to permissions for the data connection for the server/DB the app uses (as we use Gallery connections for ease of collaboration within the Analytics team).

This is fine provided users running the apps do not have Alteryx Designer, however, we have users across the business who do use Designer - we don't always want these users having direct access to query the server/DB through designer just because they have the connection in order to run workflows on the Gallery. It's my understanding that at the moment this is necessarily the case, which is not ideal.

Would be great if we could grant permissions for users to use the connection to run apps in the Gallery without that enabling them to use that connection in Designer to query the DB however they want.

Hello everybody,

I'm seeing an increased usage of geojson and kmz files across many popolar open data.

Would it be possible to add them to the supported Alteryx input formats?

Thanks!

Would be great if anytime a tool (macro tools in particular such as "Data Cleansing" tool) is copied all items from the copied tool are retained to the new pasted version of the tool. Would expect in the instance of the Data Cleansing tool for example that in lieu of not showing the fields that were in the copied from tool to be shown similar tool in which they show but noted as "Missing" and then as the new copied tool is attached to a like data source (likely same data source elsewhere) they then are checked or not checked and no longer showing as "Missing". 

This would allow these tools to be copy/pasted and repurposed vs wiping out as they won't be associated right away on the pasting process until manually moved into the proper place on the respective new or updated workflow.

It would be nice to be able to concatenate numeric values (integers, doubles, etc.) directly in the Summarize Tool.

I know this would involve converting it to a string on the backend, but I don't believe there would be any data loss when going from numeric to string. I know this can be done by using other tools like Select of Formula to convert to string before the summarize but I don't see any reason why this couldn't be accomplished in a single tool.

Thanks,

Paul

I think the undo/redo capabilities in Alteryx could be greatly improved. Here is an idea that I think would be beneficial... 

I'd like to see which exact tools are affected by my undo/redo actions. An idea was suggested a couple years ago to move your location on the canvas, but that was not added to the roadmap. Instead, is it possible to add the tool ID to the undo menu so that it is obvious which tool each line is detailing?

This is the current debug menu that shows your previous actions:

When a tool is created, the ID can be displayed in this menu, but this is not shown when a change is made to an existing tool. My suggestion is that the menu would say:

4. Change Sort (3) Properties

This same change should be made in the Edit dropdown menu.

Dear Development Team,

Can we bring back to multiple-column X-axis feature for chart?

The old (depreciated) Charting Tool allows to output 2 dimensions on the X-axis in addition to having an option for "Dynamic/Unknown" column(s). This is not possible with its supposed replacement the Interactive Chart Tool.

A possible use case is Weekly Challenge #91 Challenge #91: Getting into the Weeds - Alteryx Community

If we use the current Interactive Chart Tool, we will need to manually specify 64x layers to cover all bases. Even then the solution will still fail if more "weed types" are added to the datasets.

Considering that bar/column chart is likely the most commonly used and also most basic chart, please can we either bring back the fully supported Charting Tool or add this feature to the current Interactive Chart?

Thank you.

Dawn.

Hello All,

I am not sure whether my idea makes sense or not. 

In today's advanced analytics world, we used RPA for various automation, process simplification, etc. There are CO-BOTs that are designed to run the Alteryx flow as well. Through RPA we are able to log in to the system and tools like Cognos, Oracle, TM1, and so on.

So, I am thinking, if Alteryx developed RPA as a tool in the Alteryx Designer like other tools such as Join, Transform, ML, Computer Vision, Interface, etc. 

I believe the implementation of RPA in Alteryx will prove an Asset, and make Alteryx.com more powerful.

Thanks,

Mayank

Although this could also effect ANY formula, the RegEx tool does not support a flag for Multiline.  Often incoming data contains multiple lines of data and the user must replace new lines and carriage returns with a space or other delimiter in order to operate a regular expression on all of the data.

RegEx has a multiline flag (for Alteryx it would be a checkbox) that allows it to handle each line separately.

domain.com

test.com

site.com

if these are individual records, then \w+\.com$ works wonderfully,  if these are all contained in a single EXCEL cell, then you need to write to community to figure out what to do.

Cheers,

Mark

Hello all,

I really appreciate the ability to test tools in the Laboratory category :

However, these nice tools should go out of laboratory and become supported after a few monhs/quarters. Right now, without Alteryx support, we cannot use it for production workflow.

Example given :
Visual Layout Tool introduced in 2017
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Visual-Layout/ta-p/835...

Make columns Tool also introduced in 2017
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Make-Columns-Tool/ta-p/67108

Transpose In-DB in 10.6 introduced 2016
https://help.alteryx.com/10.6/LockInTranspose.htm

etc, etc...

Best regards,

Simon