Alteryx Designer Desktop Ideas

In a previous lifetime I spent a lot of time developing data processing workflows in Microsoft Access before moving into Alteryx as my primary data processing tool. Although Alteryx is, on the whole, vastly more feature rich than Access, Access has a couple of very simple features which Alteryx could integrate into the Browse tool to significantly improve its usability. In particular, I am suggesting the option to add a totals/summary row to the browse tool to calculate basic statistics for columns on demand. 

Attached is a screenshot of a totals row for a dummy table in Access. As you can see, a user can select from various summary statistics including sum, average, count etc. 

Almost every day I export data from the browse tool to Excel multiple times, simply to calculate column totals. A totals row in the browse tool would remove a major source of reasons for me to export to Excel and would significantly increase the browse tool's usefulness. 

It would be nice to have a visual cue for a detour tool's configuration. This is especially the case when testing with several detour tools in a workflow - see the cleanse.yxmc screenshot below. I added an annotation to one of the detour tools as a possible solution.

Any of these options that would save the additional click would be appreciated.

• Default annotation shows "Detour left" or "Detour right"
• Detour outgoing wire highlighted (mentioned in Detour dashing)
• Detour direction outgoing anchor that is NOT used is grayed out
• Detour direction outgoing wire that in NOT used is grayed out
• Detour tool has a left/right toggle
• Detour tool changes color when set to detour right

Personally, I prefer that the outgoing anchor and outgoing wire not in use be grayed out. But even the default annotation stating the direction would be helpful.

Does anyone else have a preference or other ideas on the visual cues?

Request: Google Drive Output Tool to be able to set the maximum records per file and create multiple files

For the regular Alteryx Output Tool, we're able to set maximum records per file. This is helpful in a variety of ways - we use it as part of a workflow where the output gets uploaded into SalesForce and we can only load 5,000 records at a time. I also use this to split up large csv files to be under Excel's ~1M line limit so my teammates without Alteryx can open their reports and not lose data. 

The Google Drive Output does not have this ability to split based on the number of records. If I use the RecordID Tool plus a Filter, it crashes Alteryx due to a Bug with RecordID + GDrive Output (it's currently in Accepted Defect stage)

It would be very helpful to have this same functionality that we can with the regular Output Tool

Having the ability to specify columns to be "coalesced" (essentially filled in automatically when records aren't present) across all inputs of the Join Multiple tool would be very useful, and save lots of tedious setup. In fact, I avoid that tool if possible, currently, because of the extra steps necessary in maintaining key column integrity after the join.

In the screenshot below "RecordID" is present in all 4 inputs. When they are joined together, however, not every record is present in all inputs, therefore each of the 4 "RecordID" columns has nulls. We then have to go through an extra step to find the first "non-null" record ID, and put that in a new column (or in the first "RecordID" column).

This could be simply fixed by adding a menu to specify columns that should be coalesced, or auto-filled from other inputs if it's missing in the first one.

The columns in the menu could be based on the first input, and then alteryx would look for columns with the same name in all other inputs and complete the logic below, for instance:

If isnull([RecordID]) then

      if isnull([Input_#2_RecordID]) then

           if isnull([Input_#3_RecordID]) then

                    [Input_#4_RecordID]

           else [Input_#3_RecordID] endif

     else [Input_#2_RecordID] endif

else [RecordID] endif

I am trying to add additional functionality to my existing workflow.

We have a common workflow pushed to the Alteryx server and there will be multiple people running this workflow.

Every time the workflow is run, the expectation is that an automatic email should be sent to the person who has triggered it(and won't be sent to multiple other people).

Currently, we have it set up using the Email tool but I do not see an option to dynamically update this “To” field to automatically use the email of a person running the workflow on the server.

I would like a new format option within the Designer function DateTimeFormat such that where a date is held in the database

e.g. 2023-01-01

DateTimeFormat([date],%o)

will return 1st not 1 or 01. 

Workarounds exist, but are fiddly given the different options....1st, 2nd, 3rd, 4th.....

I am suggesting an addition to the Auto Field Tool.  Create an option that allows only auto sizing of the fields and does not change the field type.  A check box that says Auto Size Only.  The tool would recognize any fields that can be resized based on their incoming data field type and will not change the data type.  The resizing function is very helpful to maximize workflow performance, but I currently do not use it much because it guesses wrong on the data types.  This causes problems also when data inputs change.  Whereas setting to auto size only, it can streamline the data but let the user be confident the data types would not change. 

Thank You

I have tried to search for this Idea but not located one that is same or similar. 

When searching for tools to use rather than having to click in the search bar at the top, it would be nice just to click on a blank part of the canvas and start typing for the tool that you need, then a suggest tool list pops up and you just click on the one you want to it appear. 

Thanks

Dynamic macros that fetch the current version at every run time vs storing a static copy of the macro with the workflow at publish time are challenging to pull off using shared drives. 

This suggestion is to store dynamic macros in the gallery and secure their use with collections.

Right click + "Insert After" and Right click + "Paste After" should behave the same. In the picture below I show the two cases. Currently, the "Insert After" option inserts a tool between the selected tool and the tools after it. The "Paste After" creates a new branch with the pasted tool. I think the "Paste After" should behave the same as the "Insert After": paste the tool on the existing branches. In case we want to create a new branch, we will paste the tool and connect a new branch to it.

Providing access to the Oracle Cloud for OTM would allow users to connect to the API's to deliver data sets from the Cloud and use it for workflow and other data management activities.

Quite often, I would love to be able to use Browse tools already while the workflow is still running, if that specific Browse tool has completed (green box around). This would help to debug and save a lot of time.

In this case, the lower Browse tool would be enabled already now.

I would like to raise the idea of creating a feature that resolves the repetitive authentication problem between Alteryx and Snowflake

This is the same issue that was raised in the community forum on 11/6/18: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/ODBC-Connection-with-ExternalB...

Can a feature be added to store the authentication during the session and eliminate the popup browser?  The proposed solution eliminates the prompt for credentials; however, it does not eliminate the browser pops up. For the Input/Output function, this opens four new browser windows, one for each time Alteryx tests the connection. 

Being able to specify a name for the FileName field in the Input Tool configuration would be helpful for cases where a field named FileName is already present in the input data and has a different purpose than the newly added FileName field. Instead of having to use Field Info and other tools to rename the last field into something else (i.e. AYX_FileName), this would be an easier approach.

The C API for e1 is included in the Designer Desktop installation. The new AMP engine must have a C API as well, but it has not been released publicly.

Let tool and SDK makers create custom tools that plug into the AMP engine by releasing the specifications of the AMP C API.

Sometimes when creating a workflow, or a chained application I create fields or parameters in a formula tool and need to be able to quickly copy and paste the entire formula output column into another formula tool across a different part of the workflow / entirely different workflow.

This most often happens when standardizing fields across different data streams. We have the ability to save expressions, but if you save too many that can quickly get messy. We also have the ability to copy and paste a formula within a formula output column...so why not extended the functionality slightly to copy/paste the entire formula output column?

In this proposed enhancement a user could right click on the 3 lines at the top left of the formula section and copy/cut a formula output column between formula tools:

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.

(1) The green banner saying that the workflow has finished running should stay until dismissed

(2) The indicator on the tabs showing which workflows had run should be colour coded (still running / completed without errors / completed with errors)

Thanks!

The Email tool does not send out e-mails after an error occurred in the workflow. Since this usually is a good thing, it sometimes would be helpful being able to send out e-mails also in case of errors.

In particular, I want to send out an e-mail with a detailed and formatted custom error message.

Thus, please add a check box "Also send mail in case of errors" which is off by default.

Side note: The Event "Send mail After Run With Errors" does not work for me because it is too inflexible. Just sending out the OutputLog is not helpful because the error message might be hidden after hundreds of rows.