Alteryx Designer Desktop Ideas

Please upgrade the "curl.exe" that are packaged with Designer from 7.15 to 7.55 or greater to allow for -k flags. Also please allow the -k functionality for the Atleryx Download tool.  

-k, --insecure

(TLS) By default, every SSL connection curl makes is verified to be secure. This option allows curl to proceed and operate even for server connections otherwise considered insecure.

The server connection is verified by making sure the server's certificate contains the right name and verifies successfully using the cert store.

Regards,

John Colgan

Have you ever used a Join tool with several (or many) Join fields, looked at the the L and R outputs and wondered, why didn't these records join? When there are many columns in your data, this can be a hard question to answer. It would be very handy if Alteryx could somehow report the Field(s) that each record failed to join on (perhaps as an optional added field to the L and R outputs).

Preface: I have only used the in-DB tools with Teradata so I am unsure if this applies to other supported databases.

When building a fairly sophisticated workflow using in-DB tools, sometimes the workflow may fail due to the underlying queries running up against CPU / Memory limits. This is most common when doing several joins back to back as Alteryx sends this as one big query with various nested sub queries. When working with datasets in the hundereds of millions and billions of records, this can be extremely taxing for the DB to run as one huge query. (It is possible to get arround this by using in-DB write out to a temporary table as an intermediate step in the workflow)

When a routine does hit a in-DB resource limit and the DB kills the query, it causes Alteryx to immediately fail the workflow run. Any "temporary" tables Alteryx creates are in reality perm tables that Alteryx usually just drops at the end of a successful run. If the run does not end successfully due to hitting a resource limit, these "Temporary" (perm) tables are not dropped. I only noticed this after building out a workflow and running up against a few resource limits, I then started getting database out of space errors. Upon looking into it, I found all the previously created "temporary" tables were still there and taking up many TBs of space.

My proposed solution is for Alteryx's in-DB tools to drop any "temporary" tables it has created when a run ends - regardless of if the entire module finished successfully. 

Thanks,

Ryan

I have been developing and accumulating custom functions over the years and they have proved to be very useful.  I am submitting these here.  I hope they are found to be beneficial.

Functions included in the attached file include:

• DateTime
  • StandardDate(String) - Transforms any valid string to the standard date format yyyy-mm-dd
• File
  • FileDirDepth(Path) - Returns the zero based depth of the path (zero being the root)
  • FileGetFolder(Path, Depth) - Returns the folder name given the zero based depth in the path (zero being the root)
• String
  • LeftPart(String, Separator) - Returns the left part of a string up to the first separator
  • RightPart(String, Separator) - Returns the right part of a string after the first separator
  • Split(String, Delimiter, Index) - Returns the zero indexed part of a delimited string
  • CleanSpace(String) - Trims string and replaces multiple spaces with a single space
  • UnicodeToASCIIBasic(String) - Replaces all Unicode Characters with ASCII Basic equivalents
• Test
  • InList(Variable, List) - If Variable is in List returns True. List must be pipe delimited
  • IsValidEmail(String) - Returns True if string is a valid email format
  • IsUUID(String) - Returns True if string is a valid UUID

To make these functions available in Alteryx, place the attached xml file in the folder C:\Program Files\Alteryx\bin\RuntimeData\FormulaAddIn if you have a standard installation. If the install is non-standard, find the \bin\RuntimeData\FormulaAddIn folder and place the attached xml file there.  Ateryx will need a restart for the functions to be available.

When documentin alteryx screen I sometimes hit printscreen and need to paste important matters to Comment tool...

But there is no paste from clipboard 😞

I suggest adding a minor icon that enables not only reading from png but pasting a screen or other image copied directly from memory...

For I need the following setting so I printscreen and capture as is;

Then put that into a PNG or JPG file using paint. And then prepare a comment box with that image in the background...

I know that incoming and outgoing connections can be wired and wireless, and that they will highlight when one clicks on a tool. However, it would be very useful to be able to highlight a particular connector in a particular colour (selected from a palette, perhaps, from the drop down window, or from the configuration). This would be especially useful when there are many connectors originating from a single tool.

Thanks

The behavior of an "Overwrite Sheet (Drop)" configuration is such that it breaks formulas (#REF) that point to the overwritten sheet and named ranges that reference the overwritten sheet.  This is a bummer because the only way I've found to overcome the issue is to write a script that re-applies the named range.  This works, but it greatly raises the barrier to using this tool and in some corporate environments it won't even be possible.

What would probably be a good alternative behavior is to delete the contents of the sheet, rather than the rows/columns/cells of the sheet.  I think both probably have valid use cases but my proposed functionality is going to cause fewer issues and be the more popular behavior for most users.  I believe there is a google sheets API call for just this kind of behavior...

Alteryx should really get into the business of having a metadata management tool integrated into the UI.

We recently started training new users with Alteryx, making it more widespread than the few (less than 10) that already had it.  The good and bad of Alteryx is that it really allows us the power to do work we've never done before.  That also means that we've not had to worry too much about resource contention before either.  But with great power comes great responsibility and now we do need to think find a way to manage this power.

There are some good new ideas out there that use the concept of cloud-sourced data governance (specifically, I just checked out Alation).  But why should we have to go to two separate platforms then to examine our data? 

I already know that if I have to spend more time switching back and forth between two platforms to get the same job done with greater care will result in many people taking shortcuts.  Why couldn't this or something like it be integrated into Alteryx?

Hi,

I would like to be able to modify my connection string in the Alias Manager.

Connection string is greyed out :

If I want to change my connection string, I have to create a new alias.

It would be nice to have functionality similar to the List Box where a user can select all items at once, or deselect all items at once.  The workaround for now would be to roll everything up to an individual Key (maybe called "All").  But it would still be nice to have those two options (again, just like on the list box).

Hello,

Please enable wildcard ability for the Amazon S3 Download Tool.

Add this to the "Object Name" field in configurations.

The current workaround is to use a macro to iterate over the filenames matching a pattern.

Adding this ability in the connector would remove the need for a macro.

Thank you.

Dennis

Hello. While working at my company it has come up a few times that An Interface tool that acts like a standard "grid" would be extremely helpful.  

This tool would allow users to update data that has a logical link to each-other like a stanard "row".  Below are a few very simple examples where this would be extremely helpful.

#1) An application is being used as a file System ETL that has an interface that allows users to select what data to pull from a flat file and store in a database.  The users can pick which 'columns' to keep by choosing the following information.  The column name, type, and final database location of that column. 

In this case a user needs to enter 3 key pieces of field information that have to relate to eachother.  

#2) There is a table in a database that has thresholds for a specific law at the state level. (for Example: All loans in Florida must have a loan balance < 300k).  However these laws can be updated, and the end users want the ability to #1: See the data, and then #2: Update it if the laws have changed.

A grid in this case would be perfect, as they could query the data to see the 50 states and specified limits, and then change the data in the "limits" column in order to update the database.

The previous 2 examples are pretty simple examples, but I have run into this request a few times from my personal experience, so figured I would see what everyone thought!

I know this has been suggested before, but it would be great if calculations and transformations could be cached between workflow executions.  Perhaps the browse tools could be configured as caches.  Any spot that has a browse tool fixes the value of that node between runs provided that there are no upstream tool changes. The cache could be optional (or flushed) to allow for dynamic input data that could change between executions, even if the tool chain didn't.

I think it would be great, especially if you have browse tools at multiple phases in workflow, to be able to view Browse results while module is running, rather than having to wait until it's done. I think it would help with being able to head off problems sooner.

Current State:  When a macro contains nested macros the only method that reliably works to share them is via yxi (which I fondly refer to as my wixies). 

Future State:  Allow macros published to the gallery be their own tool palette so that when I or any user connects to the server the macros are there and just work, no import, no visible install just a single set of tools that work on that server. 

Side task - also get export to yxi 

Multi-Resolution Raster format, or .mrr, is a MapInfo Pro Advanced file format that is becoming increasingly common as an output option for many software providers.  It is being used in place of .grd and .tiff file formats in some instances, because of its many advantages over most raster formats.  I would like to request that alteryx allow .mrr files to be included as input options, as it seems this trend isn't going to decrease anytime soon.

I recently ran into an issue where I had to remove my company's gallery from my Designer's Save As menu.  Unfortunately, figuring out how to do this in the UI took far longer than I anticipated, and I actually blew it away using the registry.  Eventually I found that when going to Save As, you can either remove it from the "Connecting" splash screen or you can press the gear from the Save As dialog box and remove the gallery that way, neither of which are an intuitive way to manage gallery removal.  I would advocate for adding an entry to the Advanced Options menu along with data source collections for adding/removing/modifying gallery connections.  

As this list of connection, dependency, and gallery management entries continues to grow, it may also make sense to remove it from "Advanced Options" and create a more descriptive "Data" or "Connections" menu or sub-menu.  I think it would be helpful to see aliases, in-db connections, dependencies, assets, and gallery management all grouped together within the interface.

Right now, the List Box interface tool allows end users to select multiple options of fields for selections, filtering, and formatting/formulating. 

However, it doesn't do quite as good when a use case has over 1,000+ columns/fields. This is made even more complicated with each column/field having somewhat similar naming conventions thereby causing confusion. 

Having a search function, as made available in standard Select Tools, Join tools, and other tools that has filtering capacity, will be most helpful for developers to give maximum flexibility to end users.

Toggle individual expressions on/off in the formula tool.   

On more than a few occasions I have a number of expressions in a single formula tool and find myself wanting to turn off a few or many, but not all. 

It'd be great if there was a checkbox to activate/inactivate : on/off : include/exclude : select/deselect (whatever language you like for the concept) an individual expression.

Simple as a text box.  with maybe a 'select/deselect  ALL box available incase you want to turn most off then only select a single one?