Alteryx Designer Desktop Ideas

Can you add an ExceptionHandler to the Tile Tool? The tool crashed on a large dataset.  I got an Error: Tile (1): No values found before GetMean() on the tile tool. I selected Smart Tile option on the ‘unique_zips_count’ field and grouped by ‘ID’.
To track the problem down, I had to use the sample tool to grab x number of recs and see if it would run through the Tile tool. I had to keep skipping and selecting first N recs until I narrowed the problem down to 20 records. As it turned out. all values were 0 in a specific group. I found a workaround by pulling all recs per group with a value of 0 and bypassing these with the Tile tool. Instead of doing that - could you add an ExceptionHandler and specify which RecNo it crashed on?

Can you also add option to use 1, 2, or 3 std dev in addition to smart? This way all my groups will be uniform.
  

I think there should be a tool that allows you to produce grand totals for any numeric field you want. In the tool, you should be able to check off the fields you wish to be totaled at the bottom. I prefer this over having to use the summary tool and then using the union tool to produce totals at the bottom of my output. 

Hey Alteryx Devs - 

 

Simple fix that would keep me in the flow sometimes, is if I could hit F2 and get to a place where I could tweaky tweaky the annotation.  I keep on finding myself hitting F2 and then am annoyed that I have all these extra clicks to annotate meaningfully.  Easy fix and you don't have anything else attached to F2.  

 

Thanks!

brian

 

edit:  Had wrench palette, needed pencil palette!

Hi, I've seen some requests lately where the users are requesting maps in  EPS (Encapsulated PostScript) format, which is an

Adobe Illustrator file type. If this could be added as a Report Render output type, along with BMP, it would make the tool even more useful. Thanks!

Problem:

Currently, the scheduling via designer controller is independent of the gallery. So, even after a canvas is deleted, the scheduler still continues to execute the cached version of the canvas, as long as the scheduler exists.

Note, this issue does not occur when the canvas is directly scheduled in the gallery, and only occurs when you schedule via the Designer on the controller directly.

 

Steps to replicate issue:

1) Publish a canvas into gallery

2)Schedule the canvas to run daily via the Designer --> Options --> View Schedules --> Select Controller --> Create new workflow and schedule

3) Delete the canvas from gallery

4) You will notice that the canvas is still getting run on the defined schedule, even though you have deleted the canvas

 

Observed in Alteryx 11.5.1

 

Idea Recommendation:

Golden copy of a canvas should be the version existing in the gallery. Once the gallery instance of the canvas is deleted/replaced with a new version,

• All related artifacts to the old version should be marked as "Deleted"
• All existing schedules should be stopped from being executed
• We should continue to retain all meta data attributes and execution history related to the old version (should not be wiped out) but clearly marked as archived/deleted

 

@SeanAdams @LizaNemchynova

 

Instead of counting the number of occurrences of the delimiter and then specifying it is there a way to split column for:

1. Every occurrence of the specified delimiter?

2. Only the last occurrence

3. Only the first occurrence

 

Thanks,

I'm using .sv file format for compressing large files and using them in Alteryx.  .sv is call a Alteryx Spatial Zip file.  This format seems to offer the highest level of compression of all the Alteryx file format types.  Is this suitable for text also?  Is it usable in real time vs uncompressing first then using in a workflow?  If not, I think a compressed real time file format would be a nice addition.

I love the new Basic Filter option and it makes writing filters easy/self-expanatory for new users and helps with functions like isnull(). However, I'm almost always writing what are now called 'Custom Filters' and it takes two clicks to do this.

From a User Experience perspective it would be great if you could click in the expression box to write the filter rather than having to check the customer filter check box, or start by creating a basic filter and then make it more complex using the custom filter box without having to check the tick box.

Following on from this and something that is probably a lot harder to implement - But with the new basic filter, it would be great to have a list of available fields populate the options to filter by - Similar to the option that you get in Calgary. E.g Country == and then the drop down list would contain whatever is available in the data (e.g. Spain, UK, USA, Etc...)

Can an interactive mapping tool be added as an output tool? 

When reports, files, or tables are generated, it would help to be able to view them on an interactive map.  Currently I am trying to show where high population growth is located for large areas, ie-entire US, entire State(s), etc., so the user needs to view where these areas are on a map.  Ideally, it would be nice to have additional layers seen on the map as well, for example, our current locations, competitor locations, etc.

I've added a table tool that also has the bar graph enabled. The data I'm basing the bar graph off of is set to 5 decimal precision, but the bars round to the nearest whole number, making the feature essentially pointless in my scenario. Is there a way to have the bars dynamically adjust to the amount of decimal precision? I'm guessing most folks are exporting their data to a viz tool and not many folks are using the table tool in this context. 

In the Table/Query edit window, the datatable "frame" needs to do a better job of vertically autosizing to the window - it overruns the vertical space and then, if you have a lot of fields in your table and you want to see and/or select the fields in the table, you have to adjust the parent window's scrollbar to see the fields.  I think it would be better to shrink the table's window and use the table window's scrollbar because the table fields update as you scroll so it's easier to follow.

Some Alteryx tools, like Select, update when a field name or data type is changed upstream.  Sometimes it causes an error, but often Alteryx can self-adjust and be OK.  However, other tools such as Union and Summarize, don't recognize the change - they don't self-adjust or throw an error until runtime.  It would be great if these other tools (there must be others besides Union and Summarize) could recognize changes at design time.  Even if they just threw an error, it would be better than current state.

Is it possible to have a Sum(Column) or Total(Column) functions in formula tool? it will make the calculations much better as we don't need to use "Sum tool + Append tool + Formula tool + Select tool" or "couple of formula tools and then a select tool".

Context:

 

We have several workflows, chained together and orchestrated with CReW runner and conditional runner macros, several of which have run command events.

 

Each developer on our team, when running these workflows on their local workstation during development and testing, must remember to change or disable certain events in several workflows to prevent unintended shenanigans in production.

 

Since we collaborate on- and version our workflows in Git with a branching model and automated deployment to production, each developer must also remember to revert their changes to- or re-enable these events, before pushing their changes to our shared origin.

 

This is a cumbersome and annoying part of our local development workflow, and a potential risk (forgetting to disable or re-enable these events could be disastrous).

 

Suggestion:

 

Allow developers to define logical conditions for triggering run command events.

 

This would allow us to dynamically enable run command events, based on the environment in which the workflows are run.

 

There exists a separate feature request for environment variables, which would be super powerful in combination with this feature request, for obvious reasons.

Copy & paste from my post here.

 

The Python SDK offers a possiblity to automatically install Python packages through pip when installing using the requirements.txt. Some changes to the virtual environment of the tool might not be covered by this: For example, downloading and configuring language models for spaCy cannot be solved through the requirements.txt alone (similar for training corpora for NLTK).

 

So, as an idea for future versions of the SDK: Allow us to specify a Python script that is run when a tool is installed. This way we might be able to set up the environment, load additional tools etc.

There are several tools and tool categories that I have limited knowledge of.  It would be a nice feature to be able to right click on a tool and in addition to  "help",  have an option to view a video (on-line) overview of the tool or tool category  including examples of using the tool

Hi Alteryx, 

 

I am not sure if there already is an easy solution to sharing workflows between people using different language settings in Alteryx, so here goes.

 

My colleague is using the German version of Alteryx and both I and our server is using the English version of Alteryx. When he shares a workflow with interface tools, all connection strings disappear. This is due to the references in the script behind Alteryx are different. So in the German version, the connection is supposed to connect to a tool called "Aktion", but for the English version it needs to connect to a tool called "Action". The same example with "Frage" and "Question". It is funnily enough only an issue if at least one of the connection tools is an Interface tool. If it is not Interface tools, then the original connection remains as if it auto-detects and changes the language.
The solution as is now is opening the Alteryx flow with a text editor and search for the German word, e.g. "Frage" and replace it with "Question". After saving and opening with Alteryx again, it works. However, we would like to avoid this little detour into the text editor. So, if it is possible for Alteryx to auto-detect and adjust the language for Interface tools as well or if it is possible to adjust the settings regarding language for a specific flow/macro, then this would be great. 

 

Please let me know if another solution is already available. 

 

Best regards, 

Jeanette

It would be handy to have a tool that mirrored another specified tool in the workflow.  I frequently use the same regex or filter configurations in multiple parts of my workflow.  If I could just update one of those tools and have every other one where I want the same logic applied to automatically update, that would make things easier. 

 

Users would just have to enter the tool ID of the tool they want mirrored.