Alteryx Designer Desktop Ideas

Hi All,

Issue: 

When input <List of Sheet Names>, Alteryx will assign data type and size accordingly.

Example: 

It become a problem, when input with multiple files with wildcard (Input file Book*xlsx).

It will be skipped due to "has a different schema than the 1st file in the set and will be skipped"

Solution:

Very simple, always same data type and size, like in formula tool. V_Wstring, with size 1073741823.

I want to jump to expression #3 of formula (3), when I see following error message. Now I can jump to formula (3), but only expression #1 is opened, not #3. If I have 30 expressions, it is hard to find #20 in 30s.

Instead of using the arrows, I think it would be nice to be able to drag and drop the questions to rearrange them in the Interface Designer. This would go more hand in hand with the drag and drop experience of Alteryx.

Additionally, when a lot of interface tools are on the canvas, Designer really slows down if you need to rearrange the order of the tools in the Interface Designer. I would like to see if there is any way that this can be sped up.

Thanks!

Dear Community,

could you please change the path processing of the alteryx app interface so that we can paste path links with quotation marks without getting an error by the alteryx app?

this would enhance workflow speed because one cannot save folder location for the interface to search for first when browsing files. it always begins at the pc level or something. 

so the workaround would be to just paste the file location path in the browser window of the interface, then pressing browse again to just scroll through the wished folder. 

this idea is not only for the purpose of the workaround but also for itself worth it. 

in windows one can easily copy file paths by holding down shift and right mouse click and the clicking on "copy path" . the copy is in the clipboard which i would like to pass to the alteryx app just like this without the necessity to remove the quotation marks as this costs time and is difficult when paths are long. 

thank you

@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