community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the star in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

I was with my friends at Limited Brands yesterday and they pointed out to me a way to improve Alteryx.  While designing a workflow, each time you add an input tool to the canvas you literally have to start from scratch to add additional tables from either a db datasource or file source (e.g. access).  With other tools, you can drag multiple tables to the canvas at once and come back later and add more inputs without having to select your source, see a list of tables etcetera.

 

On their behalf (they may post another suggestion), I am posting this idea.

 

Thanks,

Mark

Hi,

 

I get a lot of adhoc requests where the insturctions are in the actual email. As I'm going through the ask, creating the new workflow, the requester will mention "column C" or "column XY", but I'm viewing the data in Alteryx where that doesn't show. So I have to open the Excel file, find the column, get the name, go back to Alteryx to locate the column I need, run the module but get an error/no results because I forgot to close the Excel file (because the module is using the same file I just opened to validate which column I'm using).

 

It would be really cool to have an Option in the Input tool to add the Excel column lettering and numbering to show (Ex, Column A, B, C, D going left to right, Row 1, 2, 3, going top to bottom). This would just be visually showing it, not adding it to the data (because then you would lose the actual column names). If this can be done, it would be equally as useful in the Browse tool view. Have a great day!

Hi all,

 

When testing a macro with interface tools in use - the value that is used if running in normal execution (hit the big play button) is 0 or blank, irrespective of the value set for default on the component.

e.g.

  • put an up-down component on a canvas with a default value of 200
  • Then hook it up to a formula box
  • Then output the value 
  • The value which is output is 0

 

Please can you change this so that the value passed through the interface tools in testing mode is the specified & configured default value?

 

Thank you

Sean 

If a user selects 10 Input tools, the ability to then right click and be able to "Insert After" to a Union tool and have all the Inputs attach to the Union would be great!

For the Charting tool, specify descending/reverse order for a Bar Chart type, so that it puts the largest value at the top.

I <3 Alteryx but sometimes I miss some of the abilities Tableau has to visualize the data output while designing.

 

When working with data containing many fields, I find myself changing the order of columns, running the workflow, and repeating... over and over until I get the right "look".

 

I know you can right-click and drag in the configuration pane of the select tool but I was thinking that it would be great if we could also do the same in the results pane and see the changes live.

I've had to look through a few logs recently and I had expected the information to match with what is displayed in the results window

 

Reference the tool name, type of tool (in/out, prep, etc).   Only the toolid shows up in the log where the results window shows the name

 

I find the concept of Batch and/or Iterative macros, when done specifically for the simple purpose of iteration, to be a fair bit of overhead. If we could extract the fundamental qualities of a loop and get that into an "Iteration Tool," it could become a well-used tool from the pallette.

 

Implementation Ideas:

  • Assume that the iteration is over the rows of a given input data set.
  • For the "body of the loop" allow multiple expressions, each of which iteratively assigns the i'th position of a given variable (which could be either existing or derived just like the Formula tool and it's expression).
  • Allow referencing of the loop index variable from within expressions

An example problem this could solve is from: http://community.alteryx.com/t5/Data-Preparation-Blending/Looping-and-dynamically-changing-output/m-....  As discussed therein, the concept of "row dependent iteration" makes this difficult to solve with standard tools.

 

If the input data set from that example were sent into the proposed Iteration Tool... it would automatically loop over the dataset rows; and three expressions could be supplied in the Tool configuration to solve the problem:

 

VarE:   IF [i] > 1 THEN VarF[i-1] + VarG[i-1] ELSE VarE ENDIF
VarF:   VarA + VarB
VarG:   VarC + VarD

 

For implementation purposes, this would be logically equivalent to:

 

VarE[i]:   IF [i] > 1 THEN VarF[i-1] + VarG[i-1] ELSE VarE[i] ENDIF
VarF[i]:   VarA[i] + VarB[i]
VarG[i]:   VarC[i] + VarD[i]

 (so, basically, the i'th row is assumed unless otherwise provided in the expression syntax).

 

I hope this isn't too outlandish - I've tried to think through how this could be accomplished (1) as a tool that is not too fiendishly difficult for Alteryx to implement and (2) which would also be easy for us, the end users, to utilize.  Thanks!

Add an option to cancel an occurrence currently queued to run without it removing, or completing, the original schedule. Not sure if this is by design or a bug but when you cancel a workflow that's in queue, it sets the scheduled workflow to "Completed" even though you just wanted to stop that occurrence and still keep the workflow schedule “Active”.

Also, adding an option to PAUSE a scheduled module. This is useful when you need to temporarily suspend a workflow from running, but save the hassle of re-configuring the schedule when you want to turn it back on.

Could we please have the option of selecting the fields, like the join tool, within the Calgary Join tool?  It is especially problematic when I simply want to assign spatial object name to a point; i.e customers within a DMA or sales territory.

 

This would be agreat addition within the ConsumeView Matching tool as well.

 

  Thanks!

I have a process where I output data to a database each week.  Because the database fields have a pre-defined/expected data type, I must maintain that same data type in my workflow.  However, I would still like Alteryx to determine the max size of the fields for string fields.  The Auto Field tool does both, and sometimes it might change the data type of a field based on the records being passed at the time.

 

The reason is because the output to the target database is fastest when you make the string field sizes as small as possible.  So, hard-coding the field sizes has inherent inefficiencies.

I have a big need to input files created in a .sqlite format and also write out to files as .sqlite that contain spatial object fields.  Currently they are not recognized as spatial objects.  BlobConvert is not able to convert the spatial fields from the input correctly (it gets close) so the result is that we are unable to utilize any spatial fields from or to these files.

I would like to see the same functionalitly that the Output Tool has in the Render tool.  In the Output Tool, you can specify the Excel Worksheet along with the Sheet Name that you want to output too.  Meaning Same Worksheet, different tab:

     C:Output FilesExample_Worksheet.xlsx|Report_1
     C:Output FilesExample_Worksheet.xlsx|Report_2


This functionality is not currently available in the Render Tool and would be very useful and cut out some manual operations on the back end that requires us to copy/paste from one file to another.

I tried using the Section Break technique that was offered as a suggestion, but it did not perform what I needed.

Possibility to deselect fields directly in the input (shape, csv, tab, etc).

 

As a MicroStrategy customer it would be nice if Alteryx would support output for either the .mstr file format or better direct creation and publication of the iCUBE, intelligent cube format on their server solution. This would be similar to the existing features of writing a twbx or  TDE file extract and publish to Tableau server.

Opposite if the Input connector could read from an intelligence cube on the MSTR iServer as datasource that would be great as well.

Below a link to their SOA webservices documentation to pull data into applications, perhaps an option.

Data as a Service

 

 

When processing multiple files using wildcard character, Alteryx workflow fails when there is empty file. Skipping zero size file option would help. Else, I have to write a batch macro and process each file separately.

It would be great if the mapping allowed point themes to be bi-variate, i.e. you could change the size of a point at the same time as adjusting its colour to show two variables on the map at once, relative to each other.

Chris
I would the ability to run/call a module from within another module. I've thought of two solutions:

Simple - Add an option that currently exists in the Analytic App properties to "On Success - Run Another Analytic App". Instead this option would be to Run Another Module

Complex - Create a new tool that would have a single input that would accept a list of filepaths to Alteryx modules. The modules would be run sequentially (module 2 run once module 1 was finished).

Cheers,

John Hollingsworth
When workig on a module with many tools, and one of those tools is the Allocate Input tool (Experian US), whenever you try to access or configure that other tools, there is a delayed reponse.  I'm assuming because the Allocate data set is so large.  But, it would be nice, if possible, that when accessing/configuring other tools you did not get that delay.  My workaround is to Container the Allocate tool and disable it.  

It will be super great if additional file formats such as Excel, compressed text files, etc. can be selected when using Amazon S3 Download connector tool.

Top Starred Authors