Alteryx Designer Desktop Ideas

Hello,

A lot of tools that use R Macro (and not only preductive) are clearly outdated in several terms :
1/the R package
2/the presentation of the macro
3/the tools used

E.g. : the MB_Inspect

Ugly but wait there is more :

Also ; the UI doesn't help that much with field types.

Best regards,

Simon

Hello all,

As of today, you can only (officially) connect to a postgresql through ODBC with the SIMBA driver
help page :
https://help.alteryx.com/current/en/designer/data-sources/postgresql.html#postgresql

You have to download the driver from your license page

However there is a perfectly fine official driver for postgresql here https://www.postgresql.org/ftp/odbc/releases/

I would like Alteryx to support it for several obvious reasons :
1/I don't want several drivers for the same database
2/the simba driver is not supported for last releases of postgresql
3/the simba driver is somehow less robust than the official driver
4/well... it's the official driver and this leads to unecessary between Alteryx admin/users and PG db admin.

Best regards,

Simon

Parquet is a very fast, efficient and widely used data format, currently only below Parquet compression algorithms are supported and we cannot use Alteryx to read the parquet file that generated by other processes. This limits our usage in Alteryx.  

• Read support: Snappy and Gzip compression algorithms.

• Write support: Snappy only

It would be great for Alteryx to support all types of Parquet format so we can maximize the use of Alteryx in data analysis.

Hello

Cartesian product is a common issue when joining dataset with a bad key. What I suggest is an option to check if there will be a cartesian product on the join tool.

-there is a label "Cartesian product (non join key uniqueness) detection"
-under it a drop down menu with three choices
-do nothing
-fail
-warning

Algo :
if do nothing==> well... do nothing more than actual behaviour.
if "fail" or "warning" : count distinct of join key versus count row on each side of the join. If none is unique, display a warning or an error message.

Best regards,

Simon

Hi is it possible to add sheet names (to spreedsheet files) to the output of a file directory tool

when you bring in a comment box or tool container to your canvas it should come in with your preferred defaults for  fill colors, font color & size, etc.  I have specific color schemes to identify what my comments are for and one scheme that I use most often has font size, position & color, and background color that I have to set every time i bring in a new comment box.

 I LOVE working in Alteryx it because unlike excel you set a "macro" to perform repeating operations once and then ignore them to do your real work.  This concept should extend to the little things within Alteryx, i.e. settings for preferred defaults for comment boxes & tool containers. 

Please update the Render tool to allow users to name the Excel sheet for the output. Alteryx currently errors when using same naming convention that works in normal Output tool.

After using the PCA can there be a model object to output to be able to "score" new data?

Similar to PCA transform here https://stackoverflow.com/questions/26182329/how-do-i-convert-new-data-into-the-pca-components-of-my...

As currently there is no way to use this model with new data

Hi currently if you use the cross tab tool and the names of the new fields should have special characters they end up being replaced in the new headers with underscores "_", and then need to be updated in someway. It would be great if this was all done in the tool. In other words the new headers have the special characters as desired

When working in the Designer, I sometimes have to undo changes. And this experience is quite often very confusing and annoying.

For every change in the workflow, you have to press undo once. However, quite often, one user interaction results in other actions such as automatic move of the donwstream tool, change of size of a tool container etc. In such cases, you have inserted a single tool but need to press undo a couple of times to get back to the original situation. It is, however, often not clear how often. In most cases, I fail using undo at the end and revert my changes by hand.

Please change undo towards undoing one user-action in one undo step.

In case there might be users who like the current behaviour, you might make this a user setting how to deal with the undo history.

One of the most frequent issues I have with my workflow is when the Join Tool reorders columns for no reason. There is an option in the configuration to have the columns revert to the incoming order. It would be nice if the workflow automatically had this set as a default, or provide a toggle option in the settings for this to happen. In many of my flows I've had to create macros to keep the integrity of the column order or remember to go into the settings of this tool and re order the columns before a workflow run. 

I think we can all agree that Workflow Summary Tool is immensely powerful in summarizing large and/or complicated workflows.  However, some companies have begun to bar the use of certain GenAI applications, like ChatGPT. Unfortunately this makes the use of the Workflow Summary Tool impossible.  At the same time those companies are allowing the use of other forms of GenAI, like AzureAI.

In the Workflow Summary tool, it would be nice to have the capability to select which GenAI engine you want to use (ChatGPT, AzureAI, etc) so that you don't break corporate policy by using barred applications.  This could simply be a dropdown in the GUI configuration for the Workflow Summary Tool with a list of the most common engines.  The user would then supply their API key for that engine, and you're off to the races.

To embed the "Not ok" filter option in the browse tool

As of version 2023.1 once a workflow is locked, it cannot be unlocked. If Alteryx can unlock it, can it be made into a user option?

My idea has two parts. See the images for examples.

1. Add an option on the lock screen so the user can get an unlock passkey.

Passkey is either generated by Alteryx or set by user

2. Change the behavior when trying to open a locked file by giving the user an option to enter the unlock passkey.

Same behavior if there is no passkey

Dialog box with passkey input and cancel button if a passkey exists

This would be useful as a way to revise or edit a workflow or update the expiration date on the existing workflow without having to reload or resave a new file.

Currently, the "SQL editor" window only contain a box for typing text in, we could not see the schema and table on it's side as a reference, we need to jump back and force between "Visual Query Builder" and "SQL Editor" search for table and column names. If we could see the database schema and table in the SQL Editor interface, it will save us a lot of time.

Hello all,

As of today, if you have admin and non-admin version of Alteryx Designer installed on your computer, and install Business Intelligence Suite, you are able to run either version. It will not run both versions. This means whatever reason you installed admin and non-admin version, Business Intelligence Suite will run with only one Designer. 

I installed my computer Alteryx Designer 22.3 non-admin and 23.1 admin versions, both Predictive Analytics. I also installed BI Suite admin version, and BI suite non-admin version. Alteryx will uninstalled admin version, and kept non-admin version of the BI Suite. So, I can use BI Suite only with non-admin version now.

I'm bringing this idea for your vote to make available for both profiles/versions within Designer.

Thanks for voting

Hi 

I think its super frustrating not beeing able to search for dates, or date ranges in the result window.

Lets say I have a dataset with 2 dates, date picked up and date delivered.

Then I need to search broad in the result window, for a given date. With search in both coloumns.

Could we please have a simple specific date search, and maybe a from-to date? Like in the filter?


Or go all the way and look at excel date filter?

Kind regards

I am facing an issue regarding the result window. The tabbed document function is disable for the result window. I did not see the entire result window. Kindly find the below mentioned screenshot for your reference.

Request to reverse the feature.