Alteryx Designer Desktop Ideas

In response to my question here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Singin-Error-to-Tableau-server-using-P...

 

The Publish to Tableau Server does not support SAML/SSO. I would like this feature to be added to this tool as it will make our business process more efficient.

 

Thank you.

It would be great if the "fields from connected tool" option pulled fresh data at runtime when used in the gallery and pulling data from non-interface tools. The external source option doesn't have many settings (i.e. I can just point to one file), whereas the possibilities would be endless if I could use the full suite of tools to create a data set, at runtime, to pass to the list box/dropdown.

Similar to the Select tool's Unknown Field Checkbox, I figured it would be useful for the Data Cleansing tool to have this functionality as well in order to avoid a scenario where after a cross-tab you have a new numeric field, one of which has a Null value, so you can't total up multiple fields because the Null value will prevent the addition from happening. If the Unknown Field box were checked off in the Data Cleansing tool then this problem would be avoided.

Similar to how the Tool Container Defaults can be set on the Document tab of User Settings, it would be nice to be able to set the Comment box defaults here as well. I find that I change the Colour & Size every time I add a comment, and would appreciate if this could just be set as a default.

This functionality won't be mission-critical to anyone, I'm sure, but a lot of IDEs and upgraded text editors (lookin' at you Notepad++) have the ability to customize the colors of text, the background, and other various tabs/objects that may appear on the screen. I understand that this is more important for code-based systems where the coloring improves readability so much, but I thought it might be a neat feature. I think leaving the tool colors standardized is a good idea though, just the canvas and outerlying windows. It could include the colors for the formula syntax highlighting too?

 

The icing on the cake would be the ability to save and share your settings or create a repository for them in the public gallery or something.

In the Browse window:

1. Can we add a Find function like in excel? (e.g. find record_ID==4 or name =='foobar')
2. Can we click the column name so it sorts on that field?
3. In 9.0 when I click 'Cell Viewer' in Browse window,  'Show Whitespace' seems to be turn on by default. Can we turn it off like in 8.6?
4. When I click the 'Fields' button to toggle fields on/off, it would be great to add a Sort function here too, so fields can be sorted a-z by fieldname (like in the Select tool).

Thanks!

Idea:

I know cache-related ideas have already been posted (cache macros; cache tools), but I would like it if cache were simply built into every tool, similar to the way it is on the Input Tool.

 

Reasoning:

During workflow development, I'll run the workflow repeatedly, and especially if there is sizeable data or an R tool involved, it can get really time consuming.

 

Implementation ideas:

I can see where managing cache could be tricky: in a large workflow processing a lot of data, nobody would want to maintain dozens of copies of that data.  But there may be ways of just monitoring changes to the workflow in order to know if something needs to be rebuilt or not: e.g. suppose I cache a Predictive Tool, and then make no changes to any tool preceeding it in the workflow... the next time I run, the engine should be able to look at "cache flags" and/or "modified tool flags" to determine where it should start: basically start at the "furthest along cache" that has no "modified tools" preceeding it.

 

 

Anyway, just a thought.

 

While Alteryx does have a UNION set operator, it only currently has an Inclusive Union

 

the other two set operators, Intersect & Except, and an exclusive Union would be helpful if they can be added.

• Exclusive Union: Union two sets, but eliminate full duplicates (across the full row)
  • Although this can be done with a union, followed by a distinct - you have to do a distinct across all columns
  • This is the difference between SQL "Union" and SQL "Union ALL"
• Intersect:  This is the intersection of two sets - where the full row (all columns) are identical
• Except: This is where the row in 1 set is not in the other.

 

Intersect is particularly helpful for operations like looking at multi-column reference data to see if any fields at all have changed (like a slowly changing dimension).

 

CC: @rijuthav @jithinmony @HengHe @RajK @ydmuley @revathi @Deeksha @MPistone @Ari_Fuller @Arianna_Fuller @JoshKushner @samnelson @avinashbonu @Sunder_Sriram @Rahul_Thakur @Rahul_Singh

Is there a way we can turn on and off any tools in the workflow. This way we can run the tool and when a certain tool is marked off it is not executed. This way we can test the workflow and check different output without deleting the tools existing on the workflow, we can just turn then on or off.

Hi! I noticed that there is currently no way to use the debug function when working on an analytic app workflow that contains control containers. I'm running 2024.1 and I use the debug feature in my workflows that currently do not have control containers for me to troubleshoot when data changes in a dynamic workflow. Currently, when running in test mode, I have no way to review the data step by step in the flow when selected dynamically through the interface apps. I can only view the final output and make tweaks. 

Not sure I'd call this a user setting, but I couldn't figure out the right heading this belongs to. 

 

When opening files, there are often times a couple of files at that aren't run on any kind of schedule or set time frame but you come back to when you need to run them.  

 

There should be a way to set "FAVORITES" for a handful of files that you find yourself referring to on a repeated basis, but too far back to be on the 'recents' list because you open too many other files. 

 

Hello all,

 

I'm currently learning Pythin language and there is this cool feature : you can multiply a string

 

 

Pretty cool, no? I would like the same syntax to work for Tableau.

 

Best regards,

 

Simon

Can a function be added to the Text-to-Column tool that allows selecting "split on entire entry" or "split on entry-as-a-whole" for the delimiters field?

 

Background:

Currently if we type  vs.  in the delimiters field, it'll look for each character separately including spaces.

 

The recommendation in the tool help is to use RegEx for splitting on whole words, but for some, RegEx is quite intimidating and adding this function would be a big help for new users.

 

Proposed Change:

2 Radio Buttons added to the Text-to-Column tool

1. Split by Each Entry
   1. Current functionality
   2. Should be default
   3. Splits on every letter, space, punctuation, etc. separately
2. Split by Entire Entry
   1. Allow splitting by using entire entry in the field
   2. Still includes spaces, letters, and punctuation, but now sees as "whole-word"

 

Example of function:

1. Radio button set to "split by entire entry"
2. Delimiter field has:   vs. 
3. Tool sees  ______ vs. ______  in a column in the data
4. Tool splits ______  and  ______ into new columns leaving out the entire vs. including the spaces entered around it

 

Thank you!

While the result window allows sorting and filtering, every time the user switches to another tool within the same run, the configuration is lost. It would be good if there was a 'Retain" button so that the user does not have to keep setting this each time the tool is switched or when the canvas is retriggered.

Hello!

As many of you know, i'm a big fan of Alteryx Apps. However, one of the most painful parts of Alteryx Apps is moving around elements in the Interface Designer. Currently when you have many elements in your interface designer:

And add a new element from the dropdown, or through a new tool:

 

It is added to the bottom of the interface. Moving it to the top is currently done with the arrows, however this is very slow, especially when you have many interface elements:

Currently (with 9 radio buttons) it takes 18 clicks (each taking a couple of seconds due to delay between movements) to move it, because it moves between each step:

It would be fantastic if we could drag and drop the elements of the interface to where we like, for speed of development and ease of use.

 

Thanks,

TheOC 

The default (option 7 below) often causes problems with imports and is difficult for new users to find and I see no reason for the option to be so low. Can it be set higher to aid parsing of larger text fields e.g. parsing HTML files as text.

 

I use the field name auto-complete feature whenever I can. One issue with it, however, is when there are parentheses in a field name. After auto-completing the field name, Alteryx highlights a portion of the field name after the first parenthesis. This is not ideal as I typically expect the cursor to be at the end of the field name so I may continue to type. In this scenario, unfortunately, I would begin to type over my field name and the expression gets messed up. 

 

For example, as shown below, I begin to type "st" and then hit the tab button to complete the field name in my expression.

 

In this case, because my field name has parentheses in it, however, some of the field name remains highlighted and the cursor does not go to the end of the right bracket, as one would expect.

If I were to continue typing at this point, the highlighted portion of the expression would get erased and replaced. 

 

Field names that do not contain parentheses continue to function correctly as shown below. 

 

 

 

 

 

Similar to the thoughts in this idea, it would be great if the parenthesis matching functionality could be added to the formula tool as well.

Instead of adding a tool container to the canvas, then moving my input tool into that - it would be nice if I could just click a box for 'Disable' in the input tool properties.  This would speed up things if I'm trying to test inputs one at a time; or need to disable just one specific output while I test another data stream in my workflow.