community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the star in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

There is a need when visualizing in-Database workflows to be able to visualize sorted data. This sorting could be done 1 of 2 ways: In a browse tool, or as a stand-alone Sort tool. Either would address the need. Without such a tool being present, the only way to sort the data is to "Data Stream Out" and then visualize the data in Alteryx. However, this process violates the premise of the usefulness of the in-DB toolkit, which is to keep your data in-DB and process using the DB engine. Streaming out big data in order to add a sort is not efficient.

 

Granted, the in-DB processing doesn't care whether data is sorted or not. However, when attempting to find extreme values after an aggregation, or when trying to identify something as simple as whether null values are present in a field, then a sort becomes extremely useful, and a necessary tool for human consumption of data (regardless of the database's processing needs).

 

Thanks very much for hearing my idea!

In order to perform audit-trail logging - it would be valuable to have 2 new capabilities

 

a) environment variables which show the workflow name; filepath; version; run start date and time; etc.   For any worklows we build, we need to have a solid audit trail to be SOX compliant, so having this detail available as a data field to write and manipulate is essential

b) A logging component.   What would be great is a component that you can drop on a workflow, not connected to anything, which is able to trap the start; end; runtime; version; etc of a workflow; and commit this to any output data format (CSV or ODBC etc).   This logging tool would need to be able to capture the full runtime, so it would need to be the last thing that runs (which means it may need to exist in parallel to the main workflow in some way).    This is not currently possible with a complex workflow with outputs, because it's not possible to identify when the entire workflow ended; or the runtime (since output tools don't have an onward connector to pass flow-of-control to catch the final end-time)

 

Again, both of these are necessary to meet audit requirements for workflows and prodcution-quality ETLs for BI data warehouses.

it would  particularly interesting to develop a WMS support in Alteryx.
To include other Maps like bing, google, HERE instead of CloudMade to display geo informations.

 

Mathias

I really like the ability in 10.0 to turn on and off certain tool categories and specific tools within a category to keep your toolbar clean.

 

What would really take it to the next level is allowing users to manage them like bookmarks in a broswer - let me create new custom groups and add anything to them, or move tools among groups.

 

The favorites method lays the foundation for this, but is limited in that everthing is on one group.  Using the method I suggest, users could basically have groups of tools tailored to specific analytic tasks.

  • Tool Categories

Similar to the Select tool's Unknown Field Checkbox, I figured it would be useful for the Data Cleansing tool to have this functionality as well in order to avoid a scenario where after a cross-tab you have a new numeric field, one of which has a Null value, so you can't total up multiple fields because the Null value will prevent the addition from happening. If the Unknown Field box were checked off in the Data Cleansing tool then this problem would be avoided.

 Hello everyone,

 

Currently in Alteryx if a user uses a SELECT tool to rename a field name, and then have various different tools connected in a flow to this SELECT tool, the same field name is carried throughout. 

However, what if your project kept adapting to different needs and hence the field name in the SELECT tool had to be renamed again for some reason, this would cause all the linked tools in the workflow to break, especially if the previous field name is used in these tools. 

It would be great to allow the user to tell Alteryx to change all linked field names in the various linked tools to the new name or keep the old one.

 

I understand that Alteryx at the moment does not have this feature by default, in the case where the user renames a Field name, Alteryx does not want to automatically update all linked Field Names, especially if the renamed Field Name has already been used somewhere else in the workflow. However Alteryx should provide a warning that the renamed Field Name is a duplicate !

 

Matlab has a similar case wherein if a user changes the name of one variable, with a simple keyboard shortcut he can rename all other variables just simply.

 

Thanks

Blyton

 

In a future release, I'd love to see the whole concept of browsing for and installing new macros/apps brought into Designer itself.  It's always great finding new macros, but the expereince is inconsistent- sometimes you have to run an installer file, sometimes run a package, sometimes just put the file in a directory and add a 'watched macro' directory to your preferences.

 

I'd like to see a cleaner expereince where you can choose to 'Add Tools', browse the gallery, check the thing i want, and click the tools group I want to put it under, then have Alteryx take care of the rest.  There would also be the need for a 'Manage tools' screen where could could uncheck and remove them later if you no longer need them.

 

For inspiration, check out the way MS handles 'Adding Apps' via their catalog to build out your Sharepoint 2013+ site

The idea is simple and widespread in many products industry wide. Basically as you type it should recommend a list of appropriate functions/variables/constants based on what you've typed so far. While tab or enter can be hit to autocomlete.

 

Examples:

- Google has this in their search bar along with many other search tools

- Tableau has this in their calculated field box

In a browse tool, sometimes I need to check any metrics haven’t been lost or omitted in different summarise tools (eg the totals still add up with different group by).

I would LOVE the quick win of selecting some cells in the browse tool results pane, and a label somewhere shows me the sum, average, count, distinct count, etc. I hate to use the line but ... “a bit like Excel does”. They even alow a user to choose what metrics they want to show in the label by right clicking. 🙂

This improvement would save me having to export to Excel, check they add up just by selecting, and jumping back, or even worse getting my calculator out and punching the numbers in.

Jay

Today I have some workflows which have certain steps that occur after files are output.  I have these set up inside of Tool Containers so that I can easily enable/disable them as I am working if I do not want to produce output for this particular run.  However, sometimes if I need to troubleshoot on a workflow that I haven't worked on for awhile, I can neglect to disable these, which can cause errors.  This is usually harmless, but annoying.

 

Having two more options on Tool Containers could really help to improve this!

Disable When Browse Tools Disabled would be useful for any analysis/debugging steps that I only want to run when I am browsing to find data, but should not run otherwise.


Disable When Output Disabled would be really useful to ensure that these tools are turned off alongside the "Disable all tools that write output" option in Workflow-Configuration-Runtime.

 

This would save me a lot of unnecessary error messages and moments of panic, and would make these types of workflows easier for other users to debug without extensive notes.

A simple, very simple idea that can save a few clicks for everyone and that costs less than 1 hour of development :

Just display all the tool categories on a fresh install. There is not need at all to display only a few and that's the first thing I have to do on every fresh install.

  • Tool Categories

With the continued growth of Graph Databases, it would be nice for Alteryx to creates a new tool set that would allow input/output connectors for Graph Databases like Neo4j which software tools like Pentaho and Talend already have.

 

Keith. 

Hi,

Recently in Feb 2016, Australia released the geocoded national address file to the public for no extra cost and will continually update this each quarter.

 I think It would be a game changer to build this functionality natively into the alteryx product to enable any alteryx user simple access to it. also I think it would drive a lot of sales for the alteryx product.

 

http://www.data.gov.au/dataset/geocoded-national-address-file-g-naf

 

adrian

Hi, i am from ETL back ground and coming from my knowledge i would like to suggest or ask a feature which will helpful in alteryx solution.

 

"Error Line" : many ETL tools provide an "On Error" line which performs certain actions like "altering user by sending an email", "ignoring and going to next step" etc. It will be great if Alteryx can provide the same feature where we can have an error line (red line) for each tool.

 

Hope this is not a repeated idea. thank you for all the support and providing a wonderful tool.

 

Thanks,

Harika K

I would love the R tool editor to work like a standard text field....it might be better explained in this scenario.  Pretend the character text is a script youve written with the function being at the top.  Let's say you'd like to move the function closer to the script, look at the weird output.  This editor pastes text like we are pasting images.

 

The use case is that I like to break my code into mini functions that I work on in the r console with sample data.  Once it works, I post it into alteryx and experiment with it on a small sample, then a larger sample.  If I have to have a document for my overall r cost in notepad ++, my function, and the console, it’s a little nusance, especially since I usually have to go back and forth with multiple functions.  I am not askin for a full blown editor, I like my notepad ++ for that, just a text input that works conventionally. 

 

 

 

 

 

 

 

 

 

 

SampleFunction <- function(x)
{
print(x)
}

 

abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz

 

when you paste the function (or any other text in the middle, look at this funky output)

 

 

 

 

 

 

 

 

 

 

abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
SampleFunction <- function(x)abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
{abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
print(x)abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
}abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz
abcdefghijklmnopqrstuvwxyz abcdefghijklmnopqrstuvwxyz

I think that it would be nice to be able to append a Time Stamp to the name of a file in the OUTPUT Tool, as a Mainframe Programmer I could append a time stamp to file names this is helpful when doing batch jobs that are scduled on a server. 

It would be very helpful to have hidden/interactive labels that can be utilized for an Report Map that only appear when the user is hovering over a specific part of the map. For example they only want to see the sales numbers for California, but do want to change the map. It probably makes the most sense to have this available for the HTML Report Maps. This would allow the report map to not look too crowded with labels, but still have the labels available if the user is interested in a particular part of the map. Is this something that can eventually be added to the report map tool?

Hello! Almost all statistical softwares allow for the analyst to use either a pairwise or a listwise option when applying clustering techinques. This option affects only how the inner distance matrix is built, and after that whichever algorithm you choose is peformed. However in Alteryx [K-Centroids] by default does listwise, classifying only those records where the selected variables have no nulls.

 

Please consider adding this option!

 

PS: the difference is pairwise will build the distance between 2 variables depending on those records that have no nulls on both variables, while listwise will run the distance matrix after it has checked for complete non null records in all variables of interest (not one at a time distance calculation).

0 Stars

Hi - I miss the functionality in 9.5 of being able to set a default tool in a tab and then drag in tools from the tab. This seems to be gone in 10. Is there any possibility of it coming back?

Many thanks - Nathalie

  • Tool Categories
Top Starred Authors