cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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

I'd like to hold CTRL, click on a tool and drag it to somewhere else on the canvas to copy it. 

 

This is functionality common in other software (e.g. Tableau, MS Office). 

 

Currently I have to either:

right click > Copy, right click > Paste, or

Ctrl + C, Ctrl + V. 

 

 

A recent post solution (https://community.alteryx.com/t5/Data-Preparation-Blending/Can-somebody-tell-me-where-is-quot-Choose...) by @patrick_digan alerted me to a loss of functionality of the Input Tool.  In order to define a range of data via SQL to Excel (e.g. Sheet3$A1:C10) you need to know a work-around instead of just modifying the SQL.  The work-around is to modify the XML.  I would like to see that functionality returned to the Input tool.

 

Cheers,

Mark

I superimposed multiple screens and multiple workflows and rendered them into a single image below. Have you noticed something?

 

Picture1.png

 

 There is a space never being used at all times, painted in yellow for emphasizing...

Picture2.png

 

 

Actually this is an enough space for ads Smiley Happy And we can make the designer for free...

Picture3.png

 

Though I suggest a better placement and use of the available screen space;

Picture4.png

 

 

 

 

 

The SQL Editor window could have a better presentation of the SQL code; two issues observed

  • First, that it's simply plain text without even a fixed-width font, much less syntax highlighting
  • Second, if you type in some manually formatted SQL code (e.g. with line feeds and indentation), then click on the "Visual Query Builder" button, then click back to the "SQL Editor" button, all the formatting is lost as it is converted to one run-on line of code, which is very difficult to read.

I understand that going between the Visual Query Builder and the SQL Editor is bound to have some issues; nonetheless the "idea" is to allow a user friendly display in the SQL Editor window:

My "implementation ideas" are based on a couple minutes with google, so hopefully this is a very feasible request; my user base is very likely to spend more time in the SQL editor than not, so this would be a valuable UX addition.  Thanks!

 

Alteryx has the ability to connect to data sources using fat clients and ODBC but not JDBC.  If the ability to use JDBC could be added to the product it could remove the need to install fat clients.

Speed up canvas edits - The Create/Remove Space Tool

 

Usually day two of working with a canvas I realize that I have been a fool, and I come up with a significantly more elegant or simple solution.  Moving all of the containers or tools to fit my slick new container is cumbersome and slow.  I've created a GIF of a feature several tools have which allows the user to easily move and arrange items on the canvas.

 

Open source tool used in demo: bpmnJs

 

 

giphy.gif

 

 

 

 

When moving a tool container, all of the tools within it become mis-aligned with the canvas grid.  Moving any single tool immediately re-aligns it to the grid, which puts it out of alignment with the rest of the tools in the container.

 

Example:  Put 3 tools in a row in a tool container, all aligned horizontally.  Next, move the container.  Now, move the middle tool, then try to place it back in alignment with the other two.  You won't be able to, because they are out of alignment with the canvas grid.

 

Please fix this.  

The DateTime tool is a great way to convert various string arrangements into a Date/Time field type. However, this tool has two simple, but annoying, shortcomings :

 

  1. Convert Multiple Fields: Each DateTime tool only lets you convert one field. Many Alteryx tools (MultiField, Auto Field, etc.) allow you to choose what field(s) are affected by the tool.  If I have a database with a large number of string fields all with the same format (such as MM/DD/YYYY), I should be able to use one DateTime tool to convert them all!
  2. Overwrite Existing Field: The DateTime tool always creates a new field that contains your converted date/time. I ALWAYS have to delete the original string field that was converted and rename the newly created date/time field to match the original string field's name. A simple checkbox (like the "output imputed values as a separate field" checkbox in the Imputation tool) could give the flexibility of choosing to  have a separate field (like how it is now) or overwrite the string field with the converted date/time field (keeping the name the same).

Alteryx is overall an amazing data blending software. I recognize that both of these shortcomings can be worked around with combinations of other Alteryx tools (or LOTS of DateTime tools), but the simplicity of these missing features demonstrates to me that this data blending tool is not sufficiently developed. These enhancements can greatly improve the efficiency of date handling in Alteryx.

 

STAR this post if you dislike the inflexibility of the DateTime tool! Thank you!

A question has been coming up from several users at my workplace about allowing a column description to display in the Visual Query Builder instead of or along with the column name. 

 

The column names in our database are based on an older naming convention, and sometimes the names aren't that easy to understand. We do see that (if a column does have a column description in metadata) it shows when hovering over the particular column; however, the consensus is that we'd like to reverse this and have the column description displayed with the column name shown on hover. 

 

It would be a huge increase to efficiency and workflow development if this could be implemented.

This is fairly simple/minor capability, but I do think it would save some time. Especially when developing back and forth between different layers of an Alteryx Environment.

 

Best,

dK

The Undo button in Alteryx has saved me many times! Unfortunately, I never know what all was "undone" when I click the button. It would be nice to update the Undo process in 2 ways:

  • Replicate the Excel undo drop down (which includes a brief description of what will be undone and allows you to undo multiple actions at once).

Undo.PNG

  • Move your location on the canvas to the area affected by the Undo-ing. Currently your location on the canvas doesn't change when you press Undo, even if the change being undone was off screen.

 

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

It would be great if Alteryx allowed users to copy and paste data directly from excel into the workflow canvas as a text input. Sometimes I create quick mapping tables in excel that I do not want to save on my desktop or shared drive as it is a quick fix or solution. Tableau allows users to copy and paste data sets directly into a sheet for use. Can we make this happen??

 

Yours Truly,

 

Trevor

 

One of the tools that I use the most is the SELECT tool because I normally get large data sets with fields that I won't be using for a specific analysis or with fields that need re-naming. In the same way, sometimes Alteryx will mark a field in a different type than the one I need (e.g. date field as string). That's when the SELECT comes in handy.

 

However, often times when dealing with multiple sources and having many SELECT tools on your canvas can make the workflow look a little "crowded". Not to mention adding extra tools that will need later explanation when presenting/sharing your canvas with others. That is why my suggestion is to give the CONNECTION tool "more power" by offering some of the functionality found in the SELECT tool.

 
Select Tool 2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

For instance, if one of the most used features of the SELECT tool is to choose the fields that will move through the workflow, then may be we can make that feature available in the CONNECTION tool. Similarly, if one of the most used features (by Alteryx users) is to re-name fields or change the field type, then may be we can make that available in the CONNECTION tool as well.

 

Select Tool.png

 

At the end, developers can benefit from speeding up workflow development processes and end-users will benefit by having cleaner workflows presented to them, which always help to get the message across.

 

 

What do you guys think? Any of you feel the same? Leave your comments below.

 

I'm sure no one want's to do double dipping on huge data sets even if it's in-db...

So can we have,left and right joins in the in-db join tool as well to further develop workflows from these two additional outputs?

Ps: the idea originally belongs to another Alteryx client mentioned this in IT central; https://www.itcentralstation.com/product_reviews/alteryx-review-38876-by-prometheus-tito-amoguis-ii

 

Picture1.png

Best

Hi,

     I would like to see Global Variable being made available in Alteryx. I have seen the Global Constant being made available under Workflow "User" configuration. But this is constant and needs to be defined at Design time.

How about a Process Id that needs to be auto genearted and the same needs to be available across the formula tools used with in the workflow.

Please add Parquet data format (https://parquet.apache.org/) as read-write option for Alteryx.

 

Apache Parquet is a columnar storage format available to any project in the Hadoop ecosystem, regardless of the choice of data processing framework, data model or programming language.

 

Thank you.

 

Regards,

Cristian.

Hi Alteryx Team,

My work is to create Output from Alteryx and upload the Output file into Tibco Spotfire. So i want a system in which Alteryx output directly goes in to the Tibco Spotfire and update Tibco Spotfire in every 6 hours.
So do you have any plan to connect the Alteryx with Tibco Spotfire? This is will help me to automate the project.
If not pls think on these concept for future use.

Alteryx needs to package SAP, JD Edwards and ADNIS and BPCS connectors as part of it's native offering. This will increase the value proposition of Alteryx designer from just data blending to full self service ETL. Most of the large organizations have data extraction challenges and will experience business user empowerment and big productivity gains if native connectors and data extraction across major ERPs is enabled. Some of these productivity gains can in turn be used to make a business case for Alteryx designer licenses.

Configurable hotkeys/keyboard shortcuts would be awesome.  For instance, select/deselect highlighted fields or remove prefix are two commands that I use frequenctly but which are buried in menus.

Being able to assign hotkeys to favourite tools would be another time saver.  Imagine, ctrl-alt-F and a formula appears under the cursor!
Top Starred Authors