Alteryx Designer Desktop Ideas

Lets say you have a row of 10 filter tools vertically and there's a select tool coming out of each input for each filter. It can get dizzying to tell the difference. It would be great to be able to select a colour for tools when on the canvas so e.g. in the above I could say " my green selects are the true and my red selects are the false"

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 try to use the Comment tool for documentation within workflows for team members (and my future self when I have to revisit it months after I built it). It would be helpful to be able to use markdown formatting inside the tool.

This might even encourage more documentation. *fingers crossed*

Just like there is search bar for Select Tool, there should be one for Data Cleansing tool also.

Hi there,

When you connect to a DB using a connection string or an alias - this shows up in the Workflow Dependancies in a way that is very useful to allow you to identify impacts if a DB is moved or migrated.

However - in 2023.1, if you use DCM then the database dependancies just show up as .\ which makes dependancy management much more difficult.

Please could you add the capability to view the DCM dependancies correctly in the dependancy window?

BTW - this workflow Dependancy Window would be a great place to build a simple process to move existing DB connections to a DCM connection!

CC: @wesley-siu @_PavelP 

Alteryx is not able to read generated Excel sheets which have the prefix "x:" within it's XML tags.  Often this occurs when an xlsx file is created from a bot or rpa process.  Example file attached.

Hello All,

I believe there needs to be a new tool added to Alteryx. I am frequently encountering cases where I will have 0 data point feeding a workflow stream that causes my workflows to fail. Because of this, I am having to put in fail safes to keep this from happening.

There should be a tool that if there is no records that are passing into it, anything after that tool will not fail.

For an example, within a workflow I am using a dynamic input that will pull a dynamic file. The file is not always there and the workflow should be able to run if that file is there or not. If the dynamic tool and other tools would process 0 records without failing this would also solve the issue. 

I would be nice to have a tool that will  block off the work stream if there are 0 records passing through the tool. 

Hi there,

the Snowflake documentation only refers to connection strings which use a DSN such as this page Snowflake | Alteryx Help which refers to the connection string as odbc:DSN=Simba_Snowflake_JWT;UID=user;PRIV_KEY_FILE=G:\AlteryxDataConnectorsTeam\OAuth project\PEMkey\rsa_key.p8;PRIV_KEY_FILE_PWD=__EncPwd1__;JWT_TIMEOUT=120

However - for canvasses which need to be productionized on Alteryx Server - it is critical to use dsn-less connection strings so that the canvasses can be deployed and run on any worker node without having to set up DSNs on every worker node.

A DSN-less connection string looks like this: 

ODBC:DRIVER={SnowflakeDSIIDriver};UID=UserName;pwd=Password;WAREHOUSE=compute_wh;SERVER=server.us-east-1.snowflakecomputing.com;SCHEMA=PUBLIC;DATABASE=NewTestDB;Staging=local;Method=user|||NEWTESTDB.PUBLIC.MYTESTTABLE

Please could you consider making an update to the help texts to provide and describe a DSN-free connection string as well as the DSN driven connections?

Many thanks

Sean

I usually use the comment tool by:

- dragging it on to the canvas and then

- Repositioning and expanding it to cover the tools I'd like to comment on.

What if I could select the tools I wanted to comment on and then use a key combination or double click so that the comment tool surrounds these tools for me. 

Note: Additional enhancement would be to anchor the comment to the tools selected but I see that this was dropped for consideration: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Anchoring-comment-boxes-to-tools/idi...

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.

As I previously mentioned here, I think that CReW (Alteryx) Runner could hugely benefit from additional enhancements and documentation that would be made for it, especially by adapting certain functionalities found in AlteryxEngineCmd.exe to AlteryxRunner.exe.

Enhancements

Encoding

As you might have already noticed while using the Alteryx Runner (also documented in this page), the AlteryxRunner.exe executable that is being used by Alteryx Runner does not produce the log file in UTF-16 (default Alteryx log output encoding) or UTF-8 encoding.

Therefore, if there exists a tool in your workflow that could produce a message that includes characters that are not supported by the limited Latin code pages (not including Extended Latin) or only supported by UTF-8 / UTF-16 code pages (same applies to workflow/analytic app name, input file names, output file names and directory names), you will notice that the output log is cut off exactly at that character, even if you use an installer such as this, which modifies the input read options of the Read Results section in the Run Command tool in the macro to read the log file produced by the AlteryxRunner.exe in a UTF-8 encoding.

This limits the way in which users can name their files, directories and workflow names, produce custom messages, or render the Runner tool unusable in certain languages.

As the output encoding settings are directly stored in the AlteryxRunner executable, this is unfortunately not an option that can be changed by the end user and requires direct modification to the AlteryxRunner.exe executable file directly from Alteryx development team.

While not being sure if AlteryxRunner.exe is capable of executing workflows or analytic apps that contain characters in their names or their directory names only supported by Extended Latin / UTF-8 / UTF-16 code pages, I would expect that support to be also added in case it's not already there.

Parameters (Command Line Arguments)

- While trying to find if AlteryxRunner.exe supports any command line arguments, I noticed that it is not possible to run an analytic app with custom values (or even if there is, there's no documentation for it, something I have written about below) via AlteryxRunner.exe, so it would be great to be able to run a YXWZ file with custom values (either using an XML file generated while the workflow is running or a "raw xml data stream with no quotation marks or line feeds" provided in the Runner tool as a new option (a text box for XML File Full Path and another one for Raw XML Data Stream toggled by two radio buttons in a check box group named This workflow is an analytic app) added to the interface of the Runner tool in addition to the workflow full path, already included as a text box interface tool). This would save the users from having to generate an analytic app from a template analytic app (at least in some cases where no advanced modifications to the workflow XML would be necessary) just to be able to change the app values stored in the app.

As already specified in the Encoding section above, I would also expect (at least) the XML file (even if not Raw XML Data Stream) to be able to be read in using UTF-8 encoding.

- I think that users should also be able to specify whether to run a workflow or analytic app using E1 or AMP (overriding the workflow settings), just like in the executable AlteryxEngineCmd.exe. In addition to this, if the AMP flag is passed, there should also be an option (or a 3rd option in addition to E1 and AMP) to pass an Engine Compatibility Mode flag.

- As a final addition, I believe it should also be possible to optionally specify the Memory Limit if desired using an additional flag.

I also think that the two last features should also be added to AlteryxEngineCmd.exe, which could benefit from additional enhancements including but not limited to these suggested in this idea post.

Documentation

Parameters

As you might have noticed while reading the two documentations Run Workflows by Command Line and Runner Tool, while there is an advanced documentation on the use of AlteryxEngineCmd.exe, only the use of the Runner Tool itself is documented and not AlteryxRunner.exe. Some of the enhancement requests here are directly a result of this situation (these features could already exist in AlteryxRunner.exe but we would not be aware of it if these were not documented). While such a documentation would not be needed by the Alteryx Designer users (as those arguments could be passed by the choices users make in the macro interface), it might help better understand the capabilities of the executable that makes it possible for a macro such as Alteryx Runner to exist in the first place.

hi team,

Currently the join tool doesn't have option to join the data irrespective of its case sensitivity. this causes issues while doing the analysis.

This tool is widely being taking as a replacement of Excel Vlookup formula (which is also case insensitive),so can we have the similar functionality for Join tool also?

We can have an option like a radio button or checkbox to select if we want to have case insensitivity while joining.

Thanks

In the dynamic input tool,

Where you “Read a List of Data Sources”, there should be a radio button below the “Action” field, to   

“INCLUDE FIELD OF DATA SOURCES”,

Then you’d have an output field with the isolated name from which the data was sourced. You wouldn't be required to "include full file path" then parse out the sheet the data came from. 

Hi is it possible to look at alteryx workflows being run when a file has been dropped into a file or somehting along those lines? I.e an external activty has taken place

Hi,

Due to our setup, we need to have the path defined as Environment variables, so they will point to different paths in case a user opens the WF locally or the server is running it.

The issue is that the path of dependency does not accept the windows defined variables:

Thank you!

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