Alteryx Designer Desktop Ideas

Tool (or connection to ML translating engine) for languages translation embedded i.e. in Intelligence Suite might be useful when we are working on other than English languages - might be very beneficial especially for sentiment analysis or general text mining processing.

PS. I know that we have some translations macros in Gallery however embedded solution might be more useful for Alteryx users :)

Instead of current logic standing behind Round function ([variable1]/[variable2], mult) more intuitive will be approach known for example from SQL where the second operator represents number of decimal places, i.e. [variable]=23,4567 with new logic - Round([variable], 2) = 23,46.

Hi 

Sometimes when your using a filter you want to let everything pass through. Which means you have to remove the filter or go around it.

In stead of beeing able to out comment your filter. And the filter tool see's that as no filter.

All the other data types get basic filters but time doesn't get any besides a NULL check:

i would like to have a tool to verify whether the columns are exist or not.

if all exist then pass

else return error and indicate the filename and column missing in error message.

it happen when we using server. the user come back with the missing variable.

but do not know what file are missing that columns.

so if possible, we may have error message like, column "Status" not exist in "Data.xlsx|||Sheet1".

Suggestion Config:  similar to rename tool, but express is error message

Currently it is possible to save the expression in the formula tool. However, the field size and type are not stored with that saved expression, that would be some nice change. Maybe could be a checkbox to include that.

In working with a user who was having issues with workflows hanging, I found that the ‘Select Records’ tool seems to requires an inordinate amount of CPU Utilization.  To fix this, I rewrote the ‘Select Records’ macro to avoid using the ‘Dynamic Replace’ Tool.  What I found is that this not only significantly lowered CPU usage, but also runtime.

Can we please have a Group By option added to Random % Sample tool? It would ease a lot of things!

Hi Team,

As the formula design that able to stack multiple formula in once. There should have more things there.

1. Error Icon for formula have Error

Can you find which row have error in seconds?

We had to count to find which formula had error!!!!

and how about now?

At least, do have an icon or anything significant thing that let us found it in second and WITHOUT COUNT!!!

2. buttons to expand all/ collapse all.

It was normal that we need to review formula in again in future.

So, you need to click one by by to view all the formulas?

For any tool that uses the IF, THEN, ELSE or IIF statements, let the ELSE statement be optional (like in Python)

For example, notice in the proposed idea there is no ELSE statement, or a third parameter in IIF:

Today the Autofield tool transforms the fields into byte by default when it considers that the content is suitable while we expect text in it and that it can simply be a field not filled in in the context current but which may be later.

The idea would be to be able to choose which type by default to implement on text or empty fields and not the default byte because a byte field is not recognized on a formula using an IN for example which can produce errors in the following workflows.

A lot of business processes require encryption and decryption, for either data transfer or authentication processes.  It would be great if Alteryx could expose some of the C# encryption functions from the System.Security.Cryptography library, as either functions in the Formula tool, or as new tools. 

I know that some of these algorithms require byte input, so a new tool might be the sensible option, so that user can pass various data types that are pre-coded to byte arrays before going into the algorithms.

needs a much simpler way to configure this tool. Its way more obfuscated than it needs to be and the wording on the config is very confusing.

There are currently 7 data types related to numeric values, including byte.  Simply and standardize the way Alteryx handles numeric values.  Condense the numeric data types to one and provide a way to control the decimal places by indicating how many are needed to the right of the decimal.  The current numeric datatypes are confusing and do not behave the same with the formulas functions, like Round.

Adopt the standard numeric functions seen across multiple tools and languages like Excel, SQL, etc;  like RoundUp, RoundDown, AbsoluteValue, Integer, etc.  

When using the equal sum option in the Tile tool, you have the choice to sort by a column. However, it's not clear from the tool whether the data is being sorted in ascending or descending order.

Confusingly, the data is sorted in descending order, compared to the default of ascending in the Sort tool. This seems counterintuitive, as a user would expect the same defaults across tools (we did! and it caused some consternation when we worked out it wasn't) and also because in most of our use cases, you want the highest tile to be the highest rank, e.g., if you were sorting households by income.

I have two possible suggestions:

     1. Update the tool properties so that it reads "Sort column (descending)". (Probably the easiest change!)

     2. Allow the user to specify a direction with another drop down that becomes active when you select a sort field (similar to the sort tool).

I know that the functionality of suggestion 2 is available by adding a Sort tool before the Tile and sorting the data in ascending order. However, having to do that every time seems to defeat the point of being able to sort in the Tile tool.

Thanks for reading!

Jason

Standard Tile configuration:

Option 1 (mock-up):

Option 2 (mock-up):

Hi Team,

For a small workflow the current setup is okay to handle but with big workflow where input file count comes 25 at multiple locations then it is difficult to check every input.

The idea is: There should be some mechanism to check input/output before running the complete workflow 

• If any of the input file is locked then ask user to continue or not
• If any output file is locked then ask user to continue or not
• Or above this message can be combined together

Once this done the workflow can do further processing.

From my experience, this will help to improve work process and time to fix the issue.

Ashis Sanpui

I use the same 2 saved expressions across 58 workflows (and growing).

I'd like to know that I am using the universal expressions, so that I know that it is the latest version and that I am not missing an update.

Is there somewhere on the Configuration panel that can show the name of the expression in use?

Thanks,

Karen

Alteryx could have a way to, in select tool, choose the type of string field as numeric changing between comma or dot the separators without the needing of formula tool for that.

As we all know, we can filter only based on 1 condition on 1 column within our data-set using FILTER tool till date.

Idea is if people can add multiple conditions on same or different columns within same tool. e.g.

1. Multiple conditions might be on same column (like column A > 1 and A is not null)
2. Different conditions on different columns of dataset (like column A>=5 and B equals ="xyz"

Thanks!