Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

A lot of popular machine learning systems use a computer's GPU to speed up some of the math to a huge degree. The header on this article on Medium shows a 15x difference from a high-end CPU vs a high-end GPU. It could also create an improvement in the spatial tools. Perhaps Alteryx should add this functionality in order to speed up these tools, which I can imagine are currently some of the slowest.

When I add a data connection to my canvas - it's only added to the Data Connections window under certain circumstances (e.g. when I use an alias, or the SQL connection wizard) rather than showing ALL data connections.

 

Given the importance of data connections for Alteryx flows - it would be better if ALL data connections were grouped together under a Data Connection Manager, which was as visible as the results window not buried deep in the menu system - and you could also then use this spot to change; share; alias etc.

 

 

 

2018-06-01_6-22-37.png

 

In Microsoft SSIS there's a useful example of how this could be done - where the connections are very visibly a collection of assets that can be seen and updated centrally in one place.    So if you have 5 input tools which ALL point to the same database - you only need to update the connection on your designer in one place - irrespective of whether this is a shared connection or not.

 

2018-06-01_6-27-45.png

Many of us use auto-increment primary keys in our tables, but these PK's don't exist in the raw data as a natural key.  So when we get new raw data, we cannot use the Update / Insert if New method which keys off the Primary Key.

 

Imagine if you could select ANY unique key on the table instead?  

 

There's no reason not to allow this from a SQL perspective, though it might be a little less efficient for some DB engines.  But it would make things so much easier!!!

 

Right now, I instead load to a temp holding table and then do deletes and inserts using the Post Create SQL statement.

One of the biggest areas of time spent is in basic data cleaning for raw data - this can be dramatically simplified by taking a hint from the large ETL / Master data Management vendors and making this core Alteryx.

 

Server Side

- Allow the users of the server & connect product to define their own Business Types (what Microsoft DQS calls "Domains")

       - Example may be a currency code - there are many different synonyms, but in essence you want your data all cleaned back to one master list

- Then allow for different attributes to be added to these business types

       - Currency code would have 2 or 3 additional columns: Currency name; Symbol; Country of issue

- Similar to Microsoft DQS - allow users to specify synonyms and cleanup rules.    For example - Rupes should be Rupees and should be translated to INR

- You also need cross business type rules - if the country is AUS then $ translates to AUD not to USD.

- These rules are maintained by the Data Steward responsibility for this Business Type.

- This master data needs to be stored and queryable as a slowly changing dimension (preferrably split into a latest & history table with the same ID per entry; and timestamps and user audit details for changes)

 

Alteryx Designer:

- When you get a raw data set - user can then tag some fields as being one of these business types

      - Example: I have a field bal_cur (Balance Currency) - I tag this as Business Type "Currency"

- Then Alteryx automatically checks the data; and applies my cleanup rules which were defined on the server

- For any invalid entries - it marks these as an error in the canvas; and also adds them to a workflow for the data steward for this Business Type on the server -  value is set to an "unmapped" value.    (ID=-1; all text columns set to "unmapped")

- For any valid entries - it gives you the option to add which normalised (conformed) columns you want - currency code; description; ID; symbol; country of issue

 

Data Steward Workflow:

- The data steward is notified that there is an invalid value to be checked

- They can either mark this as a valid value (in which case this will be added to the knowledge base for this business type) or a synonym of some other valid value; or an invalid value

 

Cleanup Audit & Logs:

- In order to drive upstream data cleaning over time - we would need to be able to query and report on data cleanups done by source; by canvas; by user; by business type; and by date - to report back to the source system so that upstream data errors can be fixed at source.

 

Many thanks

Sean

It would be good to replicate some of the key workflow configuration settings as shortcut icons in the main shortcut toolbar.

 

For instance, I often use 'Disable all tools that write output' and need to toggle it on/off quickly when I'm testing a workflow. It takes too many clicks to deselect a tool, open workflow configuration, open the Runtime tab and select the checkbox. Many end-users I work with also don't even know the option is there because it is so well-hidden.

 

It would be much simpler and easier If I could toggle it straight from the shortcut bar. Having a keyboard shortcut to do it, like I do with ctrl-R (to run) would be even better.

 

Having shortcuts would also be good for:

 

  • Disable all browse tools
  • Show/Hide connection progress
  • Open the Events window

shortcut.png

Hi all,

Just to give you some context, we have a customer that requires that for every Tableau workbook we deliver, we must add extra documentation, as for instance, for every calculated field, in which views it's used, and the formula of that field (yes, I know exactly what you're thinking right now :P)

So I decided to take a shortcut and do a workflow that extracts the basic (I mean VERY basic) data from the .twb file, so I can save a lot of time. 

 

Then I came with this idea...

 

Having a lot of Tableau's under the hood experts in this Community, It would be great to gather some of them and create a Tableau Documenter Macro.

 

I'd love tho hear what you think, and who's being able to help.

 

I suppose I could just bookmark this page, but that wouldn't help others.  I frequently forget (I'm getting old) the format strings while creating custom datetime formulas.  Is there a quick way to get to these format strings when in the context of creating a datetimeparse/datetimeformat formula?

 

Cheers,

Mark

 

Alternative data sources are key for enriching data. one source is social media.I believe Alteryx lacks in social media analytics.

 

  • I would like to propose a YouTube connector...
  • Crawl comments and video definitions (useful for text analytics)
  • Impression and likes/dislikes... (time-series data)

 

If you are into #media, #advertising, #marketing analytics, #influencer analytics please support the idea by seconding...

 

There is an API called YouTube DATA API

https://developers.google.com/youtube/v3/getting-started

Picture1.png

 

 

 

Debug mode is fantastic, but it is a pain to navigate to it through interface designer. I suggest a shortcut button next to the 'run as app' button on the top toolbar.

 

debug.PNG

It would be great if Alteryx could better handle Carriage Returns!  If I have a csv file that has Carriage Returns (\r) in the Description field Alteryx displays it like so in the browse tool:

 

1.png

 

I’m ok that it’s ignoring the carriage returns entirely to better display the data, but the problem is that there is no way to know by looking at this browse tool that there are “hidden” carriage returns in my data. When we try to copy this to excel and it looks like this:

 

2.png 

 

Unfortunately, this isn’t quite how I was expecting it to look. I think there are three related changes I would like to see:

 

1) Change the copy feature of the browse tool so that it ignores carriage returns (\r) just like when you display it in a browse tool.

 

2) Make a new character that would display the carriage return when I click the “show whitespaces” button. It shows line feeds (\n) as paragraph symbols but won’t show carriage returns (\r). Here is what the \n looks like if I replace my \r with \n:

3.png

My \r character currently doesn’t display at all:

4.png

 

3) Add the red triangle indicator similar to the line feed (\n):

 5.png

 

I currently get no warning that there are embedded carriage returns.

Thanks!


Scenario: I open a results window with a link, filepath, value, etc. and I want to copy the text.

 

If I click inside of that cell and press Ctrl +A, nothing happens.

 

If I click inside the cell, arrow to the end of the text, and then press Shift + Home; the contents of the cell are highlighted.

 

Why can't we have all of the Windows shortcuts?  Or am I missing something here?

I came up with an idea while replying to @Deeksha. An interesting option to secure the data would be to encrypt the data sets and "license" it to

  • specific users
  • specific time spans or
  • people with certain credentials

just like we do by encrypting the workflow...

 

Picture5.png

 

 

Picture6.png

 

 

 

 

 

It would be nice to instead of scheduling a workflow at a certain time, just schedule workflows to run after the current workflow is done.  

 

So what it would be is instead of running workflow B at 6:00 AM every morning, you could run workflow B when workflow A finishes running so that you would know that if there was anything happening in workflow A that workflow B relied on, everything would finish in the correct order.  

when using the R-Tool for simple tasks (like renaming files, for example) in an interative macro - there's a delay on every iteration as the R Tool starts up R.

 

The following are repeated on every iteration (with delays):

2018-08-19_21-41-23.jpg

 

Can we look at an option to forward scan an alteryx job to look for R Tools, then load R into process once to eliminate these delays on every iteration?

 

Writing SQL to set primary keys in Alteryx before outputting the data is tedious, right?

 

I propose that you guys could incorporate my macro as a tool (referenced here:http://community.alteryx.com/t5/Data-Sources/Variables-used-in-Input-Path/m-p/38199#M2604).

 

It sure is a lot faster than going through this process: http://community.alteryx.com/t5/Alteryx-Knowledge-Base/Create-Database-Table-Primary-Key-in-Alteryx/...

 

I regularly create events to capture messages from workflows or kick off batch scripts for other processes and they are repetitive. Is there a way to template some of these?

 

This could even be as simple as a saving the .yxft type file, where it is only saving the setting.

 

Email Event TriggerEmail Event TriggerRun Command Event TriggerRun Command Event Trigger

This wasn't pretty (actually, it was challenging and pretty when I was done with it)!

 

My client receives files that include a static and dated name portion (e.g. Data for 2018 July.xlsx) within the file there are multiple sheets.  One sheet contains a keyword (e.g. Reported Data) but the sheet name also includes a variable component (e.g. July Reported Data).  I needed to first read a directory to find the most recent file, then when I wanted to supply the dynamic input with the sheet name I wasn't able to use a pattern. 

 

The solution was to use a dynamic input tool just to read sheet names and append the filtered name to the original Full Path.

[FullPath] + "|||<List of Sheet Names>"

This could then feed a dynamic input.

 

capture.jpg

Given the desire to automate the read of newly received "excel" data and the fluidity of the naming of both files and sheets, more flexibility in the dynamic input is requested.

 

Cheers,

 

Mark

It is very difficult moving from Alteryx functions to SQL In-Database as a business user, I need to learn a whole new language.

 

In the short term Alteryx should provide a simple function reference, as similar as possible to the Formula tool, for building formula in the in-database tools.

 

Longer term I'd like there to be a parser from Alteryx Formulae to SQL so I can just write in my favourite Alteryx formula (or a subset thereof) and Alteryx handles the conversion to SQL. 

I need support for outbound data streams to be gzip compressed.  Ideally, this would be done by a new tool that can be inserted into a workflow (maybe similar to the Base 64 Encoding tool).  Just including it in the Output Tool will not address my needs as I will be sending gzip payloads to a cloud API.  There are two main reasons why this is necessary (and without it, quite possibly a roadblock for our enterprise's use of Alteryx):

 

  1. Some APIs enforce gzip encoding, therefore Alteryx cannot currently be used to interact with such APIs
  2. When transmitting large volumes of data across the Internet, gzip compression will significantly decrease transmission times

Sometimes I just want to see the tool names without the annotations. Currently the options are Hide, Show, Show with Tool Names, but there doesn't seem to be a way to just see Tool Names without annotations.

Top Liked Authors