Alteryx Designer Desktop Ideas

When using certain tools, particularly market place tools like the SharePoint input/ output etc. it would be helpful to have a quick way to find out which version is being used in a workflow. Something along the lines of an option when you right click the tool, that displays the current version would be ideal. 

This would be helpful in several cases but primarily when handing over workflows. There are cases when I have multiple versions of the same tool installed so that I don't have any issues inheriting workflows. This does however, make things confusing when handing workflows back. Tool Version Labelling would solve this problem.

Regards - Pilsner

Anytime you create a formula in the formula tool, you get a data preview based on the values in the first row of data.  However, if you have a complex "IF c THEN t ELSEIF c2 THEN t2 ELSE f ENDIF" formula then the data combination that gives a TRUE result will likely exist on another row.  Therefore, you need to run the workflow, or place a filter tool upstream to isolate the specific row, to test if the formula result is correct.  

It would be easier if you could select the Input anchor of the Formula tool, then filter the data in the results window to isolate the row in questions, then the data preview would be based on that filtered data set.  I believe this would save a lot of time in the workflow development phase.

So many tools especially Spatial Tools require a browse tool to be useful. Why not automatically add a browse tool when you add a spatial tool it could even be an option you could select. "Yes Auto Add browse" or not. Even during spatial trainings the instructions keep saying add spatial tool now add a browse tool and hit run. we can always toggle of the browse tools or delete them once we are finished developing. i know there are keyboard shortcuts and i use those but i think this would be a very simple addition.  

Hello,

I really would appreciate the ability to store our templates in a Teams/Sharepoint (or whatever exists) folder. However, it doesn't work today :

Best regards,

Simon

I want to have the ability to share workflows with non-Alteryx users so they can see what steps were followed within my workflows in order to create the output(s). Without a read-only viewer Alteryx users are forced to screenshot and write out the steps they followed in the workflows to document what they did which can be extremely laborious and time consuming when workflows get into the 50+ tool range. A read-only viewer would save Alteryx users time and give non-Alteryx users a sneak peak into how Alteryx works as well. It could peak the interest of non-Alteryx users to learn more about Alteryx and possibly convince them to download a trial and eventually purchase a license, so it could improve documentation methods as well as be an asset for marketing to non-Alteryx users. For reference, Tableau offers a similar solution called Reader.

when using switch formula as a more elegant way then if else

't' is not working in switch while it working in if then.

so i recommend to have a formula call True() and False() as excel to solve this issue. 

At a minimum one checkbox added to the Summarize tool, which would trigger the output to be automatically sorted in the order in which the fields were aggregated.

On a more elaborate level, it could allow the user to select a different sort order than that in which the fields were aggregated.

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. 

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