Alteryx Designer Desktop Ideas

This is a general request for uniform methods of connecting to data sources. The management of data connections is currently varied, and configurations/updates are completely different across connections. 

RSA Encrypt data within the workflow prior to sending to an external API, and decrypt response.

Enhancement request for the option to Encrypt ODBC credentials instead of just hashing them

It would be fantastic if there was auto-formatting for the Formula Tool (and even other tools, possibly).  The auto-formatting would function similar to Python PEP-8 style, either 4 spaces or an indent on each new line.  This could also be expanded to modify the existing autocomplete functionality of an IF statement with appropriate formatting.

Auto-Complete Current State Example:

IF c THEN t ELSE f ENDIF

Proposed Example:

IF c

    THEN t

    ELSE f

ENDIF

This would dramatically increase readability for lengthy nested IF statements or other complicated functions within the Formula tool.  It would also save a tremendous amount of time when we have to go back and format those functions later.

Dear Alteryx Solution Architects,

When we were implimenting analytics solution for goverment clinet in UAE, we came across a sititation in which, It requires validation of supporting documents for data quality issues.While working on this challenge we have arrived at the conclution that Alteryx has some limittaion in incorporating attchments to workflows.

I would like alteryx to come up with something to overcome this issue.

1. There should be some tool or technique to incorporate multiple attchments (I know  limitted feature of attchment is there in Alteryx but its not great)

2. There should be an option to visualize attachment in Results window if its possible, It will be grat value add.

Thanks

Ajin

Why we don't add the search feature in the Multi-row formula same as the formula tool?

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. 

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. 

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!

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! 

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.

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.

Hi Team,

With Sharepoint Tool 2.3.0 , We are unable to connect Sharepoint Lists with service Principal Authentication as it requires SharePoint - Application permission - Sites.Read.All and Sites.ReadWrite.All in Microsoft Azure App. However, as those permissions will gets access to all sites in respective Organization community, it is impossible for any company to provide as it leaks data security. Kindly provide any alternative or change in permsiions for Sharepoint Connectivity with thumbprint in Alteryx.

Regerence Case with Alteryx Support : Case #00619824

Thanks & Regards

Vamsi Krishna

We had a workflow where we needed to count business days. The standard solve of generating rows for each day between the dates wouldn't work as it would slow down the workflow too much.

Something that takes 5 seconds in Excel turned into a tremendous pain.

It would be really nice to have a built out tool where you can input the start date / end date (or what field they are tied to).

Which days of the week are considered business days and which days are not.

Which holidays should be excluded and available to add custom holidays.