Alteryx Designer Desktop Ideas

Have you ever used a Join tool with several (or many) Join fields, looked at the the L and R outputs and wondered, why didn't these records join? When there are many columns in your data, this can be a hard question to answer. It would be very handy if Alteryx could somehow report the Field(s) that each record failed to join on (perhaps as an optional added field to the L and R outputs).

In every application, be it in Designer or on the Server product, please make version number easily available in Help --> About and make it copy-able so that we can quickly copy-paste it when submitting a case.

Currently, the Server product does not even have a menu item to quickly be able to see what exact version number it is on.

The Alteryx Python tool currently throws an error if the inbound record set has zero rows (screenshot 1).

In order to manage that - you need to create try-except block around the Alteryx.read that instead creates an empty record set data frame. (screenshot 2).   This is inefficient because every time you change the canvas before the python tool, you need to re-code a static field list into the try-except block (i.e. you can no-longer deal with variable fields)

Please could you change the Alteryx.read method to create a zero-record dataframe with the correct column names if the input is zero-length?

Thank you

Sean

Screenshot 1:

Screenshot 2:

I'm digging the new holistic data view in the browse; however, there is one aspect of the old view that I miss: I liked the list of top values to be available without scrolling. Here is the current view of the new browse:

What are my top values? I either need to hover over the blue bars, or scroll down to see the list at the bottom. I would like the top values list moved to the top. For reference, here is what the old view looked like:

My top values are available right there at the top.

When I use the rectangular lasso to select some tools and/or control click them, I want to see a count of selected tools please.

IMO, Alteryx should bring new hot keys into newer version:

1. Search for tools, help, and resources

2. Search for Result windows: This is extremely wanted coz I always have to check, recheck results so it's so annoying to non-stop moving the mouse cursor to different positions

When a user adds a column in the Formula tool, show the data type directly underneath the column name, not below the expression. It's important for the user to set the data type and then build the expression. Otherwise, the user neglects to and then minutes or hours later sees strange behaviour as a result of having the default V_WString. Make the data type prominent because it is important and part of the metadata.

The only thing I have ever found that Excel can do that Alteryx can't is creating a pivot table that allows the user to drill up and down levels of aggregation by collapsing or expanding levels in the data hierarchy. (like this). 

Can you add an interactive table to the new interactive charting tool that can provide this level of functionality? It's embarrassing to have to tell Excel users they can't do this in Alteyrx, and likely leads many of them to stick to Excel--and miss out on all the other great things Alteryx can do.

Thank you! 

As reported in this post, I would suggest to only add new browse tools to outputs that do not have a browse tool attached already when using the "Add All Browse" feature.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Undesired-behavior-using-the-quot-Add-...

Thank you!

Alteryx should support horizontal scrolling!!!! urgently

My PC has Windows Precision touchpad (which might be a standard today), I can use 2 fingers to scroll up/down but moving left/right in Alteryx is another story, it's just impossible. That's extremely annoying when the licence cost for a user is so high. 

Hi Alteryx team,

Not sure if this is a Designer or Connect idea but the idea is to allow more options when searching in Connect from the Designer interface. As of now, it seems that it is only possible to search for tables and views, or generally those objects which can be added as an input data tool.

I believe that search directly from Designer is a great feature and at least our clients use it more and more. Would it be also possible to find workflows within Connect catalogue and open these workflows in Designer?

This could also apply to other data assets within the Data sources section like APIs, procedures etc.

Thank you

Michal

Hi, I would like the ability to hover over a point/polygon on a Browse tool that displays geospatial data and be provided with some information on the data that isn’t currently offered.  Namely, I would like the ability to hover over a point/centroid and have a bubble (a.k.a. tool tip) pop up displaying the exact coordinates of that datum, the row ID and some other unique identifying information (e.g. name, store number, etc).  Other geospatial tools provide this functionality.  See below:

Google Maps:

Alteryx:

And by the way, I realize Alteryx is not Google Maps, but as a data “consumer” or “interactor”, I think it’s just human nature for people to want them to “feel” the same.  Something to strive for, at least.

I would also like the ability to click a datum displayed on the browse tool and have it highlight the row on the Results pane.  The clicking functionality works going from the Results pane to the Browse tool, but not the other way.

Thanks!  Kurt

Unlike 'Multi-row formula' tool, the 'Multi-field formula' tool's expression textbox doesn't word wrap. Please see below picture that shows how each behaves respectively.

Wouldn't it be better to make the 'Multi-Field formula' tool to behave the same for both consistency and ease of use?

Thanks,

Simha

The desginer autosave feature is fantastic when you need it. However, it's pretty annoying when you don't need it as it seems like it:

• Autosaves blank workflows
• Autosaves workflows that are saved and haven't had any changes made to them

Hopefully all of the above can be filtered out from Autosave: 

The only workflow from the screenshot above that I'd want Autosaved would be the Parse Directory workflow as this is the only one which I made changes to:

- New Workflow1 - Completely blank

- PureGym Log In - Saved and no changes made

- New Workflow2 - Completely blank (however, I had dragged a tool onto canvas and deleted it, so something had changed)

However, Alteryx brings up all of the workflows:

I love the new right click and duplicate workflow feature, but I think the duplicated workflow that opens, should open next to the original workflow and not at the end of all of your already open workflow tabs...

cc: @jpoz @jeffv 

Adobe analytics api current version is 2.0 but the connector still uses 1.4. This works for log in access but does not for automated access since the end points are changed and 2.0 uses a new key structure

Sometimes I want to copy just the Name and Type fields from the metadata in the Results window. Even when selecting this option, however, all 5 available fields still get copied and pasted. I would like to see this change to work as expected and only copy those cells selected.

Copy only the first two columns

All of them get pasted

Cc @DultonM 

It would be really usefull if we could invert the sequencial color scale when using pie charts. For example, there are times where the greater the number is, I need it to be more red. Sometimes, I need the oposite behaviour, higher numbers having less red. 

I didn't know I want the Excel "Select a range (cells, rows or columsn" feature before it dropped, but now that we have it, it's time to make it  awesome.

There are two things that really need to improve to make this tool awesome:

1) Allow to fill out only one parameter

The typical use case for this tool should look like this. You have some unnecessary header rows and columns -> the data is shifted.

We want to build a flow that only selects our data columns in the middle, but the length of these columns can change, so it's a BIG NO to select just a range from D4 to G13. Nobody knows if the next report will have the same length. We can't risk to cut-off the last rows.

This is also import for the output feature. We usually don't know if we'll write 10, 20 or hundreds of data rows. To make this feature useable, we really need to be able to specify just one cell. The cell range is a nice on top feature, but it shouldn't be the requirement.

I also see an option for something like D4:G. This would be a syntax with two fields, but the G doesn't need a number and therefore says "till data ends".

In the current state of the tool, it's better to use 'Start data Import on row' + Select tool to achieve the needed behavior. 

2) Improve usability

I see multiple ways to improve the usability of this feature. I will start with the most simple way (for the dev team) and follow up with more complex. The problem is always the same: How do we know the exact position of the cells without opening it?

2.1) Add an additional row on top of the header row

The easiest possible way is to add an row above "Header F2 F3 ..." with A, B, C ...

This really helps to pick the right one.

2.2) "Select tool" inside the preview

I could imagine a feature where we can select the wanted cells and add them to the Query. The best way is probably an auto hover like word has it. See below.

When you select a text and wait a second, it automatically pops up some options to edit the text. Another option would be a simple right click.

2.3) Show Excel Button

Time to step up the quality with an additional button inside the Input Tool. The Show Excel Button opens the Excel file with a temporary window to help you select the right cells.

2.4 Select In Excel Button

This is probably the most advanced solution. Open the file (same as in the step before) and allow to select the ranges directly inside the file and throw the selected range inside the original config windows. It's probably the most difficult solution for the problem, but let me dream for a moment.