Alteryx Designer Desktop Ideas

I often have up to ten or more workflows open at a time, several are named and are active workflows that I want to save, and the rest are just scratch workflows where I'm trying something out. When I close Alteryx it asks if I want to save changes to workflows, with the list of all the workflows. If I don't want to save the scratch workflows, I have to cancel, close each one individually, then exit Alteryx again, saving the ones I want to save.

It would be great if there was a check box next to the workflows in the list where you could check the ones you want to save, and it would drop the rest.

A suggestion for the designer product...

When one right clicks on tab showing a workflow, an option should come up to duplicate workflow/macro/etc.

Some of us work in teams to build complex workflows, resulting in various versions that have to be stitched together. It would be amazing to have the workflow on a shared drive and have a mode where multiple users can build, review, and modify simultaneously. (This was one of the biggest sells for our company migration from Microsoft Office to Google suite). 

This would promote collaboration, learning, and more efficient and quality driven workflows. 

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.

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.

In a large enterprise - one of the key challenges is cleaning data in a consistent way.    Many of the big EIM stacks have tooling for this which allows end users to create data cleanup rules, and the Microsoft version is called DQS (Data Quality Services).

Can we please add a connector to alteryx to allow us to drop a DQS cleaning tool onto a canvas - and then the 3 outputs will be

• data cleaned by DQS rules (managed by the data steward)
• error data that is invalid
• any status messages from the DQS call?

This would allow Line of Business users to build their own data cleaning rules consistently in one place, an lift this burden from the data analyst.

Thank you 

Sean

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

When using the Cross Tab tool, the Count option under Method for Aggregating Values only appears when the field selected for Values for New Columns is a numeric field. I can add a numeric RecordID before the Cross Tab and then count on that, but why can't the Cross Tab count non-numeric fields? The Summarize tool can.

Hello,

It would be nice if Alteryx had a way to create a time lapse video based on a date field.  Create a map showing data over time (day, week, year, etc) that shows it cumulative or individual for each time frame.  I needed to map a set of location points, with a date field, to show where and when they opened throughout time by each year or by each decade, so it starts with only a few locations, then keeps adding the new locations with time to show all locations at the end or present time.

Thanks,

Bob

Hey Alteryx!

Here's one. I don't care for the tabs at the top showing each workflow. They are not in order by open date and it's hard to tell whether tab all the way on the right is the final workflow or not... They are hard to X out (especially the last one on the right that seems to have a semi hidden X). Depending on your monitor layout/resolution, you can only see like 10 visible workflows at a time in the gui. If you want to see more, you have to go into the workflow dropdown carrot which AFAIK also doesn't seem to be in any particular order esp when you open up several flows having same name. On a side note - what happened Alteryx? They USED to be in order by open date going across at the top AND in the workflow dropdown... That was useful.

So let get rid of these tabs. It's so windows95.

Instead create an interactive workflow history table (window) similar to what exists in TOAD, sql assist and other database tools (see image below). It's a table in the view but each row would reflect a workflow (formerly a tab). Top row is most recent workflow and moving down the table shows history of workflows.

You could can hover over a row to see details pop up for that workflow OR you could click each row (double click to run?) and workflow becomes visible in active canvas and overview and results window update accordingly. Maybe we could even have more than one active window per session? (sort vert/horz).

Additional benefits/functionality:

1. Slightly more screen real estate which we know you are always looking for and asked about 🙂

2. This could also be an autosave feature. When Alteryx crashes - and it does - when you reopen designer all your history will be there - no loss of productivity! Also high on your list.

3. Have an additional search function where we can search for tool names, comments, annotation, workflow/app/macro names, odbc connections, specific formulas or key words and then we see which history rows match our search criteria (rather than searching using notepad++ 'find in Files' feature in a directory)

4. It's not that much dev time since workflow history is already available in some buried log so why not show some of this metadata to the user in the gui?

Thanks,

Simon

As Alteryx becomes more focussed on the Enterprise - it is important that we build capabilities that support the needs of large-scale BI.

One of these critical needs is dealing with heterogeneous data from different systems that use different IDs for every critical entity / concept (e.g. client; product)

Here's the example:

Problem:

- In any large enterprise - there are several thousand different line-of business systems

- Each of these was probably built at a different time, and uses a different key for specific concepts - like Client & Product

- Most large enterprises that I've worked at do not have a pre-built way of transforming these codes so...

- This means that any downstream analytics finds it almost impossible to give single-view-of-customer or single-view-of-product.

Solution option A:

Reengineer all upstream systems.   Not feasible

Solution option B: 

Expect some reference-data team to fix this by building translations.   More feasible but not fast

Remaining Solution Option:

Just as Kimball talked about - the only real way is to define a set of enterprise dimensions, which are the defined master-list of critical concepts that you need to slice-and-dice by (client; product; currency; shipping method; etc) in a way which is source-system agnostic

Then you need a method in the middle to transform incoming data to use these codes.   This process is called "Conforming"

What would this look like in Alteryx?

Setup

• We would use the connect product to define a new dimension - say "Product".
• Give this a unique ID which is source-system independant; and then add on the attributes that are important for analytics (product type; category; manufacturer; etc)
• Then decide how to handle change (slowly changing dimension or SCD type 0,1,2, etc).   Alteryx should take full responsibility for managing this SCD history; as do many of the competitors
• We then create a list of possible synonym types (within Connect).   For example - a product may have a synonym ID from your supplier; from your ERP system; from your point of sale system.  that's 3 different IDs for any product.
• We then load up the master data - this is painful but necessary

In Use:

• I read in data into alteryx via any input tool
• I bring in a "Conforming" tool off the toolbox (new tool which is needed)
• It asks me which column or columns I wish to conform
• For each - it asks me which synonym type to use
• It then adds a translated column for me to use which ties back to the enterprise dimension - and spits out the errors where the synonym is necessary.

Impact:

In BI in smaller contexts, or quick rapid-fire BI - you don't have to worry about this.   But as soon as you go past a few hundred line-of-business systems and are trying to do enterprise reporting, you really have to take this serious.   This is a HUGE part of every BI persons's role in a large enterprise - and it is painful; slow and not very rewarding.   If we could create this idea of a simple-to-use and high-velocity conforming process - this would absolutely tear the doors off enterprise BI - and no-one else is doing this yet!

+ @AshleyK @BenG @NickJ @ARich @patrick_digan @JoshKushner @samN @Ari_Fuller @Arianna_Fuller 

Hi,

I am working on a macro that has multiple listboxes and xml tree controls in it and the listbox controls have a feature in the top right to select all or none, effectively allowing you to clear any entries you had made and start fresh.  In the tree control, there is no such feature but it would be nice to have instead of having to remember and go through and find all the entries you had made to start fresh.

To the point of the macro interface, when developing and testing using the interface designer, you are able to 'reset' the interface using a button at the top of the left pane.  It would be nice if that was available in the macro interface at run time. And that would solve the issue with the tree control in one step.

Thanks,

Dan

Given Crew Macro Pack increases Alteryx's capability so much, and is used so pervasively, is there a reason to not include Crew Macro Pack in Alteryx Designer or Alteryx Server by default?

Can anyone give a reason why Alteryx wouldn't bundle Crew Macro Pack?

If not, can we get Crew Macro Pack bundled into Alteryx and have official support for it?

A user may need to perform regression test on their workflows when there is a version upgrade of Alteryx. To save users time and effort, users can be encouraged to submit a few workflows in a secure area of the Alteryx Gallery. Prior to a version release, the Alteryx product testing team can perform a regression test of these workflows using automation. Thus when users receive an upgraded version of Aleryx it is more robust and with the added assurance that the workflows they had submitted will continue to work without errors.  

I would like to request the ability to connect to a SharePoint List to bring data from and write data to via Windows Authentication.  Currently, the only way to connect to a SharePoint List is via username/password which does not work for our current environment.  

Hello,

When i build my workflows i often times have to save, close, and reopen just to see data flow through tools and check for errors.

It would be awesome if there was a validate button next to the run button so we dont have to go through all of this just to check for errors...

It would also be nice if we didnt need a button but the data automatically flowed through the tools to see compatibility automatically.

Nick

Our company got Alteryx server a few months ago, and we were surprised to find out that (at current setup) the members of my team can not collaborate on workflows published on our Server. 

What we would like to see  (How we envision being able to share workflows). 

With any published workflow on the server, be able to publish a workflow to a shared space and/or share owner permissions with or edit abilities to with another user. 

And

Allow another authorized user to download, edit, and update those workflows - keeping them current in someone's absence (Vacation or leave for a new job). 

Please build this functionality so we can get back to using Server instead of a shared folder on the network.

Thanks,

Randy

For deeply structured XML - it would be very helpful to be able to search XML (as you would using the DOM).     Even better would be to implement XML Query capability (a visual tool) within Alteryx so that XML data can be directly queried: https://en.wikipedia.org/wiki/XQuery

Hello all,

It would be awesome to see an obvious change to the Input Tool when you change the setting from Cached to Not Cached. Something simple so that as the process is running i can clearly see what that setting is opposed to having to stop the process and restart it.

Thoughts?

Nick

Request is to add in the parameter to control sampling level in the Google API connector. I'm getting very different results pulling the same report from the API and the GA UI. The API data has significantly more variability which is evidence of sampling. We have a premium 360 account and are still getting the sampling results, I believe its just necessary to add in the parameter in the outgoing script providing: 

samplingLevel= DEFAULT, FASTER, or HIGHER_PRECISION.

https://developers.google.com/analytics/devguides/reporting/core/v3/reference#sampling 

https://developers.google.com/analytics/devguides/reporting/core/v3/reference#samplingLevel

- Zach