Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

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

0 Likes

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. 

0 Likes

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.

0 Likes

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

0 Likes

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

 

SaadNaser_1-1684397519467.png

 

SaadNaser_0-1684397459573.png

 

 

0 Likes

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. 

0 Likes

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. 

 

SaadNaser_2-1684218754994.png

 

0 Likes

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. 

 

Input #Start of workflowDropped in WorkflowTotal in final dataflow
Database 11000080002000
Excel file 11000010009000
Download Tool 11000050005000
Total300001400016000

 

silverburst_1-1684176454243.png

 

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

 

 

 

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