Alteryx Designer

Share your Designer product ideas - we're listening!
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the like in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

When entering a number of column names in the RegEx parse mode - please can you allow either Enter or down-arrow to move down to the next cell (standard windows convention)?

 

Currently Enter just exists the edit mode; and down-arrow does nothing.

 

Annotation 2020-07-06 210535.png

 

cc: @Hollingsworth 

Sometimes, as a sanity check, I would like to be able to model only the mean of my data set, i.e. I would like to use a predictive tool with no predictors included. The result would be a model with only an intercept, and this value would be the mean of the target variable. This would not be an important feature for final models, of course, but when starting to look at a data set and build up a model, it can be useful to first ensure the model is producing the expected output in the simplest case. 

 

Note, this can be achieved when just one predictor is included, but it takes some math (see below), so it would be nice to be able to have this as a built-in option.

 

Kenda_0-1594148666258.png

 

When you use Create Points tool - you then almost always need to use a Select tool to rename that point.

Can we please add a single text field to the Create Points tool - which would then allow us to create and name a point in one step?

 

Annotation 2020-07-04 103732.png

Could we please change the Interactive Chart tool, to:

  • recognize when upstream types have changed and reconfigure (in the case of numerical types marked as string)
  • For line charts - sort the values in order of the X value

 

Sample Flow - derivation of challenge 201:

IMG0-Flow.png

 

Issue 1:

- The first interactive chart on this flow has no sorting at all performed by the charting tool - this may be due to the fact that the X & Y axes are in string fields.   Generally line charts would attempt to sort both the axes and the values (where the values should order according to the X axis).   Please can you add a default sort anyway?

 

Img1-NoSorting.png

 

Issue 2:

- If you then change the data types on these fields to be numeric - the charting tool still does not sort them until you reconfigure the tool manually
- REquest: please can you get the tool to remember the data types, so that it can prompt you; or even better just reconfigure?

(image looks identical after retyping the fields)

Img1-NoSorting.png

 

 

Issue 3:

- When you do a manual reconfigure of the tool after changing the types - the axes are sorted, but the values are not - so you end up with a chart that crosses back and forth.   Generally line charts are ordered in the order of the X Axis for the values

- Request: Please sort values on the line chart automatically in order of the X value?

 

Img2-AxesSortedButNotValues.png

 

NOTE: Finally got the outcome needed by forcing the sort before the interactive chart tool

 

 

Img3-ExpectedOutcomeAfterSorting.png

Currently, Input tool, Flat File format, only support String and V_String field data type.

Note: UTF-8 is a supported character set.

 

I would like to request W_String and VW_String be supported, given UTF-8 is a supported character set.

 

There is a workaround to do this, meaning Alteryx already does this, albeit through CSV input format, using a non-existent field separate, e.g., | is what I used, or in this link, the NUL or \0 character.

 

https://community.alteryx.com/t5/Alteryx-Designer/flat-file-import-with-unicode/m-p/537001#M115000

The select tool does a great job at flagging up when something has changed from its original state. However why does this not happen with the checkboxes to keep or remove a field? It would be much faster and easier to read if we could have the same color conditional formatting as the rest.

 

Jonathan-Sherman_0-1594041131247.png

 

This has probably been mentioned before, but in case it hasn't....

 

The dynamic input tool is useful for bringing in multiple files / tabs, but quickly stops being fit for purpose if schemas / fields differ even slightly. The common solution is to then use a dynamic input tool inside a batch macro and set this macro to 'Auto Configure by Name', so that it waits for all files to be run and then can output knowing what it has received. 

 

It's a pain to create these batch macros for relatively straightforward and regular processes - would it be possible to have this 'Auto Configure by Name' as an option directly in the dynamic input tool, relieving the need for a batch macro? 

 

Thanks,

 

Andy 

 

 

I would like to see a "tool" that you can use as an off-screen connection (pair) between data anchors.  Currently, you can create "wireless" connections between anchors.  This essentially helps, but isn't friendly if you add/modify contents between points A & B.  It also doesn't aid in documentation of the workflow.

 

If by comparison, I put a connection tool on at point A it would be great to see it annotate itself with the incoming Tool ID and when I connect it to the paired point B, it would similarly explain the incoming tool id onto that point too.

 

I currently use a SELECT tool to explain visually that this data is being used elsewhere.  I create a wireless connection to the receiving data (could be multiple) and document the source.  The performance of the workflow may be slowed by these select tools.

 

I'm very open to other ideas or reformats of this proposal.  I don't think that it is going to change the world, but it would help me with my OCD.

 

Cheers,


Mark

This has probably been mentioned before, but in case it hasn't....

 

Right now, if the dynamic input tool skips a file (which it often does!) it just appears as a warning and continues processing. Whilst this is still useful to continue processing, could it be built as an option in the tool to select a 'error if files are skipped'? 

 

Right now it is either easy to miss this is happening, or in production / on server you may want this process to be stopped.

 

Thanks,

 

Andy 

 

 

I'm really liking the new assisted modelling capabilities released in 2020.2, but it should not error if the data contains: spatial, blob, date, datetime, or datetime types.

 

This is essentially telling the user to add an extra step of adding a select before the assisted modelling tool and then a join after the models. I think the tool should be able to read in and through these field types (especially dates) and just not use them in any of the modelling.

 

An even better enhancement would be to transform date as part of the assisted modelling into something usable for the modelling (season, month, day of week, etc.)

 

joe_lipski_0-1593515364178.png

 

The crosstab tool replaces any non-alphanumeric characters with underscores in column names. It would be helpful to keep the original values as column names (or to have the option to toggle whether or not special characters are replaced with underscores).

 

This is often an issue for reporting and for dynamically-populated app inputs (e.g. drop-down), where we need to retain the special characters.

 

For example, say I have the following dataset: 

kelly_gilbert_0-1593130247986.png

 

Currently, the crosstab tool produces this:

kelly_gilbert_1-1593130318568.png

 

I would like this:

kelly_gilbert_2-1593130621660.png

 

There are currently (somewhat cumbersome) workarounds such as adding an extra row with the original names, and then using Dynamic Rename to rename the columns, but it would be great to be able to use the data straight out of the crosstab!

I surprisingly couldn't find this anywhere else as I know it's been discussed in person on many occasions.

 

Basically the Formula tool needs to be smarter in many ways, but this particular post focuses on the Data Type component.

 

The formula tool, should not always default to V_String as the data type when entering data or a formula into the formula tool, it should look at the data type and estimate the most likely option.

 

I know there are times where the logical type might not be consistent in all fields, but the Data Preview and the Function of the formula should be used to determine the most likely option.

 

E.G. If I type a number or a date directly into the formula tool, then Alteryx should be smart enough to change the data type from the standard V_String to Int, Double or date.

 

This is an extension to the ideas posted here:

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Tab-from-Select-Column-to-Enter-Expression-H...

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Formula-tool-data-type-should-be-prominent/i...

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Alteryx-11-formula-tool-default-data-type/id...

I often need to create a record ID that automatically increments but grouped by a specific field. I currently do it using the Multi-Row Formula tool doing [Field-1:ID]+1 because there is no group by option in the Record ID tool.

 

Also, sometimes I need to start at 0 but the Multi-Row Formula tool doesn't allow this so I have to use a Formula tool right after to subtract 1.

 

So adding a group by option to the Record ID tool would allow the user not to use the multi-row formula to do this and to start at any value wanted.

I personally think it would work better to tab from 'Select Column' to 'Enter Expression Here' and not the 'Functions' List as probably people who are tabbing would immediately like to start typing the formula rather than going through functions, fields, etc.

 

joe_lipski_1-1589790965393.png

 

 

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.

When writing an expression in a Formula tool, I love that you can just type an open bracket and suggestions pop up that allow you to auto-fill the rest of the variable name. What I find frustrating, however, is that once you type the open bracket, the highlighted field automatically moves to the one where your mouse is pointing, regardless of if you have moved your mouse or not. I think it makes more sense to always highlight the first field in the list and only take mouse position into account once it has actually moved.

 

It is hard to describe in just a picture as opposed to a video but essentially I had my mouse below where I was typing in the screenshot below then when I typed the open bracket, the 3rd field listed automatically got selected even though I never moved my mouse.

Kenda_0-1589975960106.png

 

 

Cc: @Hollingsworth 

With the new intelligence suite there is a much higher use of blob files and we would like to be able to input them as a regular input instead of having to use non- standard tools like Image, report text or a combination of directory/blob or input/download to pull in images, etc. I would like to see the standard input tool capable of bringing in blob files as well.

Blob InputBlob InputImage InputImage InputText InputText Input

If you forget to put a name on a new column in the formula tool - the error message is 

The field "" is not contained in the record. (Expression #1)

 

Please could you replace this with a user-friendly message which is self descriptive like:

"Please provide a name for the new column created in expression 1"?

 

 

 

errorMessage.png

There is an extensive need from customers to be able to create emails but not send them (right away at least). This would be an enhancement to the email tool to allow for checking a box to say "Save in Draft" and if that box was checked the send email functionality would not be called but the email would be created. 

The expression editor in the RegEx tool is only a single line, which makes it really hard to edit long regular expressions. See attached photo comparing the expression editor in the RegEx tool compared to the formula tool for the same expression. Please make the RegEx editor box either wrap to multiple lines, have a pop-out expression editor, or something so we can see long expressions.

 

regex idea.PNG

Top Liked Authors