Alteryx Designer Desktop Ideas

Hello,

In cases where more than one field is being used in a join, the "Join (Tool ID) String fields can only be joined to other string fields" error message could be improved by indicating which field has a mismatch.

For example, if I'm joining Fields A, B, C, D... to fields Z, Y, X, W... in Join tool 24, and for some reason Field Z gets changed from String to Double, it'd be nice to see a message like:

"Join (24) (Field 1) String Fields can only be joined to other String fields"

or

"Join (24) String Fields can only be joined to other String fields (A)"

So that I know I need to go to a select tool and change the type of either A or Z.

Otherwise I look at the Join tool output and try to figure out which pair no longer has matching types, which can take a minute when dealing with a multiple-point join.

Thank you!

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 you change the system settings on Alteryx Designer, you get this annoying message :

Error: "Settings Validation Error" Alteryx Service failed to initialize, likely due to inconsistent RuntimeSettings.xml file: Unable to start Queue service, insufficient license

well, well, well...

I found the solution to this page https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Settings-Validation-Error-when-usin...

"Under Environment Setup Type, you must select "Designer Only" if only Designer is licensed"


Maybe instead of the current message, Alteryx can check the licence and help with a "you must choose Designer only option ath the beginning because only Designer is licensed".

Best regards,

Simon

The Dynamic Input tool fails when attempting input a set of Excel files with the following error:

Error: Dynamic Input (1): The file "Test2.xlsx|||<List of Sheet Names>" has a different schema than the 1st file in the set.

Each spreadsheet contains two tabs and all tabs contain the same columns.

The root cause of the schema error is that maximum sheet name length in the two spreadsheets is different.  The first spreadsheet uses "East" and "West" for sheet names.  The second spreadsheet uses "North" and "South" for sheet names.  The Dynamic Input tool uses the longest sheet name when defining the effective Schema.

Excel limits sheet name length to 31 characters. It would be helpful if the Dynamic Input tool used 31 as the minimum string length when defining a schema from Excel sheet names.

The Input Data tool exhibits similar behavior when using a wildcard in the filename and the "Import only the list of sheet names" option.

A batch macro can be used as a workaround.

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:

When I select multiple containers using control. I can see the configuration pane still on the left. If I adjust anything there it will only adjust the last selected container. I would like it to adjust all selected containers.

When I work I typically have 2 to 3 screens at my desk, or an oversized single screen. Being able to take the results window and float it on to my second monitor is great as it allows me to view more canvas and more data results in one setup. However the results window will not maximize or dock to my second window, would be great for it to have this Windows feature. 

I hope have a flexibility to adjust the print area workflow.

in the canvas.

it similar to excel print area, so we can adjust all the area easily.

for security. it may add function to check whether all tools is covered in print areas.

it is hard to cut the workflow to pieces when it is huge. 

Hello!
I have recently come across something within Alteryx that caught me by surprise. Currently when you are within the configuration window of a tool (in this example, the browse tool) and use ctrl + backspace (shortcut for deleting a previous full word), a blank character is instead added.

Please see example:

Currently in the Browse tool configuration

Go to change the Name of the tool - and naturally to clear it, use ctrl + backspace:

[] is added to the end. From what i can gather, this is a 'control character' , used when an application does not support ctrl+backspace.

Ctrl + Delete however, is supported.

I am proposing for this character/functionality to be supported. I believe the configuration window is the main - and potentially only, i couldn't find any other examples - place this is not supported.

Hope this makes sense!
TheOC

As @Jonathan-Sherman pointed out in his blog post we love that the toolbar is back in version 2020.2!

One way that this toolbar could be enhanced, however, is to allow the use of the save button while a workflow is running. The user can still click File->Save while the workflow is running, but it would be quicker to be able to use the button on the toolbar.

Adding "Lightning Bolt" connectors to the standard workflow tools to allow dynamic automation of the settings would be a game changer. I believe that this would enable us to create universally dynamic and adaptive workflows which could be used as drop in solutions for most datasets. This would turn the standard tools into a dynamic ones and dramatically reduce the tool count to accomplish dynamic tasks, and make complex workflows much easier to internalize. Making standard workflow tools more dynamic would allow us to easily dynamically incorporate conditional tests / values / fieldname selections / bypass / etc into tools like detour / filter / formula / unique / transpose / crosstab / summarize / Outputs / etc. I would also like to see the ability to utilize a bool field to bypass any given tool in a workflow. That way we could do things like conditionally bypass an entire formula tool which would dramatically simplify complex formula construction, turn on and off inputs / outputs, simplify error avoidance, etc.

In order to build complex dynamic conditional workflows with the current tool capabilities, most of us are forced to use custom macros (often a multitude of workflow specific ones as well), constantly add and remove formula created fields for message relay, and create complex multi-routings / tests / unions in a standard workflow with large numbers of tools and containers. This hides many of our tasks within short-term use fields / custom macros and it makes the rest of our workflows voluminous and less intuitive.

On the User Interface side, I recommend a simple approach. Next to the standard tool setting there should be a dynamic input option which allows you to select the source field in the lightning bolt connector. Next to that, there should be an icon that can be clicked on to pop up a short text description and a basic screen shot of data in the correct format for dynamic input. I would also like to see a check box at the bottom for manual tool "bypass" which can also be dynamically controlled. (This would especially be helpful on outputs, but it would also be helpful to allow formulas and filters to be kept in place for future use even when they should not currently be used) Turned off tools could be highlighted in a red background or something.

This would be useful for anyone creating dynamic and adaptive workflows, but it would especially expand Alteryx Designer's capability to attract more custom software developers like me.  It would dramatically reduce the need for a large number of complex workflow specific macros that clutter our systems. Users that find the traditional workflow tool approach easier for them could easily use the tools as normal by simply using the standard manual settings. Advanced users could simplify the creation of universally dynamic and self adaptive workflows.

The data view of any anchor is searchable. I want to search the metadata view please.

Alteryx can enhance the interactive dashboard capabilities by adding more visualization options, such as heat maps, treemaps, and network diagrams. This will allow users to create more informative and engaging dashboards, and enable them to better communicate insights to stakeholders. For example, Alteryx can add support for heat maps and treemaps, allowing users to visualize data density and distribution, or network diagrams, allowing users to visualize relationships between data points.

Alteryx should take a look at the BI platform so they can integrate the Dashboard Capability and remove the dependency of Visualization tool and become one stop solution

We would like some enhancements to the Salesforce connectors (input and output) to allow:

- Either the Batch or the Bulk API to be used. Batch API is much better for smaller jobs while the Bulk is better for larger jobs (larger numbers of records). It would be very useful to allow the selection of which API was used by the tool to use the most efficient API.

- The number of records per batch to be defined in the tool. I know this can be achieved using a batch macro but it would be far easier (from a user point of view) to be able to enter this value in the Salesforce connector and have it manage the batch size. We frequently have issues with the batch size being too large and Salesforce having errors (and records not updating).

The SQL compiler within the Input Tool places a space between operators causing a SQL syntax error.

Eg.

SELECT * FROM [DataSource] WHERE [Dimension] != 'abc'

Becomes

SELECT * FROM [DataSource] WHERE [Dimension] ! = 'abc'

The compiler should not add a space in this instance as it violates the syntax rules and triggers an error.

With all the talk of #TeamVertical and #TeamHorizonal an idea emerged for diagonal orientation. Now, it's a funny idea at first glance, but actually having the ability to control the general organization of a workflow could be very helpful. Imagine if there was a dot or arrow like in word that would enable us to tilt the canvas to fit our screens better. Like below, but leaving the text horizontal.

This solves the problem with the Left Join anchors moving to the top and instead allows anyone to rotate their workflow to what fits the case.

Thanks!!

#Team45Degrees

Issue:

Oftentimes when a workflow has an error, the error message is very long and is difficult to read in the results window. Currently, if you hover over the error message in the results window, the error message will popout but only for a couple seconds. Reading the error messages is a crucial step in troubleshooting the issue with a workflow, however, with the current experience it becomes very difficult to read the entire error message prior to the popout expiring.

Solution:

Simply double clicking any message, especially an error message, in the results window should have a permanent popout window presented to the user. This message window will allow the user to scroll down to read the entire message (if lengthy), popout the window further, minimize the window, and exit the window entirely. 

It would be great if I could see my save history in the debug menu. Currently it looks like this:

I'm not asking to be able to undo saves, I just want to be able to see where the workflow was saved within this menu so that I can easily see what actions have been taken since my last save. 

When we use search option it might be helpful to see also tool category where we can find searching tool.