Alteryx Designer Desktop Ideas

With the new keyboard shortcuts in 2021.1, I would love to see this same functionality added to the global search. I would like for

1) The global search bar to be accessible via a keyboard shortcut

2) You can navigate through the results with the arrow keys and

3) I can click enter on a tool and it will add it to the canvas just like the tool palette now functions in 21.1.

cc: @A11yKyle 

Hi,

Can we get this list updated?

https://community.alteryx.com/t5/Videos/Video-Training-Index/td-p/45161

I think it is one of the most interesting sources of knowledge on Alteryx community but unfortunately, it wasn't updated for the last year. 

It is possible that new sessions will be added here?

When outputting data to a spreadsheet, the default option is "output to a new sheet". The second time you run your process, you get an error unless you are amazing enough to remember to change the output option to "overwrite sheet".

If you change to "overwrite sheet" for the first run, it actually works just fine and creates the new sheet. 

Can Alteryx just eliminate the "output to a new sheet option" so that users will no longer be concerned that "Alteryx doesn't work" when they get this error after creating their first process? And the rest of us will be able to save the run time with an error, then the change of the option?

Thanks!

Cleanse Macro

Given a choice between the delivered macro and the CReW macro, I’ll choose the CReW macro for both speed and functionality.  Wikipedia says, “Data cleansing or data cleaning is the process of detecting and correcting (or removing) corrupt or inaccurate records from a record set, table, or database and refers to identifying incomplete, incorrect, inaccurate or irrelevant parts of the data and then replacing, modifying, or deleting the dirty or coarse data.”  If Alteryx were to convert the macro to a true tool, here is my feature request list:

Performance:

• AMP compatible – Fast!
• Faster than the CReW macro for deleting empty fields/rows
• Resolve time it takes to load the tool (current macro versions are slow), html is faster.

Feature Enhancement:

• Allow selection of fields based on data type
• Include incoming/outgoing SELECT functionality
• Allow for PREFIX functionality (like multi-field formula), but NOT default
• Read incoming metadata to provide color coding of fields to indicate where potential problems exist (e.g. NULL, Whitespace) – part of browse everywhere currently
• Allow for Nulls to convert to 0/blank or 0/blank to convert to Null
• When removing punctuation, provide for exceptions (e.g. Numeric set of negative, comma and period).
• Include HTML tag removal
• Support internationalization (character sets)

Going the extra mile:

• Display or opt for output, cleanup metrics.  How dirty was my data?  Potentially, allow for ERROR to stop workflow if garbage is detected.
• Optional:  Detect outliers in numeric data.  I’ve got an outlier detection macro that we can review, but while you are passing all of the data for numeric values, explaining or tagging outliers would be useful.  Could be a box-whisker on numeric values maybe?
  • Make outlier actionable
    • Identify in data (new field indicator)
    • Remove
    • Modify/Impute
  • Test/Preview against metadata:  (pre-run), see what the incoming/outgoing results would be on *all of the metadata before I run the workflow.
  • camelCase:  https://en.wikipedia.org/wiki/Camel_case
  • Identify/Replace unknown values (e.g. N/A, Not Applicable, #) with Null() or other?
  • Identify/Remove duplicate values within a cell
  • See also:  https://en.wikipedia.org/wiki/Data_cleansing
  • Option to point to a “personal” dictionary for spelling or validation
  • Provide “smart” annotation on tool

It would be great if Tool Containers had an I/O connector icon where you can connect the last tool in that container to and then Cache the container so that it wouldn't have to run every time.

For example, in the diagram below, the output of the Spatial Match would connect to an object such as the "I" that I drew below. We would then be able to cache the output of that container so that all objects in the container wouldn't have to run each time. The "O" would be the cached output and would feed the rest of the workflow. 

The data view of any anchor is searchable. I want to search the metadata view please.

Currently Alteryx supports floating windows for some of the windows. But I would like to open multiple workflow at the same time. It is good for multiple display since I can view 2 workflows at once, 1 for main development and 1 just for testing a small part before putting in the main workflow.

Need a way to highlight lines whether that means right-clicking and selecting a color or what-not, but just having the lines become black & BOLD doesn't cut it. It's not easy on the eyes. If I could click this line/connector and make it bright green that would be ideal and then I can see where it connects better when zooming out.

I would like to lasso or select multiple tools and have a count of selected tools. Perhaps this count could be in a tool tip or somewhere else.

The option to "Disable all Tools that Write Output" doesn't currently affect the Publish to Tableau Server output tool.

I would like to propose an idea for the evolution of INPUT TOOLS and OUTPUT TOOLS in relation to their compatibility with DATA CONNECTIONS configured in Settings ALTERYX.

Indeed, it is now possible to create a Data Connection of SQL Bulk Loader (SSVB) type and to use this DATA CONNECTION in an Input Tool. The configuration is possible (Choose the table, the query ...), when you run the Workflows it works and you get the data well.

On the other hand, when we try to click again on the INPUT Tools, there is an error message and we cannot retrieve the contained request because the File Format is unknown.

After analysis with the support, there is a compatibility problem between SSVB and INPUT Tools in ALTERYX because there is no support for SSVB in INPUT in ALTERYX but it is supported in OUTPUT Tool.

My proposal would therefore be that there be a validation made during the configuration of the INPUT Tool and the Output Tool between the DATA Connection chosen and the type of tool used.

Thnaks for your return.

Regards,

Psyrio

I would like to propose a more interactive results window.  The reason is that if you click on any of the tool hyperlinks next to the messages while the output is compiling, you get trapped inside that tool's output for the entire time that the workflow runs.  You do not get to see any additional workflow result/detail as it compiles until after the entire workflow is run. It would be great if a user could escape back to the main workflow's results.

For instance if I am running a fairly long or complex workflow that does not all fit on one screen...I may want to zoom in on a tool if it has a warning or error before the workflow finishes.  By clicking on the hyperlink "Union(5)" the palette will zoom to Union (5) so I can see which tool is a problem.

I can see any messages attached to Union(5), however I am stuck with this view the rest of the time the workflow runs.  Clicking on the canvas (or really any other action I try to take) does not take me back to the overall workflow result window.

Granted if I have an error I may want to stop the workflow altogether, but sometimes warnings may prompt further investigation once the workflow is run and I may want to get an immediate read on where in the workflow the problem is while it is still running...which inputs might I have to check etc.

When I select multiple containers using control. I can see the configuration pane still on the left. If I adjust anything there it will only adjust the last selected container. I would like it to adjust all selected containers.

I guess it's better if the current column filter feature would cover the entire data set not just the partial results. This would be useful especially if after you run the complicated workflow and you just want to test the data particular nodes in the canvass. 

DearAlteryx team and community,

all the best for 2021!

Thank you very much for enhancing the output option from Alteryx Designer to Excel keeping the format.

For a lot of my use cases this is very helpful!

Still, there are some use cases left. In case I want to overwrite a calculated/linked number (e.g. calculated prediction) with the Actual number, it would be very helpful to feed into those cells as well. At the moment Alteryx is doing the job but I receive a lot of Excel Errors (xml errors) and a corupt Excel file when overwriting calculated fields/linked fields.

Is there a chance to extend the current setup for all of those cases?

Thanks and best regards

Chhristoph

All,

I'd like to be able to disable the notification to update Alteryx toward the top of the screen.  The longest choice is only one year...I'd like to turn it off forever, since we control versions used internally and it is driven by the server version.

Folks are updating their software when they shouldn't and causing issues for each other.

Thanks for any advice.

Today the Autofield tool transforms the fields into byte by default when it considers that the content is suitable while we expect text in it and that it can simply be a field not filled in in the context current but which may be later.

The idea would be to be able to choose which type by default to implement on text or empty fields and not the default byte because a byte field is not recognized on a formula using an IN for example which can produce errors in the following workflows.

Hello,

My idea is that the current Download tool does not handle errors and continues its path even if it does not find for example a file in the transmitted URL or if it does not find the hostname it crashes.

In the case of a user with several URLs in a row, this is penalizing.

In the case of downloading files with recording, it still writes a file (thus overwriting the existing file) but which is not openable and is not in the correct format. (BLOCKED file!) Which then causes problems in workflows reading these files.

The idea would be to put a second output to this tool for all the URLs where there was a problem (non-existent hostname, file not found, HTTP KO) and one where it received the expected elements so as not to prejudice the processing. and allow better management of error cases.

Regards,

Bruno

Yes.  I'll admit it.  I have set up email events and forgot to enter my address into the 'to' field.  The upshot is that an error was occurring in my workflow, the tool went to email me, and then double borked because I hadn't filled in a recipient. 

Lots of tools error out without appropriate configuration applied, it shouldn't be too difficult to get this working on the events panel also. 

Thank you for attending my TED talk on improvements to the Events pane.