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

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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
Seeing how we use browse to tools to help build out modules, but they slow down the modules because they write out temp files, it would be awesome to have a "record count" option similar to the input tool. This would allow us to see the data as it's flowing through the module without slowing it down.  Adding a sample tool before every browse would be fairly cumbersome. 
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

Hello all,

 

When you copy and paste a layout tool to keep the formatting you just spent hours fixing it goes away as soon as you paste it. This is infuriating. Please keep the formatting from resting upon pasting.


Attached are pictures of a copy and pasted layout tool connected to the same incoming data source.

You can clearly see that the order and formatting has been removed. #Infuriating

 

Nick

 

Post.PNGPostPre.PNGPre

Scenario:  6 input tools, and want to add, say, a select tool after each one.
Would be nice to select all 6, and add the tool after all of them at once.
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 would be nice to have a function similar to IsEmpty() that would also return true if the string only contained spaces. Of course the simple work around is to Trim() inside IsEmpty(). Just trying to save a few keystrokes and remove a failure mode if you forgot to Trim()...

 

ken

(Not sure i have posted this in the correct spot)

Note from one of our customers:

All our pharmacy images are mainly tiff format only.   Since we don’t have the options TIFF to PNG or JPG converter in the BLOB converter tool  in Alteryx.

We are not able convert and display the image from alteryx to PDF or Report display tool in Alteryx.

 

As our images are critical components of our Reporting options .  This impact us to  use this tool for the below use cases and we are not able move forward on this activity with Alteryx Tool.

When it comes to something going wrong in Alteryx the last thing I can ever remember is the email address to use for support. Instead of trying to remember whether to use customersuccess@ or clientsvcs@ why can't it just simply be support@?

 

At your time of need, please make it as simple as possible to get help.

It would be nice to have the ability to double click the top area of a container to either show or hide the container's objects. Only being able to show or hide containers using the arrow icon in the top right is quite cumbersome for large containers because it requires a lot of horizontal scrolling in order to change the desired view of the modules workflow.

When pushing rows out to a SQL server table that has an identity column - we often need to use an Output clause in the insert statement to return the new primary keys used so that these can be passed on to the next step.

 

In cases like this - the output tool should be able to pass these IDs on to the next tool for down-stream manipulation (i.e. the output tool needs to be non-terminal node - so that it can have an outbound connector to pass this on).

This is a very common problem when inserting into a dimension table with an integer primary key, which you then need in order to pass this onto your Fact table loader.

 

Example: 

Table definition:

Create table Pets
(
PetID int identity(1,1) primary key not null,
PetName varchar(20) not null,

Age int not null,
)

 

Query: 

 

Truncate table Pets
GO
Insert into Pets
output
    inserted.petID,
    inserted.Petname
values('Fido',10)

 

Insert into Pets
output
    inserted.petID,
    inserted.Petname
values('tweety',15)

 

Output from SQL 

 

2017-09-28_0-27-12.png

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.

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!

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 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

With more people moving into urban developments, it would be helpful to allow analysts to measure customers within a "walking distance". Similar to drive time analysis, a step up would be to incorporate "walk time" analysis.

It would be nice to have the ability to have a workflow wait/pause tool that would pause the workflow for a given amount of time before proceeding to the next step (i.e. wait 300 seconds). 

 

I have a workflow that uses the Run Command to run a batch file that kicks of a terminal emulator that cycles through steps the ultimately result in an exported text file that I use in an Alteryx workflow for further processing. The generation of the text file can take a few minutes. A delay could be placed in the batch file or terminal emulator script, but I think having a tool in the Alteryx workflow might be useful for other processes as well.

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.

Idea:

A funcionality added to the Impute values tool for multiple imputation and maximum likelihood imputation of fields with missing at random will be very useful.

 

Rationale:

Missing data form a problem and advanced techniques are complicated. One great idea in statistics is multiple imputation,

filling the gaps in the data not with average, median, mode or user defined static values but instead with plausible values considering other fields.

 

SAS has PROC MI tool, here is a page detailing the usage with examples: http://www.ats.ucla.edu/stat/sas/seminars/missing_data/mi_new_1.htm

Also there is PROC CALIS for maximum likelihood here...

 

Same useful tool exists in spss as well http://www.appliedmissingdata.com/spss-multiple-imputation.pdf

 

Best

Just like having an e-mail sender,

 

I'would love to have an SMS sender as well for automated sending marketing SMS messages...

 

  • probably it can be done with a free SMS API found over the web or
  • better It can be provided as a service from Alteryx Gallery... Country by countyr availability to  sendin sms'

 

Picture1.png

 

  • Can be used for 2 step verifications
  • marketing messages
  • campaign enrollment etc.

 

Best

I find myself cutting and pasting (rearranging steps) a lot.  Right click "move ahead" or "move upstream" would be great for shifting the order of filters and formulas and such.

Top Starred Authors