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

Hi!

 

It would be cool if the Overlap tool also worked with report layouts, instead of just the map image. For example, once I've pieced my different report tables into one layout, it would be cool if I could just add my company logo using image tool, add a Overlay tool, and add the logo to the top corner of my finalized report. I realized there are other ways of doing it, this would seem the most straight forward though. Just an idea.

 

We encountered an issue with clob data.  Looks like alteryx is very slow performing while loading clob data to Oracle database. We need to figure a better way to handle the clob data.

I haven't seen this idea posted exactly this way...

Right now the browse results are only available while a workflow is open. It would be great if they could be saved until the next run, because sometimes I have to do things in stages, saving and closing a workflow, then continuing on it another time. I would love to have the browse results fromt the last run still be there until I re-run it.

As per title, add option to not write 0 records to output file i.e. don't create file with just headers, if 0 records end up streaming to the output tool

 

 

Pretty simple but could be helpful when troubleshooting and reviewing.  Allow a user to have rows be banded in a different color, allow the user to select how to do the grouping to band.  For example, a large browse tool has several thousand rows, sorted by product name.  Each product has between 5 and 50 rows each.  If a user could set color banding by product,.. they could easily find the "breaks" between product rows.  This could be somewhat similar to the Excel table formatting option for banded rows,.. you could simply alternate bands,.. but would be nice to be able to group the bands by some column attribute in the data.

This may be a little easier than constantly opening new browse windows with the selected records,. or to use filters or other tools to group the data for review / troubleshoooting purposes.

I love this option in the Input Tool and use it extensively. It would be really handy to have the ability to set this option 'globally' for all Inputs in a module. I don't mean to remove it as an individual option, but to add ability to make the setting for everything. In my mind I imagine it being a Module/Runtime property that overrides the individual Input tool settings (like the Record Limit option).
 

Like for Salesforce Input and Output tools, the Salesforce Wave Output should offer the possibility to change the URL for the connection.

 

I struggled connecting to Einstein Analytics (Wave) in one of our company sandbox. I could not. However, I succeeded when I changed the harcoded url in both the macro and its related javascript.

 

Francois

In earlier versions the MongoDB Output did not pass fields with null values; this was ideal for storing individual attributes, where one person may have 4 attributes and another may have only 2 attributes, because we did not waste space storing empty or null values.  The newer versions pass these fields with null values; I would like the option to not pass these fields. Please see an example below.  Thank you for your consideration.

 

Workflow Results

 

IDAttribute1Attribute2Attribute3Attribute4
1ABCD
2ZY  

 

MongoDB Output Current Versions

 

{"_id" : "1",
"Attribute1" : "A",
"Attribute2" : "B",
"Attribute3" : "C",

"Attribute4" : "D"}

 

{"_id" : "2",
"Attribute1" : "Z",
"Attribute2" : "Y",
"Attribute3" : null,

"Attribute4" : null}

 

Desired MongoDB Output (previous functionality)

 

{"_id" : "1",
"Attribute1" : "A",
"Attribute2" : "B",
"Attribute3" : "C",

"Attribute4" : "D"}

 

{"_id" : "2",
"Attribute1" : "Z",
"Attribute2" : "Y"}

Dear Alteryx Team

A nice to have :
Possibility to create output directories automatically using a given fieldname in order to organize properly macros outputs

Thanks a lot

Arno

 

Do you have self diagnosed OCD?  Do you know why 59 could be a magic number in Alteryx?  After long bellyaching in these forums about distribute evenly (+1) and auto layout, and the clean my workflow features I suddenly realized, why not just snap to grid and make my grid size the size of an Alteryx tool?  Voila! only ...no.  Setting the grid size to 59 and snapping only intermittently works. There seem to be varying reference points used for the snap depending on the existence of containers, etc.  So my idea, maintain a single reference point for workflow snapping that should ensure everything snaps based on that point (aligns to the grid).

 

For those of you still wondering what I'm on about... note how the append tool is shifted.  Yes I know I can click and move it to align with the grid, but it gets cumbersome when dealing with many items in many containers.  One grid to rule them all.

Line UP!Line UP!

 

 

I'm working on loading some public data available as an .xls doc on the web. I can use the download tool to fetch the file, but then have to save it, and reopen it in a separate input data tool. It would be so much easier if I could just flow the download result into an excel parser tool, but I don't see that as an option unless the download file is XML or CSV.

With SSIS, you can invoke user precedence contraint(s) to where you will not run any downstream flows until one or more flows complete.  A simple connector should allow you to do this.  Right now, I have my workflow(s) in containers, and have to disable / enable different workflows, which can be time consuming.  Below is a better definition:

 

Precedence constraints link executables, containers, and tasks in packages in a control flow, and specify conditions that determine whether executables run. An executable can be a For Loop, Foreach Loop, or Sequence container; a task; or an event handler. Event handlers also use precedence constraints to link their executables into a control flow.

Unless I'm missing the basics, I'm unable to scroll and pan during module runs.  I can zoom in and out, but not scroll or pan.
On large modules, I would love to be able to scroll to different areas to see progress/status of different key points in the process.
Guidance from the experts would be much appreciated!  Thanks!

When starting workflow from scratch I often build functionality in disjoint containers but would like away to indicate the order of running for containers (possibly by connecting with optional arrows to indicate order of precedence).
When I currently hit F1 when function is highlighted within properties window it brings me to tool help - it would be helpful if it brought you to help on the function.  Or if I hover over a key word function it brings up info on it.

We need the ability to pre-populate App questions with a default value. This not only gives the user an example of what type of data string the App is looking for, but also may avoid the user from having to do anything if the default folder or file is already correct.

This would also allow for quick App testing since we can just accept the defaults and not have to load up a yxwv file every single time.

ArcPy/Python, ESRI Modelbuilder, PyQGIS can all do this (heck, even MapBasic can do it!) - there's no doubt it's more convenient for the designer and end user.

Constantly using rand() function but also need;

 

  • Normal distribution function like we have in Excel and
  • Triangular distribution function too...

Picture1.jpg

Idea: can we please add normdist() and triang(min,mode,max) functions...

 

Best

 

Edit: for normal dist. attached a discretized example...

In my environment, creating tables with fields in a particular order is a requirement.

The Select tool (and others) let me manually change sort orders. The Select tool will also allow me to sort on Field Name in Ascending or Descending order.

I can add a sort order prefix to my input data with the Dynamic Rename tool, connect a Select tool and then go into the Select tool properties to sort by Field Name. But this requires that I first run the module so that the Select tool knows what the incoming fields are called, then set up the Select tool properties, and then rerun the module. If I change the prefixes or the list of incoming variables, the Select tool has to be reconfigured.

It would be really nice if there was a Field Sort tool that only had Ascending or Descending as properties that would 'dynamically' do what the Sort on Field Name option in the Select tool does.

Our team works with a lot of in-house transaction data sets that have been put into a calgary database.  It would be much easier to build apps that use the calgary input tool without having to configure html code.

For example, in the Properties tool (I say that generally because it could be in more than one place in that tool) all the user to enable to visibly see the path of the variable in the flow on the canvas.  As shown in the mock-up image below (as crude as it is, I think you get the idea).  This would allow you to trace the path forward and backwards in the flow, seeing where the variable entered and when it exited.  This could be something you can turn on and off like the grid option.

Top Liked Authors