Alteryx Designer Desktop Ideas

@RithiS ,

I'm a fan of using DETOUR tools in Alteryx.  I often place "test" code into a standard workflow and opt to use it or not based upon a detour.  The challenge is that adding a detour and detour end invariably leads to having to re-route connectors (default of adding tools is to connect to the left).  Here's a picture:

What I'd like to do is SELECT the tool or tools that I want to connect around (in this case, just the formula tool).  I'd like to right-click and DETOUR.  The detour and detour end would be added (putting the selected tools in the path of the RIGHT option.  This would greatly speed up the tool configuration process.

If you want to go for extra credit, you could modify the GUI to express which direction a detour is travelling in a standard workflow (e.g. make connections wireless or dashed when not selected).

Cheers,

Mark

@Claje @Hollingsworth @SeanAdams 

After I type something into the filter box, I should be able hit enter and then it just applies my change (ie enter hits the apply button). It used to be this way, but it's not working as of 2021.2. This feels like a very tiny move in the wrong direction. Currently enter does nothing. It looks like if I hit tab twice and then enter, it finds the apply button. I shouldn't have to hit tab twice. 

cc: @Hollingsworth @A11yKyle 

Using Email tool, you are not able to send email via SMTP server that uses STARTTLS protocol and self-signed certificate for completing the handshake between the client and the server. You face an error:

This is due to the fact that the Alteryx Designer SMTP client uses cURL and it does not read the Microsoft cert store, but instead looks at a specific .pem file listed in the installation directory: {AlteryxInstall}\bin\RuntimeData\Certificates\cacert.pem

I would really appreciate if Alteryx Designer will be able to look into the Microsoft certificates store so that it should be able to use self-signed certificates available there.

Self-signed certificates are often use in the companies in order to get more secures their own communications.

Thanks

please refer to the case #00447188 for more details

The ARIMA tool provides a ton of valuable information with just a small amount of effort.  And the "I" anchor efficiently outputs test results to evaluate the effectiveness of the model.

Annoyingly, in the Browse tool off the "I" anchor, test definitions such as MPE/MAPE/MASE cannot be read when hovering without widening the Configuration window beyond the chart above.   Definitions have a wider range than the chart itself.  The user has to manually widen and then subsequently unwiden the Configuration window to read.

Idea would be for the tooltips when hovering to be as wide as the chart above.  That would avoid repetitive resizing of the Configuration window.

When you enter a search term in the results window, it would be great if it highlighted that term in the data results window. Otherwise, it still takes work to find where your search term is located in each row.

The SQL compiler within the Input Tool places a space between operators causing a SQL syntax error.

Eg.

SELECT * FROM [DataSource] WHERE [Dimension] != 'abc'

Becomes

SELECT * FROM [DataSource] WHERE [Dimension] ! = 'abc'

The compiler should not add a space in this instance as it violates the syntax rules and triggers an error.

With all the talk of #TeamVertical and #TeamHorizonal an idea emerged for diagonal orientation. Now, it's a funny idea at first glance, but actually having the ability to control the general organization of a workflow could be very helpful. Imagine if there was a dot or arrow like in word that would enable us to tilt the canvas to fit our screens better. Like below, but leaving the text horizontal.

This solves the problem with the Left Join anchors moving to the top and instead allows anyone to rotate their workflow to what fits the case.

Thanks!!

#Team45Degrees

It would be nice to have 2 tier tool annotations.  

Tier 1 would be akin to an H1 title and serve as a condensed descriptive title the user creates.  

Tier 2 would be analogous to the current annotation option and provide a mechanism to provide specific details regarding the operation being performed by a specific tool (relative to the workflow).

The default might be to show Tier 1 and hide Tier 2.  A user would have the option to show all Tier 2 annotations or chose to show select Tier 2 annotations (much like the current annotation show/hide options).  An alternative option might be two depict Tier 2 as a hover over tool tip.  

Thoughts?

When Alteryx Designer detects an existing 32-bit Oracle driver on a user's machine, it displays an error message saying  that it requires a 64-bit driver.  If there is no driver at all installed, it will go ahead and install one. 

Can we get Alteryx to simply prompt the user to install the 64-bit driver instead of the 32-bit driver present error message? 

(I know they can co-exist since removing the 32-bit driver will cause Alteryx to install its own 64-bit driver after which one can re-install the 32-bit driver.)

Thanks!

D

Hello Team,

Currently, in the select tool, we have to scroll up or down to check or see the list of the fields. In case, if the user wanted to change the data type, they can scroll into the list. Like, I am working on the mid-size data, and sometimes data contain 300+ fields, if I need to change anything in the data type I have to search by scrolling up or down. 

The idea here is, If you provide a search bar under Field, it will be a great help to all, in case if anyone needs to go for some specific field, the user just types the name in the search bar and make changes quickly. The select tool is important and we used much time while working on the flow. 

Thank you,

Mayank

The interactive results pane is great, but wouldn't it be cool if you could interact directly with the result pane to do things like filtering.

There are a few too many steps with the method at the moment, where you need to either copy the value or type it into the filter pop up. A simple right click and filter on selected value would be a big ux improvement.

On the canvas, underneath the Run button, there are zoom out and zoom in buttons. It would be lovely if between them existed a number box indicating the current zoom level of the canvas. This would operate much like my web browser, which typically shows 100% unless I have zoomed in or out. Bonus points if the button is clickable to reset to the default zoom level.

Hi Team,

As the formula design that able to stack multiple formula in once. There should have more things there.

1. Error Icon for formula have Error

Can you find which row have error in seconds?

We had to count to find which formula had error!!!!

and how about now?

At least, do have an icon or anything significant thing that let us found it in second and WITHOUT COUNT!!!

2. buttons to expand all/ collapse all.

It was normal that we need to review formula in again in future.

So, you need to click one by by to view all the formulas?

Our company often builds applications where we need the ability for it to dynamically update dropdowns based on a user's previous selections. 

For example: 

• A user needs to select their Server, database, and table for analysis (3 dropdowns).
• When the user selects their server, a query is run to get a list of all databases on that server. Then the database dropdown will automatically populate with this list of databases. 
• The user then makes a database selection, and a query is then run to get all tables within that database. The table dropdown will automatically populate with this list of tables. 
• The user makes their table selection, and then runs their analysis using the server, database, and table variables with values that they have selected from each dropdown.

We can do this in other programs, but unfortunately the lack of dynamic selections/dependent dropdowns is a big limitation for us when building Alteryx applications. Our current workarounds are chaining applications together, or using PyQt within the workflow. Chaining is clunky and often causes unforeseen issues when uploading to Server with errors that are non-descriptive, and using PyQt comes with Python versioning issues. 

If this interactivity can somehow be added to Alteryx applications it would be a huge upgrade to our current Alteryx processes. Any suggestions for further workarounds would also be helpful!

Thank you, 

Amanda 

Hi team,

Currently, we can FILTER results in the result window using some string operations like "String equals", "String Contains", etc.

Firstly, it's a great feature. Kudos for the same.

However, it would be really helpful if we can add the IN operator functionality to this Result window FILTER.

Most of the time, we always want to check for multiple values while filtering the data.

I am attaching a screenshot of the FILTER location that I am referring to!

For eg, In the above screenshot of the result window, I want to filter for Name IN ('Bullock County','Baldwin County','Butler County')

Kindly look into this.

Thanks in advance.

Regards,

Shreyansh Rathod

Please consider making the Count Record tool configurable so that users can receive a visual read of results in canvas. This would quickly assist in ensuring a user's ability to verify a workflow is functioning as expected or not. Currently there is no in canvas visual cue tied to the counter. If a user is expecting a certain count result (e.g. zero), the user has to click on the count records function to see if the result meets expectations or not. Users may spend a lot of time checking each stage of a workflow to ensure everything is flowing appropriately. A visual cue of results would reduce that time to check. Outside of runtime errors, there is currently no visual cue to indicate a possible problem or unexpected exception to a filter or other macro.

Two suggestions:

1) Allow users to color code count results in specific count results or ranges. (e.g. if a user is expecting a zero count, allow them to change the color of the counter to red for anything not resulting in zero and green if count is zero). Or allow them to set a color range depending on the count total (e.g. a user may need some visual tolerance indicator with a count under 100 as green, 101-200 as yellow, 201-300 as orange and 300+ as red).

2) Show the actual count in the Count Record macro icon.

Thank you!

Would like to be able to connect to the Stibo STEP system/database as a Data Source. Some people have the Stibo server on-premise while others have it hosted in Amazon (AWS).

Not sure what else I could provide at this point for further details.

Hello Alteryx Gurus - 

I've got some workflows that run daily, but there are times, depending on the breaks, wherein I don't get any data from one of my data sources.  Which is actually fine, nobody did Job X today.  But it makes Alteryx puke out and I get an error message emailed to me.  Ultimately, I've got to hop into the rather voluminous log entries to determine if this was a data stream not initialized / was empty error, or something else that I actually need to care about. 

That being said, in the coding realm, it is relatively simple to look for specific flavors of exceptions and then just eat them without notifying people.  So, why not add something to the runtime / events panel for emailing at error time to allow for ignoring data stream not initialized errors?  In this way, I could get notified when there is a real error I need to pay attention to, and not get notified when there is no new data, which isn't really that big a deal.  

Thank you for attending my TED talk on enhanced error reporting and exception classification capabilities.