Alteryx Designer Desktop Ideas

The new functionality of filtering within the results window is very handy but quite limited for date fields where you can only Filter by 'Is Null' or 'Is Not Null'

 

Can you please expand the functionality so we have the same options as within the Filter tool.

A tiny quality of life fix to make auto-complete in formulas even better:

 

When you have writ a formula, like below, auto-complete helpfully suggest field names

 

and enable me to select the right field

 

If I need to change this field again, auto-complete again pops up the possible fields

However upon selecting the new field, I get this mess where part of the old field is intertwined with the new field, leaving an invalid fomula without manual correction

notice the 2 x Business

 

Would it be possible for the program to remove the entire old field, before inserting the new field?

 

In the current expression editor, XOR(exclusive logical sum) is not supported as an operator while AND & OR already exist, so I'd like to request to add XOR to an operator in expression editor.

 

Without XOR operator, when we want to use XOR conditional expression, it is like below expression; it looks a bit complicated so it's hard to tell condition is XOR at once.

As a workaround, I defined custom function XOR by myself, but this should not be permanent solution since when sharing workflow to others it doesn't make sense unless they also have custom function XML file in their computers as well.

 

I believe addition of XOR would help to have much readable code for tools with expression editor(e.g. formula, filter, etc).

There are a number of tools that lose their selections when copied and pasted. Here are the ones I quickly found so far: 

-Multi Row Formula (Group By)

-Running Total (Group By)

-Transpose (Key Fields and Data Fields)

-Unique (Unique Fields)

-Concatenate (Group Data by these values and method for aggregating values)

 

It would be really great if they could keep their selections when pasted. This would be similar to the Join, Multi Field Formulas, or Sort tools which keep their settings but let you know if a field is missing. Thanks!

Lately I've used the 'Add Prefix to Field Names' option in the Select tool. It works great, however when you click the button to add a prefix, the new window pops up and the focus is on the checkbox. I think when this box pops up, the focus should be in the text box so the user can start typing right after they click the button. This is the same case for the Add Suffix option, too.

 

 

Hi there team,

 

When using the sort tool - it's impossible to really develop much speed and muscle memory because you're always having to switch between keyboard and mouse.

Can we please add to the sort tool to make this a hyper-quick experience for the user?

 

Current Experience:

 

 

I currently have the select tool selected want to add a sort after this to sort on 3 columns:

• I hit ctrl-shift-f to go to the advanced find
• Then type "sort"
• Then I switch from keyboard to mouse, and drag this sort tool on to my canvas
• I then want to start configuring this tool - so I need to then need to mouse across to the configuration box
• hit the drop-down box with the mouse to get focus on that row in the sorter
• type or mouse select the right field - this is especially painful if there are a lot of fields
• then mouse again to get to the ascending / descending sort option
• then repeat for all other fields

 

Proposed alternative path:

I want to add a sort tool immediately after the currently selected tool:

• ctrl-alt-s (my user-defined shortcut for the short tool)
• control-space to enter config mode which defaults to configuring sort order for first field
• start typing the field-name - this does a look-ahead search like google.com does
• when I find the field I want, hit tab and have the same experience with asc / desc
• hit tab again, go to sort row 2 - repeat
• NEVER have to touch the mouse

As we all know - when you develop muscle memory for an IDE - not only does this remove the barrier between thought and delivery - but it also makes it more sticky as a platform (you don't want to change products because you are used to the keyboard shortcuts on this one) - so not only would this improve user speed - it would also make sense from an economic perspective for retaining customers through stickiness.

 

cc: @Hollingsworth 

 

 

Dear Alteryx Team, 

 

please put an option marker /button in the formula tool to ask if the newly added column should be placed at the beginning as first column or at the end (as it is now- this could be a default setting). 

 

The problem is that with a lot of fields it is quite time consuming to drag and drop the newly added column from the end of the field array to the beginning. Depending on where you want to reallocate the column you might want to start from the front or from the back to drag and drop (right click holded) the column in order to reorder it. 

 

Mostly I would like to start from the front, I noticed. 

 

 

Thank you

 

 

 

I would love to see Alteryx add an indicator whenever a number being displayed is being truncated. For example, this picture is currently confusing:

 

 

 

The displayed numbers should all be equal according to their displayed value, but in reality a different number is being stored in the background. I would propose something like this:

1) Any number that is being truncated when displayed would have that red triangle in the upper right corner. This already happens when a formula tool result is truncated, but I would like for it to be displayed on all data.

2) Clicking on the cell would show the actual value, not the truncated value. This would be great when debugging.

 

I understand that numbers are more complex than meets the eye, and I think that changes like this would help alleviate some of the mystery (like why 2 of my numbers above aren't equal).

I often use the formula component to change the data type of a column, e.g. convert a string to a datetime.  What I normally have to do is create a new column and then use a select to drop the old column.  I would like to be able to do all of this in 1 operation, i.e. make the greyed out 'Data Type' active so I could choose to convert to data type datetime.  Would also be useful to rename the existing column in this operation too.

 

*Simply a QoL suggestion & apologies in advance if this isn't possible within the constraints of Alteryx*

 

As it stands right now, if statements require an 'else' condition 100% of the time.

 

 

However, there are many times where users just need to flag a certain condition and don't care about what the other outcome is, often just needing this to filter or sense check etc. Therefore the idea is simple: allow users to immediately ENDIF a statement after a single if condition, much like we can do in Tableau. When a statement is written in this way, the missing 'else' just defaults to nulling the value if the single condition isn't met:

 

 

Sorry if this has been previously suggested but haven't spotted anything from a look around the ideas area.

 

Cheers!

The download tool is currently a general purpose tool that is used for many different things; from downloading FTP files; to scraping websites.

 

However, as a general purpose tool, it cannot serve the specific need of scraping a website without doing a huge amount of work to get there.    What makes Alteryx great is the fact that it drops the barrier so that regular folks can do some really powerful analytics, but the web scraping capabilities are not yet there and still require a tremendous amount of technical skill to accomplish.

 

I'll go through this from top to bottom:

• Split capability: The download tool tries to be too many things to too many people.   Break it up into its component parts - one for FTP; one for Web Scraping; etc - with deep speciality.   You can still keep the download tool as the super-user version but by creating the specialized tools, we can make this much more user-friendly
• Connection:  For enterprise users, where there's a locked down connectivity to the internet - there is no way to scrape web content without using CURL.   So we need the ability to connect to websites in a way that does not require curl or complex connectivity setups for users to navigate through web proxy settings.
  
  • Alteryx could auto-detect settings by allowing the user to point to the site within a controlled browse form like Excel does
• Parameters: Many websites explicitly support named parameters (using ? notation) - it would be very useful to allow the user to link to these parameters explicitly without having to do complex string conjugations or %20 scrubbing to get of non-URL friendly characters
• Content: Alteryx presents the user with no native ability to process HTML, so all scrubbing to pull out a specific field has to be done through complex read-through of the underlying source of the website (delivered in "DownloadedData") followed by guessing on patterns on how the site does tables or spans etc, followed by complex regex.    
  • Instead, we could present the user with a view of the web-page and ask them to select the elements that they want
  • This would serve the dual purpose of making this user-friendly for regular folks and abstract away the technicalities; but also would allow the download tool to eliminate all the other bits of the page that are not wanted like scripts; interstitial adverts; images; headers & footers etc.
• Improved post / parse capability:   Sometimes the purpose of a URL is to generate a download (like the Google Finance API) - again, would be good to observe the user using the target site to record & interpret what they are looking for and what they get (e.g. the file from google)
• HTML & XML types: why not an explicit type in Alteryx for web content?
• Finally - HTML aware.   The browse tools are not currently HTML aware, so all the useful formatting to be able to see what's going on, expand nodes, find patterns etc - all this has to be copied out of Alteryx into Notepad ++.   Given the ubiquity of HTML parsers and pretty printers and editors, it should be reasonably easy to get a cheap component that can provide this capability

 

Ok the time has come to expand functionality in the record ID tool. I would like the ability to restart the counter based on a field (e.g zip code). You can do it quickly in Tableau (see image) so why not have this functionality readily available in Alteryx? Sure, you can already do it in Alteryx - the long way - with the generate rows tool, look at previous/active row with certain condition and do +1 or something like that.

Having a simple restart counter in Record ID tool just makes sense. It's intuitve to have it there, and it's easier to use than generate rows tool. IMHO also easy to develop by Alteryx and +1 for Alteryx in gartner magic quadrant! 

 

 

 

Idea:  I need a function that given two dates, will return the number of business days between them. I need to know the # of business days between when a sales order is placed and when it ships to the customer. I'm in the US, so I would want to not count Saturdays, Sundays, and US Holidays, but I can foresee others wanting the option to change to other calendars or ignore holidays.

 

There are a couple of posts on this in the community, but everything I've found so far is too laborious to implement or not robust.

 

Hi,

Instead of having multiple filters to create mutliples new branches for downstream analysis, Alteryx should have one filter with multiples ouputs ports. Each filter would is own statement. 

This would reduce the numbers of filters in a canvas.

I have need to Unique my data on all fields. However, I do not know all the fields that will be in my data because of a Dynamic Select tool (or in some cases a Cross Tab tool). The Unique tool defaults to having any new fields be unchecked in its configuration. Without finding some work around, I will be unable to schedule this workflow or turn it into an app for use on the Gallery without risking duplication caused by the Unique tool that fails to capture new/different fields that may come through the data.

 

To solve this problem and be consistent with other tools in Alteryx, the following features need to be added to the Unique tool:

1. The user should be able to check a "Dynamic or Unknown Fields" option that will enable Alteryx to include any new fields in the data as part of the Unique (or any fields that have their names changed).
2. If a field that was checked in the Unique tool before no longer exists, it should appear yellow (like the missing fields in the Select tool) and produce a warning in the Results window. The option to "Forget all missing fields" will also need to be added.

In the 'Select' tool, you have the ability to output the select configuration.  At this time that configuration file doesn't include the information (which you do in the check box of the select tool) on if it is a field that is output. Not a big deal if there are only a couple fields, but quickly becomes an inconvenience if there are a lot of fields and you have to compare going down the list to make sure you're accurately identifying which fields from the original select tool, are actually output.  That info should be part of the .yxft file that's output for the config file. 

It would be a handy feature if it were possible to choose a data type for an input tool to read the data in as. For example, if a dataset has multiple fields with different data types, it would be handy to be able to make the Input Tool read and output them all as a string, if needed. This would also make a handy tool, a sort of blanket data conversion to convert all fields to the specified type.

There is no straightforward way to know if a string is lower, upper or title case. A workaround such as Contains function or REGEX ones has to be used.

 

The creation of the following functions would make it easier :

     - IsTitleCase(String) : tests if a string is in TitleCase

     - IsUpperCase(String) : tests if a string is in UpperCase

     - IsLowerCase(String) : tests if a string is in LowerCase

They would all return a boolean and be in the Test category.

I love color coding in formula (and hope one day we have the same for query tool ^^ ). However, it appears italics is perturbing.

Here the issue I have with Pipes on the second line :

This is particulary hard to to distinguish with slash /. 😞