Alteryx Designer Desktop Ideas

Each license key can only handle up to 300 installations. For big companies like us in PwC, this is a struggle because we distribute software via SCCM and each territory needs to create a special script to handle this limitation. We have lots of folks using Alteryx so it would be great if you guys can find a way to remove this limitation or provide us with an easier and more efficient way to deploy the software to a huge amount of users world-wide. Thanks!

Currently there is a maximum amount that can be passed into the Dynamic Input, 1MB. I often hit this limit and it is infuriating.  If this was upped to 5MB that would solve a lot of my issues, but 50MB would be AMAZING.

Thoughts?

-Nick

Clustering your data on a sample and then appending clusters is a common theme

especially if you are in customer relations and marketing related divisions...

When it comes to appending clusters that you have calculated form a 20K sample and then you're going to "score" a few million clients you still need to download the data and use the append cluster...

Why don't we have an In-db append cluster instead, which will quicken the "distance based" scoring that append cluster does on SQLServer, Oracle or Teradata...

 Best

When several fields are marked the marking of check box should apply to all selected fields. 

When changing Type the change should also apply to all selected fields.

There should also be shortcut keys for doing this.

This is a really common task and would save a lot of time. I'm actually really surprised it does not already exist in Alteryx Designer.

It would be extremely helpful if there is an easy way to print off the current function reference for 11.0. In the past, you could easily do so with 9.5 (with the print button), but even putting out a basic PDF file that outlines the parameters for each function, and what it does would be useful. This is not possible with the newest version of the documentation.

https://help.alteryx.com/9.5/index.htm

https://help.alteryx.com/current/index.htm

It would be extremely helpful if the Alteryx documentation expanded more on how to specify a basic character class from within the documentation page:

https://help.alteryx.com/10.6/index.htm#boost/character_class_names.html%3FTocPath%3DReference%7CBoo...

so that you could easily tell Alteryx what character class you want, as outlined here:

Currently, it is very hard to look at the documentation, and know what characters encompass what class. Adding this would be extremely useful. The only way I found the syntax was through the formula menu, which is depressing that its not on the function reference page itself:

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/RegEx-Perl-Syntax-Guide/ta-p/1288

I absolutely love that version 11.05 added the "open containing folder" function to each workflow tab.  Can you add the same to input files?

I'm stealing this idea from Tableau's number formatting, it's a timesaver.

In the DateTime tool if I've initially selected a value besides Custom in the "Select the format..." list then when I click Custom rather than having the Custom textbox be blank I'd like to have it automatically populated with whatever formatting string I just selected. Here's an example screenshot:

I have used Publish to Tableau Server macro for over a years.  It works fine when I want to overwrite the data. 

However, the current macros (from Alteryx Gallery and Invisio) won't work with appending the data. Please modify or develop a workable macro for 'Append the data to Tableau Server'. It will save a lot of time in the daily update process.  

Note: I am using Alteryx 11 and Tableau 10.1. Thank you very much.

I would like to request that IBM Big Insights become a supported data source. Currently I have been unable to connect Alteryx Designer to Big Insights through any ODBC driver.

The tokenize would be more powerful if in addition to Drop Extra with Warning / Without Warning / Error, you could opt to have extra tokens concatenated with the final column.

Example: I have a values in a column like these:

3yd-A2SELL-407471

3vd-AAABORMI-3238738

3vd-RMLSFL-RX-10326049

In all 3 cases, I want to split to 3 columns (key, mlsid, mlsnumber), though I only care about the last two.  But in the third example, the mlsnumber RX-10326049 actually contains a hyphen.  (Yes, the source for this data picked a very bad delimiter for a concatenated value).

I can parse this a lot of different ways - here's how I do it in SQL:

MlsId = substr(substr(listingkey, instr(listingkey, '-')+1), 1, instr(substr(listingkey, instr(listingkey, '-')+1), '-')-1)
MlsNumber = substr(substr(listingkey, instr(listingkey, '-')+1), instr(substr(listingkey, instr(listingkey, '-')+1), '-')+1);

With Regex tokenize, I can split to 4 or more columns and then with a formula test for a 4th+ column and re-concatenate.  BUT it would be awesome if in the Regex tokenize I could instead:

1. split to columns

2. # of columns 3

3. extra columns = ignore, add to final column

When adding multiple integer fields together in a formula tool, if one of the integer values is Null, the output for that record will be 0. For example, if the formula is [Field_A] + [Field_B] + [Field_C], if the values for one record are 5 + Null + 8, the output will be 0. All in all, this makes sense, as a Null isn't defined as a number in any way - it's like trying to evaluate 5 + potato. However, there is no error or warning indicating that this is taking place when the workflow is run, it just passes silently.

Is there any way to have this behavior reported as a warning or conversion error when it happens? Again, the behavior itself makes sense, but it would be great to get a little heads up when it's happening. 

Hello all,

Within the databases that I work in, I often find that there is duplicated data for some columns, and when using a unique tool, I have little control of what is deemed the unique record and which is deemed the duplicate.

A fantastic addition would be the ability to select which record you'd like to keep based on the type + a conditional. For example, if I had:

I would want to keep the non-null field (or non-zero if I cleansed it). It'd be something like "Select record where [Field 1] is greatest and [Field 2] is not null" (which just sounds like a summarize tool + filter, but I think you can see the wider application of this)

I know that you can either change the sort order beforehand, use a summarize tool, or go Unique > Filter duplicates > Join > Select records -- but I want the ability to just have a conditional selection based on a variety of criteria as opposed to adding extra tools.

Anyways, that's just an idea! Thanks for considering its application!

Best,

Tyler

 In my use of the Data Cleansing I want all the fields to be cleansed. Selecting the ALL choice selects all the fields, however if new fields are added later they are not automatically added. Perhaps the addition of a UNKNOWN choice as in the SELECT tool.

Thanks!

Hi all

It would be helpful to have the possibility to work with placeholders in zip file input:

1. placeholder for zip file itself    c:/data/*2017.zip

2. placeholder for the files in the zip file  *raw.csv

It would make it easier to automate daily zip files with files with the same structure in the zipped file.

Kind regards

Steffen

Hi All,

It would be great if Alteryx 10.5 supports connectivity to SAS server.

Regards,
Gaurav

The object name is too long in NFD/NFC when connected to Teradata Error occurs when you use SQL comments above the SELECT statement within the Connect In-DB customer query box. Once the comments are removed the problem is resolved. It would be great if the Connect In-DB tool could recognise comments as what they are. 

I want to use Alteryx to pull data from a SharePoint List.  This shouldn't be a problem, but I use SharePoint Content Types.  Alteryx won't allow me to import any list that has Content Types enabled; thus rendering the SP list input type not usable. 

My interim workaround is to create a data connection thru excel to the list and then pull the data in that way, but optimally, I would like to pull directly from the list.

Content types are a best practice in SharePoint, so any list or library in my site collection contains them.

Please update the SharePoint list input to support content types.

thank you,

Someone else inquired about this but I didn't see an idea entered /

https://community.alteryx.com/t5/Data-Sources/SharePoint-List-Input-Problems-importing-content-types...

My system's regional settings are German that uses a different decimal symbol and digit grouping than an English system.

Frequently I need to copy data from a browse tool in Alteryx to Excel to create a quick chart or further analysis; this often includes float or double data types.
Instead of the in my case correct ',' as decimal symbol, Alteryx uses the English '.', hence would cause incorrectly pasted values in Excel.
Always using an Excel file as output data is time consuming.

The request is: Make Floats and Double aware of the systems regional setting for copy and paste out of results.