Alteryx Designer Desktop Ideas

The Unique tool is likely lighter than the Summarize tool and extremely useful to identify and remove duplicates, however unlike the JOIN tool where one can select which fields are included in the output, the unique tool will return all fields regardless.

It would be extremely useful if the UNIQUE tool also featured a list of fields to be included or not in the output for users to select from, because many times, all we are trying to extract is the list of unique values from a given column in the dataset and the other fields are not needed, neither do they make sense in this particular type of operation.

Thanks!

I've run into an issue where I'm using an Input (or dynamic input) tool inside a macro (attached) which is being updated via a File Browse tool. Being that I work at a large company with several data sources; so we use a lot of Shared (Gallery) Connections. The issue is that whenever I try to enter any sort of aliased connection (Gallery or otherwise), it reverts to the default connection I have in the Input or Dynamic Input tool. It does not act this way if I use a manually typed connection string.

Initially, I thought this was a bug; so I brought it to Support's attention. They told me that this was the default action of the tool. So I'm suggesting that the default action of Input and Dynamic Input tools be changed to allow being overridden by Aliased connections with File Browse and Action tools. The simplest way to implement this would probably be to translate the alias before pushing it to the macro.

It would be great to be able to use keyboard shortcuts to be able to switch between the different tools in the canvas, or use the keyboard shortcut to select different tools from the Tool Pallette (similar to Excel).

*unknown field is not available in the interface list box when it connected to a macro input.

i wish it has the "*unknown" field like in the select tool.
because it normal that the data flow has new columns and need the macro to take care the new columns. 

For tools that have 2 input or output anchors, the ability to right-click the tool and select "swap connections" to swap the connections coming out of the 2 input or output anchors. Let's say, with 5 connections coming out of the Unique's U Anchor and 3 coming out of the D anchor, we need to disconnect and reconnect connections 8 times in order to switch everything between U and D. Even if the tool has 1 connection per anchor, this would still be faster than removing + connecting each connection manually. Tool examples include Append data, Join, Unique, Macros with 2 inputs or outputs, etc.

as an analysis software. The result window plays a crucial role.
However, the numbers are not left-aligned, making it difficult to identify the number in the first grant.

and as most coding editor, monospace is recommend. it help to identify text length as well

Suggested Settings Adjustments:

1. Change of Font Type and Size: Include options for different fonts, including monospace.
2. Alignment: Provide options for left, right, and center alignment.

3. Option show whitespace

I would love to have the option to easily disable a section of the workflow while diverting around the disabled tools.

I know the Detour and Detour End tools exist, but I think this functionality could be improved.  My idea would be either/both of the following functions.

Break links between tools.  Think of a workflow as a circuit board and the connection paths between tools as parts of a circuit.  With every tool connected/enabled the full circuit is complete.  However, if there is a section of the workflow which is temporarily unneeded, it would be great to have the option to break the connection between tools and then reconnect at a later point to complete the circuit.  My idea would be to have the option on a line/path to break the connection temporarily (greying out the tools downstream) and enabling it further downstream.  It's similar to what the Detour and Detour End do, but without needing additional tools on the canvas

Alternatively, if you were to select the unneeded tools in the workflow and place them into a container, then disable it, it could skip those disabled tools without breaking the circuit.
[ tool ] ---- [ tool ] ---- [ tool ] ---- [ tool ] ---- [ tool ] ---- [ tool ]

Most tools do not result in record changes: Select Tool, Data Cleansing, Record ID, Formula, Auto Field, Multi Field/Row, etc.  It would be nice to be able to tell Alteryx which tools to display the Connection Progress; specifically the Record Counts.  It would reduce the clutter/noise and allow the Record Counts to only display for the tools that matter to the analyst/user.  Right now it displays for all tools regardless of whether the records changed or not.  My hope would be to tell Alteryx to only display the Record Counts for tools like: Input, Output, Filter, Join, Summarize, Crosstab, Unique, etc. and ignore all other tools.

When a workflow group is created/saved, could it by default always open the tabs in the order they were in when the Workflow Group was created?

As of now, the workflow tabs open at some undeterminable order and the user must take great care to switch from tab to tab in intended order. Sometime they are in the "correct" order, other times they randomly appear in different order. 

When running a job in the gallery, a file output has to be chosen every time, even if there is no other option. I propose that under "My Profile >> Workflow Defaults" users be able to choose a preferred default file format for outputs. If it is available then the gallery will automatically choose that, otherwise the user can pick. 

I work with lots of Excel files, and because they don't always consistent schema, I'm often changing the configuration.

The default Window frame/window for the "Options" panel in the Input data tool only shows 3-4 rows, plus title (the section in RED in the image below).  As I have large screens 

The panel size can be resized by dragging the line above the "Preview (first 100 records)".  However, once I move from this tool, if I return to the tool, it defaults back to 3-4 rows, plus title.

I would like to be able to set the default size of the Options panel/frame/window.

• This would improve my efficiency when setting up flows
• This would improve debugging - I would be able to see all my parameters at a glance

When using "Find and Replace", the content of the search term field ("Find") is cleared when switching between workflow windows. From my perspective, there's no reason for that. Why does Alteryx Designer decide that I don't want to search for the same term in another workflow?

Please change that behaviour that content in "Find", "Search Locations", and "Replace:" are preserved when switching between Designer windows.

Cache function is very useful when executing very long db request.

I'd like to see a checkbox option (in workflow runtime settings for example) to enable/disable automatic caching of first execution for all inputs tools.

I have a sales column in my dataset that includes both a dollar sign and a period (e.g., '$320,000.00'). When I use the data cleaning tool and select 'Remove unwanted characters' with the punctuation checkbox, it removes both the dollar sign and the period. However, I only want to remove the dollar sign. It would be great if @Alteryx could allow users to specify which character they want to remove after selecting the punctuation checkbox. Thanks!

Hello team,

It would be really nice if user interface tool can be set with a default set up that will flow into the connected tool. Currently it will always been blank as no data flow in.

There are ways to bypass it as run the automation in Open Debug, but then if you want to amend the the automation you need to go back to the original WF and then run it again with Open Debug.

Of course you can set a static data for these fields however then you must remove them before saving it to the Gallery, which might create future errors if you are forgetting to delete the static data.

So if I added a Select Date, it will be nice if it will be possible to select a data in that tool and that date will reflected in the WF. It is less an issue at the development part as normally at that stage these tools will not be set up, however when you need to upgrade existing WF or amend one due to changes, that's were it will be very handy and will save a lot of time.

Improve the user experience by enable search filtering options in browse tool result just as in the canvas. See attached pics.

I used to use a software before (LabVIEW) and it had the capability to exchange code via snippets or as part of png images. I think this will impact not only community, but also facilitate the code exchange

Include a tool specific configuration to allow for the ability to turn off annotations on that specific tool instead of the global setting to turn them all off.

This would especially be useful for the SORT tool.

I find myself wasting multiple clicks in order to eliminate the annotations every time I insert a sort tool into my process flow, since it is rare when I actually need to include an annotation.

When creating a series of workflows, it is most common to run each tab in order from left to right. When saving them as workflow group, the order is not preserved and cannot be controlled. Recommendation: Always open workflow group tabs in the order at time of last Workflow Group save.