Alteryx Designer Desktop Ideas

I have been very excited about Dark Mode.  Its arrival in 2023.1, whilst only in Beta and with plenty of work to do, means it's party time at my house.

It made me think we need a switch on the main Alteryx page to make it easy to flip between light and dark modes. 

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.

it would be beneficial to add the same action available in the message result window to be added in the brows tool for the distinct value.

like the copy options. 

Hi there,

When creating a database connection - Alteryx's default behaviour is to create an ODBC DSN-linked connection.

However DSN-linked connections do not work on a large server env - because this would require administrators to create these DSNs on every worker node and on every disaster recovery node, and update them all every time a canvas changes.

they are also not fully safe becuase part of the configuration of your canvas is held in the DSN - and so you cannot just rely on the code that's under version control.

So:

Could we add a feature to Alteryx Designer that allows a user to expand a DSN into a fully-declared conneciton string?

In other words - if the connection string is listed as 

- odbc:DSN=DSNSnowFlakeTest;UID=Username;PWD=__EncPwd1__|||NEWTESTDB.PUBLIC.MYTESTTABLE

Then offer the user the ability to expand this out by interrogating the ODBC Connection manager to instead have the fully described connection string like this:
odbc:DRIVER={SnowflakeDSIIDriver};UID=Username;pwd=__EncPwd1__;authenticator=Snowflake;WAREHOUSE=compute_wh;SERVER=xnb27844.us-east-1.snowflakecomputing.com;SCHEMA=PUBLIC;DATABASE=NewTestDB;Staging=local;Method=user

NOTE: This is exactly what users need to do manually today anyway to get to a DSN-less conneciton string - they have to craete a file DSN to figure out all the attributes (by opening it up in Notepad) and then paste these into the connection string manually.

Thanks all 

Sean

Creation of a gradient based background which correspond to where records drop throughout the workflow to identify issues or potential anomalies based on the initial dataflow. It could also certain tools flash when the record counts are 0 for example filter tools, joins, unions etc. 

Sometimes there are hundreds or even thousands of tools in very complex workflows so it would be helpful to track the data lineage. 

It would also be nice to have a tool that summarizes the number of records per each input and how many make their way in to the final tool/output or browse. 

The gradient can be adjusted based on the threshold and it could be added to connections in this case the red indicates there's been 0 records and the filter tool could flash or glow

Hello there

I'd like to suggest if we can add some metrics near the results area that would show the user the the Count of Unique, total count, SUM and etc of the selected records in the results area, to avoid copying selected records and pasting to excel to get these metrics

It's a small enhancement but could improve the user experience when investigating the data and trying to do some validation immediately rather than pasting to excel or adding other tools to get the answer.

Thanks 

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 would like to raise the idea of creating a feature that resolves the repetitive authentication problem between Alteryx and Snowflake

This is the same issue that was raised in the community forum on 11/6/18: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/ODBC-Connection-with-ExternalB...

Can a feature be added to store the authentication during the session and eliminate the popup browser?  The proposed solution eliminates the prompt for credentials; however, it does not eliminate the browser pops up. For the Input/Output function, this opens four new browser windows, one for each time Alteryx tests the connection. 

Hi!

Under User Settings, if you could add options to change what Alteryx shows in the tool configuration window. Currently, it shows Field, Type, Size, Rename, Description. I've been using Alteryx for almost 20 years, I've never used the Description field for anything. If Alteryx provided the option to remove it from the view for users who never use it, then the Rename field would no longer get truncated, which is a field I think is more widely utilized.

My team always run into the issue that two people running two workflow at the same but those workflow using the same excel flat file, then it clash into each other. 

I want Alteryx to develop a feature to allow read only capability to a input excel, that way two workflow use the same input file will not clash into each other, it's very good for running workflow in parallel, this way really increase our efficiency. 

I know this feature is not easy to achieve, we have had chat with Alteryx team before. 

I am opening to alternative solution to this problem. 

Thanks! 

As an Alteryx Designer user I would like the ability to write .hyper files to a subdirectory on Tableau Server to keep make my Tableau site easier to manage.

When a macro that is not "installed" is inserted to a workflow (from a folder), its dependency can also be modified (including the macro inputs, if there are any) from the Workflow Dependencies settings.

I would like to suggest that the macro tools and the relevant files have separate buttons for dependency configurations.

One use case for this would be when a user saves a workflow in a specific location after configuring the paths as All Relative and moving the workflow to an entirely different folder afterwards, making it difficult to find the original location of the macro used in the workflow, also introducing the chance of breaking the workflow when opened and saved with the undefined (question mark sign) macro tool if the underlying workflow XML is not examined by a text editor.

There are currently many encoding options (see also: Input Tool Has Limited Varieties of Code Pages) that are available for use with Alteryx Designer (https://help.alteryx.com/2018.2/CodePages.htm), however only a certain number of them can be directly accessed from the interface. Providing the user an option to enable all possible encoding options (from User Settings) for the applicable tools could eliminate the need for building an analytic app just to pass the output encoding parameter to i.e. the Input/Output/Run Command tools.

One case this could be useful is when there are file/folder names with non-English characters and a Run Command tool is used to execute an operation regarding moving something from/to the folder, where the only option is to use an OEM encoding to be able to correctly pass the file/folder name information, otherwise the characters are not read correctly by CMD.

Providing user the ability to paste a tool with one of the three options regarding connections:

- Paste with Incoming Connections,

- Paste with Outgoing Connections (where applicable),

- Paste with Both Connections (where applicable)

could make it easier to configure the workflows where many incoming and/or outgoing connections are necessary for a specific source or target tool (i.e. a certain mapping table joined to several data streams in the same workflow after being modified with a formula tool to match with a specific stream).

There are certain constants available for use with the tools supporting formula, WorkflowFileName being one of them. This makes it possible to i.e. capture the date information in the workflow name using RegEx to dynamically filter a field by this information (especially useful in Analytic Apps).

Based on this example, I think it would be useful to make it possible for the users to use the container's name as a constant (such as CurrentContainerName), especially when it is necessary to add a hardcoded value to several tools and update the values i.e. periodically or client-based. This would also make it easier to track the hardcoded values used in the tools.

Currently, Dynamic Select and Multi-Field Formula tools both have the option to select fields by type (like Numeric, String).

It is however not currently possible to select which fields will be selected by using a formula in the Multi-Field Formula tool.

Due to having to use at least two tools to select which fields I need and apply formula (optionally changing the data type),

- I first Dynamic Select the fields by the suffixes I have in the field name which specify the data type (like Name_String, Spends_Double)

- I then apply the Multi-Field Formula (at least trim the whitespaces from the fields due to working with CSV files containing fixed whitespace in fields) and change the data type if necessary,

- Finally, I Join Multiple the fields back using the RecordID field I previously added as a key.

This also changes the order of the data and there might be some scenarios where the user does not want the field order changed.

By embedding the Dynamic Select via Formula option to the Multi-Field Formula tool, it will become possible to select which fields will be subject to formula and (optionally) data type change in one tool as opposed to having to use many tools.

A new type of Browse tool which can dynamically be renamed through a field could be helpful for the cases where Analytic Apps display output results in Browse tabs. It could both help create the name of the Browse tab dynamically and create multiple Browse tabs automatically.

Being able to specify a name for the FileName field in the Input Tool configuration would be helpful for cases where a field named FileName is already present in the input data and has a different purpose than the newly added FileName field. Instead of having to use Field Info and other tools to rename the last field into something else (i.e. AYX_FileName), this would be an easier approach.