Alteryx Designer Desktop Ideas

In the designer it would be nice if the projection of a .shp file could automatically be read by its corresponding .prj file.

There is a great functionality in Excel that lets users "seek" a value that makes whatever chain of formulas you might have work out to a given value. Here's what Microsoft explains about goal seek: https://support.office.com/en-us/article/Use-Goal-Seek-to-find-a-result-by-adjusting-an-input-value-...

My specific example was this:

In the excel (attached), all you have to do is click on the highlighted blue cell, select the “data” tab up top and then “What-if analysis” and finally “goal seek.” Then you set the dialogue box up to look like this:

 Set cell: G9

To Value: 330

By changing cell" J6

And hit “Okay.” Excel then iteratively finds the value for the cell J6 that makes the cell G9 equal 330. Can I build a module that will do the same thing? I’m figuring I wouldn’t have to do it iteratively, if I could build the right series of formulas/commands. You can see what I’m trying to accomplish in the formulas I’ve built in Excel, but essentially I’m trying to build a model that will tell me what the % Adjustment rate should be for the other groups when I’ve picked the first adjustment rate, and the others need to change proportionally to their contribution to the remaining volume.

There doesn't really seem to be a way to do this in Alteryx that I can see. I hate to think there is something that excel can do that Alteryx can't!

Just ran into this today.  I was editing a local file that is referenced in a workflow for input.

When I tried to open the workflow, Alteryx hangs.

When I closed the input file, Alteryx finished loading the workflow.

If the workflow is trying to run, I can understand this behavior but it seems odd when opening the workflow.

Dear Alteryx

Typing econometric formulas within the Formula tools can be very tyring when formulas are long and complex

What would be very nice, would be to have the possibility the get a a kind of "Formula" format (in adition to double , string, datetime ...).

When the format is set to Formula, Alteryx automatically detect that it is a formula and use it as such.

It would allow to import easily external models formulas without to type or paste them within Alteryx

Many thanks

Arno

Can you devise a way to bring out the dynamic network visualisation on to Powerpoint.  Right now, we can only see a static image on a browser

Idea to have the option to include the workflow "meta info" (last tab of the workflow configuration when clicking on the cavas) when printing the workflow.

The Meta Info desciption and author sections would be particularly of value. Currently on the long file name is embedded in the header.

The "Field Summary" tool and several others have a configuration requirement that provides a list of fields to select or deselect.  The selection action is singular meaning you can only effect the action on one item in the list of many.  As the number of fields we work with grows significantly this becomes a time consuming and tedious task.

This should be enhanced to allow highlighting of multiple fields to select or deselect as we can do in tools like the "Select" tool.

The field summary tool is an excellent resource to get an overview of the data and spot targets for analysis or data cleansing. 

Unfortunately it has limitations either in the number of fields included or some combination of the number of fields and one or more of its attributes.   There is nothing in the documentation I found to make a user aware of this. When you exceed N  fields selected the system just hangs, indicating it is running but there is no connection progress shown and nothing seems to happen, even if you limit input to 1 record.

Through trial and error I found an approximate limit in number of fields I can include and still have it work.

I request that Alteryx update the tool help info and devise enhancements to dynamically load balance the tool so it can scale to the number of fields requested or at least warn when the limit is reached or approached.  The latter warning could be similar to the red font warnings in the formula tool when you have a malformed expression.  However a load balancing version is most desired.

The issue as it stands results in users wasting a lot of time trying to make the tool work as expected, then report it to support as an apparent bug in the tool which can be argued both ways.

I realize in the real world there are limits but in this real world we are seeing the number of fields to analyze increase significantly, especially when you have a data license and integrate 3rd party data to you own native data adding a hundred or hundreds more fields.

How about adding the ability to split intersecting trade areas at the points of intersection to create two new spatial objects.  The two objects could then be used to process customer records and divide them into "territories" based on  the line of intersection.

I am trying to use the Dynamic Replace to selectively update records in a set of variables from survey data. That is, I do not have all potential values in the “R” input of Dynamic Replace. Instead, I have a list of values that I would like altered from their current values by respondent (RespondentID) and question # (Q#).  Currently, when I run the workflow, any Q#/ResponseID combos that are not in my “R” input are replaced with blanks. However, I would like an option that maintains the original data if there is nothing to replace the data with. Without this option, there are few (I'm still working on some ways) workarounds to ensure the integrity of the data.

Matt

The community could benefit from easier integration of splitting and applying functions to grouped data. The summarize tool is great for splitting your data and applying summary statistical functions. It would be super useful to take that block just one step further, and allow users to apply any other (aggregate) function to their grouped data instead of just the built-in functions in the summarize tool. I would envision that aggregate function either being a custom function that is a combination of existing user-specified functions within Alteryx (e.g. in the formula tool) and/or even an interface that allows you to use other Alteryx macros on the grouped data.

Apply user-defined functions, or other powerful Alteryx macros to grouped and data is a very common operation in the data analyst's daily workflows and being able to apply them without reverting to batch/iterative macros in a seamless manner would be naturally helpful.

https://ramnathv.github.io/pycon2014-r/explore/sac.html

Hi, 

I think it would be nice to have the possibility to select which fields will output fo the distance tool.

When calculating distances for between large dataset, I do not always want my to 2 set of points has par of the output and would like to drop them directly in the tool.

Thank you

Simon

Korem

When giving a user a dropdown list, it is difficult to give them an option of the data in a specific column.  So if I have a "State" column, I would like to give the user a dropdown of all of the states currently represented in the table.  So if there was "Nebraska, Nebraska, Iowa, Kansas, South Dakota", the dropdown list would give them an option to select Nebraska, Iowa, Kansas, and South Dakota.  This could be useful on both List boxes and Dropdown lists.  Currently there is a workaround that lets you do it, but it is not a great solution because if there is a space (Like in South Dakota), it puts an underscore in it so parsing is required.