Alteryx Designer Desktop Ideas

It would be great to have the below functionality in Alteryx.

A workflow is built in Alteryx and button click in Alteryx can be used to generate SQL code that can be ran on a specific database platform, such as SQL Server to run external editors such as SQL Server Management Studio. Thanks. 

Often as I am scraping web sites, some clever developer has put an invisible character (ASCII or Unicode) in the data which causes terrible trouble.

I've identified 89 instances of zero-width or non-zero-width glyphs that are not visible and/or Alteryx does not classify as whitespace. There are probably more, but Unicode is big y'all.

Unfortunately, the Trim() string function only removes 4 of these characters (Tab, Newline, Carriage Feed, and Space).
REGEX_REPLACE with the \s option (which is what the Cleanse macro uses) is a little better but still only removes 20. And it removes all instances, not just leading and trailing.

I've attached a workflow which proves this issue.

@apolly: this is what I mentioned at GKO.

And I did see this post (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Elegantly-remove-all-ASCII-characters-...), but it's too brute force. Especially as Alteryx is localized and more users need those Unicode characters.

Hi, I was looking for this but couldn't find a similar idea, so I post a new one. If someone knows about a similar idea, please ask the moderators to mer

CountChars(<String>, <char to count>,<case sensitive>)

Where <char to count> and <case sensitive> are optional parameters.

If <char to count> is not provided, the funtion will return the total character count within the <String>.

If <char to count> is provided, it'll return the number of ocurrences of that character within the <String>.

PS: For those tempted to suggest a workaround, I've been using REGEX_CountMatches() for this. Actually, the focus is to simplify user's experience and workflow performance providing a native function, instead of using REGEX which it's very demmanding on resources.

We build some pretty robust maps with multiple connections and it would be great to copy the map tool and paste it with all of the connections when we want to tweak the map slightly but keep our original map.  It is a regular occurrence for us to have a very detailed map grouping by trade area name and then may want to have an overview map with all of the same connections but slightly different layout.  Tracking down the connections, reconnecting them and naming them accordingly takes a substantial amount of time even in the most organized of workflows.  This function would be a huge time-saver.  It would also be of value with joins and unions - anywhere you have multiple streams coming in.

On the UNION tool, allow for deselecting columns that aren't relevant.  Leave the union exactly as it is, and you could go into the manual configuration. Align the columns just as you would in the manual configuration.  The addition would be that you have the behavior like you see in a join tool where you could deselect C1, C2, C3.... Cx. 

Too many times I have a union and there are fields I simply don't even want to bring in, but then have to add a select tool right after in order to remove them. 

Can we set our own Comment tool default preferences? - For me I want to set the text alignment to be "Center" by default, currently it's always "TopCenter" when I open it.

Hi there,

We often get the following error message from the download tool 

"00:00:23.555 - Error - ToolId 106: Error in libCURL: You have found a bug.  Replicate, then let us know.  We shall fix it soon."

Unfortunately this seems to be a transient error so we've not been able to replicate this in a useful & repeatable way.  However - we see this happening at least a few times per week on one of our servers, so this is a continuing issue.

Please could you provide more detailed error messaging on the download tool so that this error can be debugged and/or replicated?

Many thanks

Sean

In the community and in mixed teams - it's very common for people to be caught on the error that "This document was created in a more recent version".   Although there are several workarounds (e.g. this one from @WayneWooldridge  here https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Adjusting-Alteryx-Files-for-Different-Versio...), this seems like it may be an easy problem to solve more permanently.

Could we add an option to Alteryx to save the file with the lowest compatible version number?

So - for example - if i'm only using components that shipped with version 10, then please mark the file as version 10.   If I've used a tool that shipped in 11.0.6 then that needs to be the version number.

This way - files will be back-compatible as far as is possible by default unless using newer components.

Many thanks

Sean

Hi,

     Currently loading large files to Postgres SQL(over 100 MB) takes an extremely long time. For example writing a 1GB file to Postgres SQL takes 27 minutes! This is serious impacting our ability to use Alteryx as an ETL tool for loading our target Postgres Data Warehouse. We would really like to see the bulk load capacity to Postgres supported by Alteryx to help alleviate the performance issues.

Thanks,

Vijaya

I think it would be nice to be able to more easily reorder fields that you're joining by in the Join tool.

For example, I have already joined by CASS_Address and CASS_City. After I did this, I realized I wanted to go back and join on Name, too, and I want that to be first. How the tool is configured now, if I want Name to be first, I must redo all of the drop downs. I would like to be able to add Name to the next set of open drop downs then use some arrow buttons to be able to move them up in the order (similar to the Summarize tool).

I want to jump to expression #3 of formula (3), when I see following error message. Now I can jump to formula (3), but only expression #1 is opened, not #3. If I have 30 expressions, it is hard to find #20 in 30s.

Hi to all,

I have seen one or two posts requesting ability to total up rows and/or columns of numbers, however this idea also requests the ability to subtotal data by a field and also produce an overall total.

This could be an extension to existing tools such as 'Summarise' and 'Cross Tab' or could be a stand alone tool.  Desired output of using a tool like this would produce something like this:

This would be incredibly useful for building reports within Alteryx as well as analysing the data, and cut down the amount of tools currently required to produce this.  I have seen a third party tool which does some of this but this adds the ability to subtotal.

thanks - Roger

I understand the need for "exclusive rights" when using an input tool.  Unfortunately, due to the nature of some corporate data, getting write access to a file is not always possible.  I would like to have the ability to configure an input tool to open a file in "Read Only" mode while producing a warning message that the file was processed in that mode and may not contain the lastest version pf the data.  I envision this as a checkbox option in the tool configuration panel.

Now that we have a Snowflake Bulk Loader option, it would be great to utilize the built-in Snowflake internal staging.  This eliminates the need for an end-user to have the technical know-how or access to IT resources to utilize a separate S3 bucket and generally reduces friction in the process. 

There was pretty widespread support in the original Bulk Load thread: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Snowflake-Bulk-Loader/idi-p/105291/page/2#co...

Please include IBM DB2 as an in-Database option. Currently, my primary use of Alteryx is for copying DB2 tables into Teradata for use on that server. Copying large tables and particularly joining several tables and copying the results to Teradata is too slow in Alteryx.

Although this could also effect ANY formula, the RegEx tool does not support a flag for Multiline.  Often incoming data contains multiple lines of data and the user must replace new lines and carriage returns with a space or other delimiter in order to operate a regular expression on all of the data.

RegEx has a multiline flag (for Alteryx it would be a checkbox) that allows it to handle each line separately.

domain.com

test.com

site.com

if these are individual records, then \w+\.com$ works wonderfully,  if these are all contained in a single EXCEL cell, then you need to write to community to figure out what to do.

Cheers,

Mark

We've had several requests from clients for the ability to import password protected Excel spreadsheets into Alteryx.  Within Alteryx, it would be good to specify the password and inport the file without the need to create an unprotected copy for use in Alteryx.

Thanks

Many files I use are in .xlsb format.