Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

0 Likes

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 

0 Likes

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.

1.JPG

 

0 Likes

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! 

0 Likes

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.

0 Likes

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.

0 Likes

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.

0 Likes

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.

0 Likes

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.

0 Likes

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

0 Likes

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.

0 Likes

The Table tool does not allow renaming a field so that it breaks at a specific point.

Fields like "H.S. Dropouts Non-Hispanic" and "H.S. Dropouts Whites" need a forced break after Dropouts.

 

Now we get random breaks like

 

H.S. Dropouts

Non-Hispanic

 

H.S. Dropouts White

 

The Rename Field function in the Basic Table tool would be a great place to allow forced breaks.

 

Thanks!

Top Liked Authors