Alteryx Designer Desktop Ideas

Currently the summarize tool field selector has one empty column on the left side that must be clicked on when selecting the fields, otherwise the 'Add' button does not activate.

I don't understand why the need for this empty column to be used when selecting the fields to aggregate/calculate.  Why can't we select the fields by clicking directly on the names of the fields instead?  Selecting fields this way is actually possible, but then the 'Add' button does not allow for the selection of the 'Group by' or aggregation method.

This creates confusion, especially for beginner users who might click on the field names, see them selected and be puzzled why the 'Add' button is not working.

Thanks!

sometimes we deal with hundreds of columns and it's hard to scroll and locate a specific one in the Data panel.

In the Metadata panel it's easier to locate the fields by scrolling vertically, however it would be even easier if we could click on the 'Name' column header and have that temporarily sorted so as to quickly locate a given column.  (This would be IDEA 1).

Additionally, but not necessarily dependent on IDEA1, if we could have the Record number of each of the fields in the metadata, also included alongside their respective names in the Data panel, that would make it for much easier location of particular fields in the Data panel, as users could look for a given field in the Metadata, find their 'order number' and then switch back to the Data panel and scroll directly to that number.

Additionally, column name search buttons could also be added to both Data/Metdata panels for a 'contains' like field name search.

Thanks!

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!

Dynamic Input should either:

(a) have the option of merging files with different field schemas

(b) Return a list of rejected filepaths

One of the problems I have with using Alteryx is the frequent need to input a bunch of files, but a few have an extra/missing field. The extra/missing field is often unimportant to me, but it means that the dynamic input doesn't work.

Work on allowing workflows to run successfully as the same way as the Designer.

1.  Allow use of DCM connections in Workflow.

2.  Allow use of AMP engine in connections.

3.  Expose the full execution log in the Scheduler Output Window.

4.  Refresh the screen when a Schedule is running frequently showing the same detail as in the Execution Log.  

5.  Allow a retry options for Scheduler.  Allow for number of retries when an Inteval between retries similar to SQL Server Job Agent or other schedulers.  

My request is to allow navigation to specific System settings without having to click through the entire process to get to the specific section of the settings you want to change.

I noticed the Workflow appears to validate the SQL when you click on the three dots next to the SQL statement in the Workflow Design.  My suggestion is to not run the validation until after the workflow is saved.

Hello,

As of today if you want to connect to Snowflake or MongoDB, you have to overwrite the default LUA Files, and that requires admin rights. I don't see the point of not including the good LUA files directly in the Alteryx packaging.

Best regards,

Simon

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).

The Join Tool tells you which records did not match (Left and Right) but it does not tell you what fields it did not match on.  This could quickly help the analyst determine which fields they need to look into to determine why there are unmatched records.  When joining on 5+ fields it becomes difficult to determine why some records did not match without manually inspecting each record which is time consuming.  The column title could be: Unmatched Field(s) and the values should be concatenated separated by commas.

When the name of a field is changed early in a workflow, all corresponding tools that use the renamed field should have the option to auto update the field name. This way I don't have to manully update the name of each effected field. 

Hi Team,

Please add an option of adding only Error in the Email Event. Currently we can send full Output log but cannot filter only errors from the output log. 

*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. 

It will be very useful if there will be tool that will be actually a template of a batch macro and one for iterative macro.

In this way the person can drop the tool to the canvas and connect it to his flow, so there is no need each time to build one.

Obviously if there is 1 macro input, a control parameter and macro output as default, then the person can adjust as needed, but at least there will be a ready template to go.

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.

for iterative macro, generally it had 2 anchors, one if it is for iterative, and it normally no output (whether got error or not)

it good to have option to remove this anchor when using it in workflow. 

so other user no need to identify which one is the True output and which one is just iteration.

additional, if this can apply to input anchor.
(i just built one macro where i don't need the start input, but the input need to be iterate input)

My proposal is to include a field that identifies the post language. Ive seen a few questions on spanish recently and I would like to help. But is difficult to fitler themy pr

Hello,

As of today, there are only few packages that are embedded with Alteryx Python tool. However :
1/Python becomes more and more popular. We will use this tool intensively in the next years
2/Python is based on existing packages. This is the force of the language
3/On Alteryx, adding a package is not that easy : you need to have admin rights and if you want your colleagues to open your workflow, it also means that he has to install it himself. In corporate environments, it means loosing time, several days on a project.

Personnaly, I would Polars, DuckDB.. that are way faster than Panda.

Hello,

There are several dozens of data sources... maybe it would be useful to have a search in it?

Best regards,

Simon