Alteryx Designer Desktop Ideas

Hi All

I thought that this idea might be helpful for users who wanted to remove or trim specific characters without having to write regex formula or multiple replace formula, so I made some change to data cleansing macro tool and add some new feature that can be used for trimming or replace specific characters without having to spend time to write formula / multifield formula, just need to configure data cleansing tool and it's done 

For example, I trim the quote symbol without having to remove another symbol, or in case there's another quote in the data, Since I use the trim function, it won't remove the quote symbol inside the sentence too, only the quote symbol at the left and right of the sentence.

Also, it can be used to replace a specific word(like find and replace, but without having to create a dataset to replace the word) and can be used for multiple fields,  at the example below I replace NA to 0.

Cheers

Welly

Because Alteryx  Designer is using basic authentication (not our standards like Kereberos and NTLM), Alteryx Designer failed to pass our proxy authentication.  Our network security support decide we will use user agent to identify the request is coming from Alteryx Designer and let the authentication thru.  Then we realize Alteryx Designer also does not set the user agent for the HTTPS request.  We are requesting Alteryx set the user agent value for the download tool https request,

The Join tool is one of the most used in the Community. After delivering some training for new users (Not technical) I see that it's difficult for them understands some some Joins, specially when the relationship between  the Sources it's not 1:1.

So I propose to show the Summary visually, extending the Browse current information:

- List of Left Fields Joined / Excluded

- List of Right Fields Joined / Excluded

Also It should be convenient a tool to analyze the potential relationship between the sources, to be used previous to Join...

Thanks!

I've recently been delving into using the interface tools and there are a couple of glaring issues for me as a developer/designer, all having to do with the UI, ironically (yes, I used that correctly!) with the interface tools. The irony here is that the interface tools utilise a poor user interface.

Firstly, I finished this video to ensure I was indeed doing things correctly, and I was.

The UI for designer's interface tools is incredibly sluggish. In order to rearrange tools, each time you create a new one, you have to push the up arrow for each tool and you have to traverse the groupings.

This will take forever. I counted 36 clicks.

Instead of this, I suggest two changes to the interface designer.

1. 1. Allow a control-click in the interface designer layout view so that multiple elements can be selected and they can traverse the groupings and be moved together. When one has, say 4 elements in 2 nested groupings, that is a lot of clicks to get your new element to the top. Having to do it with its radio-button partner: pretty much infuriating.
2. ONE at a time, children. No control-clicking. That would lead to pandemonium?Allow control-click in the tree view as well. The fact that we can only click one item at a time and move it one slot at a time is incredibly time consuming. It seems a no-brainer to at least allow a control-click here.
   • Bonus: Include the ability to jump to the top and/or pop out a level with left/right arrows in the tree interface. 

I know not everyone is building macros/apps and dealing with this, so I have little faith that this will jump to the top of your queue. But this is a painful part of the UI. I don't know if your UX designers could easily fix this or if it is more pain on your end than the pain you're giving me, but I just want to say: This hurts. 35 clicks every time I add a new element with no option to 'move to top' like you (wonderfully) do in the select tool is a big drag on my time (hint: maybe add that sort of functionality too; the select tool manages this stuff so well!). Which is supposedly valuable. In theory. But it certainly doesn't feel that way when I've spent 10 minutes clicking an up arrow (and yes, my UI is slow. And I may be exaggerating, but not by much!). 

Thank you for your continued improvement!

-Çædric Justice
Alteryx Developer
Cambia Healthcare

After hitting "Test" in Workflow Dependencies:

Failed result = Bold red text (and a message)

Success result = Nothing? 

Maybe we could get bold green letting us know that the test completed successfully. 

Hello!  I use Alteryx for lots of spatial data blending, and 99% of the time that works perfectly.  However, when I try to analyze data in Puerto Rico or some other USA territories, Alteryx cannot read the data and I have to reproject it in another tool so it can.  Can support for all common projections be added to Alteryx so the data can be read in natively?  The GDAL Python code data file "gcs.csv" contains all of the projections I think would be needed.

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