Alteryx Designer Desktop Ideas

StreetGeocoder when finds an address returns its fields in CAPITAL CASE which is no good for showing to user. Can it return in a correct title case? AFAIK, source data are in valid title case, but the tool or data preparation team make a standardization which actually makes all letters capital.

When city is not provided StreetGeocoder tool returns the first one in alphabetical order associated with provided ZIP code. For example, if you submit "380 New York St, 92373" the geocoder will return you "MARIGOLD, CA", instead of Redlands, CA which is the primary place name for 92373 ZIP code.

 

So if an address has multiple city names within the geocode table, can we provide the recommended city name?

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!

Can you add the Data Output along with the Report Output on the Association Analysis tool.  

We needed to manually change this on our end but it would be nice if in 9.5 this easy upgrade was done already...

Can you add some additional options to the running sum tool?  I know this can be done in the Multi-Row formula, but it just takes too long to program and Alteryx is designed for speed and I know it can be done.  Can you add options to average, standard deviation, etc. also with running sum?  And then add a rolling time window on it.  That would be great!

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'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".

When using an App from the gallery, I would like to keep track of how many (Allocate dataset) checkboxes a user has toggled real-time by having a counter on the same form. Functionality would be the same as a winform which may contain a label control that contains a counter that updates every time a checkbox is (un)toggled. Then I would make the ‘Next’ or ‘Continue’ button active when a certain threshold is reached by the counter. So it needs to be dynamic. Maybe in general make the forms/Apps more dynamic so you have to do less chaining of apps?

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.

I know this is a reach, but it would be nice to have the ability to drag around points or lables on the map before outputing them.  Specific example, plotting competitor stores that are at a Mall, all of the points stack on eachother.

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.  

I collaborate with a team using Git. We commit all of our work automatically with the exception of the Alteryx Alias file. It must be moved manually into the repository and then other teammates must move it out of the repository manually into their local folder and overwrite the old file. This is not an enterprise-friendly solution. If we could configure the location of the Alias file in Designer, we could set it to live in the repository. That way, everyone could automatically have the latest file with tracked changes. Please create this functionality. Thank you.