Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

Screen Shots.JPG

I’m writing about a short-coming I see in the Publish to Tableau Server Tool v2.0 (PTTS).  I work in a development environment where we use different Tableau servers (i.e. development, test, production) to support product development.  One of the shortcomings of PTTS is that once the Tableau server information you are connecting to is entered, validated, and the tool is configured, you can no longer ‘see’ which Tableau server/site the tool is publishing to.  I think this piece of information is quite important.  I know I can always us the “Disconnect” button in the tool and re-enter the information so I know which server it is pointing to, but this defeats the purpose of entering that information in the tool in the first place.

 

Please consider an enhancement to the tool so we developers know at a glance where (server/site) the tool is publishing.  Project and Data source names are helpful, but in a development cycle, all Tableau servers may have the same Project and Data source names across all environments.

 

I've attached examples of the tool options when being defined and once the tool is configured – notice server URL and Site are aren’t displayed in the tool once it has been configured.

 

One of our biggest issues when updating our Salesforce instance from our Oracle Database is the difference in column names. It would be nice to be able to map the fields as needed rather than having to redefine the columns in a Select tool or Dynamic Rename tool. This would allow more end users to understand what the tool is doing.

Extend the Gallery, so that you can pass a set of parameters to Analytic Apps changing both look and feel as well as feedback of the App, i.e. allow to call the App "Add Two Numbers" without borders and jumping direct to the question page.

 

https://gallery.alteryx.com/#!app/Add-two-numbers/5cc704bb826fd31188cf8ad8/run?header=N&sidebar=N&di...

 

sidebar=Y|N     allows to hide sidebar (home, districts,...)

header = Y|N   allows to hide header line

questions = Y|N    skip question page (only if no questions are available)

direct = Y|N       directly starts App (i.e. directly jumps to the question page)

Hi,

 

Recently I was helping a client to design the workflow to do transformation. In the middle of the work, I feel a bit lost on handling so many fields and thinking it would be great if there is a feature that allow me to track the field actions along the workflow. It could be something like a configuration on the canvas, user activate it only when they want to.

And when it is activated, the workflow could become:

23.PNG

So it is easier to find the path of certain field along the whole workflow.

 

Or is there any method to achieve this at the moment?

 

Thanks.

 

Kenneth

Within one of my modules I use the “Find Replace” tool quite often to find keywords within a customer name field.  By chance, I have found that irrespective of what order my keywords are sorted in, Alteryx will look at each word in the customer name and try to match them in order.
 
For example, the customer name of EAST RIDING YORKSHIRE COUNCIL, when matched to my list of keywords matches the word RIDING before it matches the word COUNCIL, even though COUNCIL appears higher up my list than RIDING does.
 
I would like to be able to prioritise my keywords so that Alteryx starts at the top and works its way down my list of keywords, rather than just taking the first word in a customer name that matches any of my keywords. Is this possible?

Allow Input Data tool to accept variable length (ie., variable number of fields) per record.  I have a file with waypoints of auto trips; each record has a variable number of points, eg., lat1, lon1, lat2, lon2, etc.  Right now I have to use another product to pad out all the fields to the maximum number of fields in order to bring it into Alteryx.

I am having large denormalized tables as input, and each time I need to scroll down approx 700+ fields to get an exhaustive view of fields that are selected (even if I have selected 10 out of 700 fields).

 

It would be helpful if along with having a sort on field name and field type, I can have an additional sort on selected/deselected fields. Additionally if I can get sort by more than one options i.e sort within an already sorted list that will help too - i.e. sorted selected first and inside that selected by field name.

 

I can get an idea of selected fields from any tool down the line (following the source transformation), but I would like to have an exhaustive view of both selected and unselected fields so that I can pick/remove necessary fields as per business need.

If a macro or tool is missing in a workflow, all configuration and connections of said tool is broken, and if you save, all previous configurations and connections are lost.

 

I am proposing all connections and configurations of these tools are instead 'frozen'; all connections and configuration are saved but not editable (with the exception of deleting them). This would allow collaboration with users who do not have the tool/macro.

 

Additionally, functionality to be able to manually point towards another tool and maintain the connections/configurations (in case you have the same macro versioned or named differently) would be nice.

I often have many tool containers, which I have to constantly manage locations of so they do not overlap, etc.   It would be much easier to have the option to have a tabbed tool container. 

There are currently two different types of select tools. The dynamic select tool and the normal select tool. In my opinion there should only be 1 tool and it should be a mix of these two tools.

 

First the select tool is great because I can select the exact fields that I want, and I can pass new fields through using the "unknown" field. The dynamic select tool is also great because I can write formulas that dynamically select fields. Why not have one tool that does both?

 

In my mind, it would just look like the select tool, but then on the "unknown" field, I can click on it and configure it. It would basically just open the dynamic select tool interface where I can write formula's etc that select the unknown fields that I am willing to pass through.

 

For example.. clients add new fields to our data integrations all the time. A lot of the time I dont want these new fields to pass through automatically. But we also do reporting, and reporting could include column headers that are dates (ie sales may 18, sales june 18, etc). As new months appear in our sales data, new columns are added to our reports. I should have the capability to hardcode the fields I want to pass through and then write a formula for the remaining "unknown" fields. In this example I would check mark the fields I know I want, then write a formula that says if the unknown field starts with "sales" then pass it through.

 

Yes there are workarounds for this type of functionality (such as I could do a dynamic select tool and use the formula function to type in the name of EVERY field that I want to "hardcode"), but that would take a long time if I am trying to pass 10+ fields through.

We extensively use the AWESOME functionality of SharePoint List Input and SharePoint List Output tools.  They're great!  BUT... they require valid credentials to pull back the valid list and view values.  Not normally an issue until you go to share your workflow.  If you strip out your credentials from Alteryx the List and view fields go blank, do it from the xml and when the person you share it with opens it up the fields go blank and you have to count on that user selecting the proper list and view.  

 

I propose to have these tools load valid lists and views only upon pressing a button or running the macro in initial configuration state.  

Found this https://community.alteryx.com/t5/Alteryx-Designer-Discussions/SharePoint-Passwords/td-p/17182

and we could use a macro tool but every implementation still requires storing a valid username and password to avoid the error and the list id which I imagine the sharepoint API requires and which is why the tool behaves the way it does is not easily obvious to most ppl.

My proposal is to create a new support at Alteryx team level according to provided picture with Alteryx toolbox logo for example in the same philosophy

Move the location of missing fields in the select tool to the top to alert user that field names may have changed in the import source.

The Find Tool (View>Find or Ctrl+F) does a great job of finding text in a workflow.  The window displayed by the Find Tool includes each tool # and the Name from each tool's Annotation tab.

 

Please consider displaying this additional data in the window of the Find Tool:

- Annotation text for tools

- Caption for containers  (like the right-click Zoom functionality has)

 

Since Containers don't have a "Name" field like tools do, displaying the Caption for a container would be helpful.

 

See this thread: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Change-Serch-Results/m-p/388604

 

Capture.PNG

 

 

Integrate matchit SQL with Alteryx

 

http://matchitsql.com/

Would it be possible to have Calgary index files saved to a sub folder so they don't reside in the same folder where the cydb is located? All these indices just clutter up the folder. Thanks,

Simon

Can you add .tsv files as a file format in input/output tools in Alteryx? Can it also be recognized as an 'All Data Files' format?
Thanks!

Currently I am unable to use Alteryx's spatial calculations in completing required reporting for CMS.  Its unfortunate, because in my mind Alteryx is a superior approach allowing for customization and seamless integration with varied data sources used within our company.

 

You might ask, why don't you just use actual driving distance?  The datasets that we are measuring are enormous. +60M member files are being compared to 70K providers.  Alteryx is missing a huge opportunity to get into this market.

 

Reference

https://www.cms.gov/Medicare/Prescription-Drug-Coverage/PrescriptionDrugCovContra/downloads/hsd_meth...

Travel Distance to Providers and Facilities

The second component of the review process tests the percentage of beneficiaries resident in a given county with access to a particular specialty type within the maximum travel distance. For a given county and specialty type, CMS uses the geographic coordinates for the associated providers or facilities and the geographic coordinates for the beneficiaries resident in the county and calculates the travel distance between them. The travel distance is calculated using a formula to determine the estimated driving distance (miles) between the latitude and longitude coordinates and provides an average for the total beneficiaries in the given county

I am currently building workflows on unfamiliar data and using the filter tool on text fields regularly on a large excel file.

As there is no dropdown on the right hand side of the filter tool I find myself needing to open excel and use it's dropdown functionality to find the right text to filter on. I know I could use the summarise tool but each time I run the workflow it takes many seconds to complete before it is populated. It is quicker to use Excel. I am surprised this has not been requested before.

I have records of with several address fields per store: address 1, address 2, address 3.(e.g. po box 123, 456 main st, suite 600).
I geocode each address field in different iterations, but I want my final input to contain the best geocoding level. e.g. Actual before Zip9. 
Can we rank the geocoding levels like this below? Then it will be easier to filter out the best geocoding level.

1. Actual
2. Street
3. Intersection
4. Extrapolate
5. ZIP9
6. ZIP7
7. ZIP5
x. Not Coded
 
Top Liked Authors