Alteryx Designer Desktop Ideas

I would really like to see .dif files added as a file option to the output tool. Currently, I have to output as an excel file and then open the file and save as a .dif file format. Figure if Excel can save the file format, Alteryx should be able as well.

Thanks,

Hello all,

As you may know, Alteryx use the Active Query Builder component. However this component itself evolves with cool new features :
https://www.activequerybuilder.com/blog/2018-04-28-much-faster-visual-sql-query-building-in-the-new-...

You can also try the online demo

https://www.activequerybuilder.com/

Best regards,

Simon

FILE==>Open Recent==>

(add the ability to Pin Favorite Workflows)

The Pinned workflows will persist at the top of your recent files each time you open your Alteryx Designer Application.

Hi,

I am not sure if it is only me, but quite often, I am getting distracted. I believe I am not the only person bombarded by the amount of notification/ping on chat etc. That is the reason why quite often, I forgot what I am doing.

Let's imagine a scenario like this. I want to use the date-time parse function. First, I look at the data. I want to figure out what the format is, and I want to start writing a formula.

I know what format it is, and I am writing a formula in a formula tool. I remember the date was the first position but what was next? I got distracted. I don't know the original formula was structured.

Wouldn't it be cool to see the results from the previous tool still when working on the new one?

My workaround is to copy-paste pics into one note when I am working on something but I am not a big fan of a workaround like this 😀

Hello all,

Here is a very, very simple idea :

just having the right to put a minimum length to Text Pre-processing
Why ? A lot of words (especially in French) with 1 or 2 characters does not change the meaning, the sentiment: la, le, à, un, une, etc... In English : in, the, etc..

Best regards,

Simon

While it is good to have the test tool stop outputs based on tests, it isn't too insightful to users on the full details of these error messages. It would be more useful to have an output location for a test if these errors appear so that end users can troubleshoot instead of the workflow developer having to work through all of the error messaging.

There are workarounds for this that can be used, but they are often extensive and require the addition of significant logic. Adding optional outputs to the test tool would be a simple fix that could save a lot of hours of debugging when end users find an error.

Canvas settings can be used for providing more clarity and clutter-free look of complex workflows. For example, using Auto Route Perpendicular (where connection lines between tools are straight lines and break at 90 degrees and using different colours can really help in understanding workflow faster to someone who is looking at it for the first time. 

I know this is very subjective, but these additional customization settings can increase clarity in complex workflows. Especially when sharing workflow with others. 

The find and replace feature is great. Unfortunately, I was unpleasantly surprised to learn the hard way that workflow events are outside of its reach. Please expand to include the entire workflow to act on everything opening the xml in notepad could find and replace. The following demonstrates the omission...

On left side I search for the string “v022”

Below that shows zero matches

In the open event box near the center, “v022” appears in the command box

The occurrence in event command box should appear as a match, but does not.

Hi,

I am not sure why it is so complicated to troubleshoot formula tools in Alteryx. When I am getting an error with information parse error at char (char number) why we don't get this information highlighted in the configuration tool at the left. 

It should be crystal clear for the user where he needs to troubleshoot his workflow. We can say that the formula tool is showing us where the formula is working, so it isn't so bad.

When working with a multi formulas tool, it isn't easy to figure out where the mistake occurred.

Can we highlight somehow this specific character and make users life easier?

Hello all,

As of today, you can use the Dynamic Select Field with two options

-by types (you can dynamically select all, all date, etc..)
-by formula

I suggest 2 easy improvements

-from a list field. You connect a field list to a second entry with a "Field name" field
-from flow : You connect a flow to a second entry and the common fields are selected

Best regards,

Simon

Dear Alteryx Team, 

please put an option marker /button in the formula tool to ask if the newly added column should be placed at the beginning as first column or at the end (as it is now- this could be a default setting). 

The problem is that with a lot of fields it is quite time consuming to drag and drop the newly added column from the end of the field array to the beginning. Depending on where you want to reallocate the column you might want to start from the front or from the back to drag and drop (right click holded) the column in order to reorder it. 

Mostly I would like to start from the front, I noticed. 

Thank you

Very often, I used a container to make notes about certain parts of the workflow. Some of the comments that I created are pretty long. Could the user have the possibility to have at least rows for the title of the container?

I have created a screen to show what I have in mind. Potentially users could have the ability to turn this option on or inside the container?

So while first and last make sense concat will crash the system. Here's a screen grab... Designer really doesn't like crosstab reporting tools set (accidentally) to concatenate 3 macros deep in a workflow. Just crashed 3 times before I tracked down the error on my system.

As a change to Designer UI in 2021.2, when in the filter box, I used to be able to use my mouse to click a little X in the corner to clear the filter or sort that had been implemented and it would immediately clear the filter.  It's not working as of 2021.2.  Now, I must navigate to the last cascade to get to the word Clear and click on it to clear the filter. 

This feels like another very tiny move in the wrong direction. These small UI changes cause 2 or 3 additional steps and slow the diagnostic/navigation process in moving around the Results Grid in the Browse Tool or at any point in the flow where the Results Grid is used.

Can the X in the top level of the Filter/Sort box in the Results Grid be restored in 2021.2?

Related to submission:

Small fix for the UI in the Results Grid (or Browse Tool)

Small Keyboard fix for the browse tool's filter

As a change to Designer UI in 2021.2, when in the filter box, I used to be able to use my mouse to Paste in the value and then hit enter/apply to apply the filter.  It's not working as of 2021.2.  Now, if I hit paste from my mouse, it just closes the Filter box and applies nothing.  It forces me to have to change between mouse and keyboard as that is the only way to paste a value into the filter value box (CTRL-V). 

This feels like another very tiny move in the wrong direction. These small UI changes cause 2 or 3 additional steps and slow the diagnostic/navigation process in moving around the Results Grid in the Browse Tool or at any point in the flow where the Results Grid is used.

Can mouse functionality be restored in 2021.2?

Related to submission: 

from  patrick_digan

Table names seem very similar to named ranges in Excel. However, my workflow bombs when I try to read in a named table. Instead, I have to open the workbook, find the range of the table, and then type the range in the input tool. Alternatively, I could name the range that the table is in. However, I don't want to have a table name and a range name that are both referring to the same thing. So, I'd like to be able to read in a table I have in an excel workbook based on the name of the table. Does that make sense? Anything I can do to make the question clearer? Thank you!

Do put an option to take any distance.

it sure have case that we do not care the distance.

same go to other spatial tool have similar setting.

I will start off with a story. I have built a process to manage batch API requests. It's an iterative process that checks to see where the export is at by calling an API and then returning some status. It will run and wait and run and wait until the export is ready to be downloaded. However sometimes, the jobs don't finish and a status returns something like "failed" or "cancelled". When this is the case, I have my process (which is a little bit batch macro) kicks off an error message, using the nifty error message tool. After some time I noticed that it was a PAIN to go back and figure out which of my requests failed and I decided that I need to add some messaging around where this was failing, so I could do some easy auditing. So I go back into my tool and much to my chagrin, I cannot pass variables into the message section. I would expect it to have worked something like this:

"Record "+[#2]+" is not 'A'"

Can we please get a change to this. It would save a lot of time and energy if we could create a dynamic error message option.

TL;DR Please allow us to use formulas in the "If expression is true, display error message:" settings area.

Can we please have a Group By option added to Random % Sample tool? It would ease a lot of things!