Alteryx Designer Desktop Ideas

Hello all,


As you all know, you can use API with the Alteryx Download tool. However, this tool is not that easy to configure.
On the other hand, the API world use a lot tools such as Postman  or Bruno (an open source clone) which allows easy test, debug... I use it everytime I had to work on a rest API and then I try to translate it to the final tool (such as the Alteryx Download tool). Both tools offer "collection", a set of request, and also environment configuration. Here are some examples on the project I'm working on :

And you can even get some code



I would like to leverage those collections in my download tool configuration, that would be quite easier to use !

Best regards,

Simon

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.

Vanilla Alteryx Chained Apps can only progress linearly, which means developers could not let users skip few applications ( or ) reach the last app in the chain ( or ) let the user select which specific app to trigger based on the requirement.

 

This can be bypassed by using a render tool with output as PCXML and HTML link of the Application you can trying to divert to, which does not affect the existing workflow in any way.

By using the below set of tools on any workflow/chained app you can either branch the flow of apps ( or ) you can skip a few apps in the chain.

1. A excel or csv file which has the links of the apps -  the reason for keeping the hyperlinks in an external file is so that we can update the link if the server link changes/updates - refer Image 1
2. A filter tool to specify which application to move to ( can be changed using a radio button/drop down to app 2/3/4/5 etc.)
3. A text tool ( This is where the magic is ) - configure it to pick the server link from the incoming data from the filter tool as hyperlink and generate a output preview, as shown below - refer Image 2
4. Use a render tool as output and write to any PCXML file ex: "File.pcxml" - refer Image 3

Image 1 - Input Configuration with the flow that can be part of any existing application

 

Image 2 - Text Tool Configuration

Image 3 - Render tool Configuration

POC in action

• Let assume our 3rd application is located in www.alteryx.com - if the user selects 3rd app in the radio button

• Which would generate an Output Preview like below

Now If clicked on App 1, it would divert me to www.Alteryx.com

Keywords : Chained Applications, Chained Apps, Application Sequence, Skip Application Sequence, Branch Application Sequence, Application Order, Controlled Order, Trigger Next Application

Regards,

Maithreyan S

I find it extremely annoying having to individually disable/enable control containers in a workflow.  It would be nice if there was a way to select all control containers that I want to disable/enable and then be able to right click and do it quickly in one motion.  This would save me a lot of time when working with 10+ control containers.

Is it possible to add sort functionality to the Sample tool in Designer, similar to the 'Sample Based on Order' functionality in the Sample tool in Designer Cloud? This would cut down on the Sort + Sample tool combo in Designer!

Thanks!

Apologies if this has been suggested or exists. I often find myself using manual Excel files as a data source. These files frequently use cell formatting elements, such as cell color and text color, to convey important information. However, when these files are imported into Alteryx, this valuable formatting information is unfortunately lost.

To address this, a dedicated input tool that can read Excel files with separate fields for these formatting elements would be very helpful. This would be incredibly beneficial, especially when the data lacks other fields that relate to the coloring. Currently, I manage to achieve this using a Python tool, but integrating this as a built-in feature in Alteryx would undoubtedly be more efficient and user-friendly. This enhancement would not only simplify data preparation but also ensure the preservation of the full context of the original Excel file.

Whether it is a date range or a numeric range, I would like an official tool that can tell me where the gaps exist within the range.

The Find and Replace tool currently replaces text or appends fields by reviewing the first word in the string and evaluating if there is a matching value in the lookup replace table. If there is, it returns the replace text or it continues onto the next word in the string and repeats until a match is found or not found.

However the functionality should be that the entire string is evaluated and the first match in the replace lookup table is returned. This is similar to how the VLOOKUP formula functions in Excel. 

This makes workflows easier to maintain as the ordering of the lookup table can be amended to return the appropriate value. The ordering of the source string is far trickier to automate/change. 

I have seen workarounds where append fields is used to append all lookup values to each row and then find rows which contain the string and use a sample tool to return the first row, however this causes processing issues when working with large number of records/ lookup values.

The functionality should either be changed or at least a setting which can be toggled to switch between the two options.

Hello,

We would like to have further options in the test tool. As of today you can only test if records matches (equality test) , we would like to be able to test also when it is greater (>) and smaller (<).

Thanks !

Hi all 

Currently when you set your workflow to don't write outputs (disable all tools that write output) under runtime of the configuration of workflow- the render and green output tools become greyed out and do not write an output (as expected). 

However, this is not the case for connectors - for example, if you use the SharePoint output tool and click disable all tools that write output, it will not be greyed out and still write an output. Is it possible for these connectors to also not run when this is selected in the configuration? As otherwise currently, you have to add it to a container and disable it.

I love the ability to cache data. Sometimes, I've cached too far and I need to go back and alter a tool's configuration or make some other cache-destroying change. I then have to recache somewhere and sometimes the dataset is so huge it is a pain. I'd love to create multiple cache points as a safety or backup.

In conjunction with the "First N% of Rows" and "Group by column (optional)" features, an additional option that would be great to have would be to tell the tool to take at least 1 record per group. If I am telling the tool to take the first 3% of records and grouping by a field, but one of the groups only has 5 records, it won't return any records for that group, as 3% of 5 is .15, so the tool rounds that down to 0. If I could also choose an option for the tool to always round up, that would also be sufficient.

In the formula tool, you can generate uniform random values using the RAND() function.

I would like to have similar functionality to get normal random values by calling RANDN().

As a workaround, the values can be produced from a Python tool using 

numpy.random.randn()

Python documentation on numpy.random.randn.

The full script below produces 100 random normal values in a column called 'Normal_Rand'.

The zip file has both a direct workflow and macro solution to produce the random normal values.

Would like to have the ability to filter to searched fields. Having the ability to search for already known fields, and then selecting those fields, temporarily, and isolating them for view. While there is the selection of fields under "X of Y fields", this still requires manual clicks and could be tedious when there could be a large amount of fields.

While you could also use the SELECT tool, that would still require manually searching for the field and isolating it for viewing. This could possibly be an enhancement for the SELECT tool or it could be an enhancement for the "X of Y fields".

I'd like to suggest that Alteryx make annotations able to be hidden or visible by right clicking or hovering over a little highlighted corner similar to comments/notes in Excel.  Have a highlighted corner of tools when there is an annotation. When hovering over the colored corner, user is able to view the annotation otherwise it is hidden and out of the way of the tool box. 

when you bring in a comment box or tool container to your canvas it should come in with your preferred defaults for  fill colors, font color & size, etc.  I have specific color schemes to identify what my comments are for and one scheme that I use most often has font size, position & color, and background color that I have to set every time i bring in a new comment box.

 I LOVE working in Alteryx it because unlike excel you set a "macro" to perform repeating operations once and then ignore them to do your real work.  This concept should extend to the little things within Alteryx, i.e. settings for preferred defaults for comment boxes & tool containers. 

I know y'all are working on data lineage for some future offering and it is very much needed. For highest quality results, please make logs a primary source of lineage information. Being able to use dynamic naming with some tools and macros makes the names in the workflows simple foobar placeholders and do not reflect what actually happened. Today Connect doesn't use logs and leaves many lineage gaps because of this

Please move this to a more appropriate category if needed. This future feature work is not part of Connect.

Hello all,

My idea is very simple, and this is most likely I'm used to do. After highlighting the fields in the select tool, the next action is to click Options and to apply what to do. My idea is just after highlighting, right click on mouse button to go exactly on Options menu. Just a simple right click. I think this behavior is most likely comes from Microsoft, I'm used to select multiple lines or cells and with right click to do the next action. It's a simple, but powerful. What do you think?

Albert

The DateTime Tool currently displays incoming date-time data types in a dropdown menu and "If no date-time columns are present, the field appears dimmed and shows 'No Suitable Input Fields Available'". However, considering the complexity of date formats, it's beneficial to directly view the data type of incoming date-time data instead of relying solely on visual inspection. While Designer filters options based on string or date/time types automatically, having visibility into the data type ensures a more sound interpretation of the input for analysis purposes.