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

At the moment the salesforce connector does not support view objects like AccountUserTerritory2View. It should be extended to support those objects to facilitate more efficient and above all complete data extraction. 

0 Stars


Screenshot Autosave.JPGSort by file size based on first digit in file size (should be based on all digits). 

0 Stars

I suggest to add the functionality to parse date strings containing non-English month/day names into Date format

Maybe by detecting the display language of Windows or the language of the DateTime format in Windows settings.

 

For example, right now in Alteryx, DateTimeParse('July 2008','%B %Y') works fine, but for French month name, DateTimeParse('Juillet 2008','%B %Y') returns null !

and when calling DateTimeFormat(DateTimeNow(), '%B') we would like to have "Juillet" instead of "July" for French version of Windows/DateTime settings.

 

Right now, we need to use workaround solutions like SWITCH to solve this issue!

0 Stars

I have a 1000 row excel workbook with multiple sections on the same sheet, each with a unique header. Each section has exactly 16 rows of data included. I want to pull the rows only from one specific header called "wages".

 

I tried using a multi-row formula and the below expression to pull only these 16 rows but it isnt working. Any ideas?

 

IF Contains([F1], "Wages", 1)

THEN [Row+1:Test]+1 & THEN [Row+2:Test]+1 & THEN [Row+3:Test]+1 & (... all the way to +16)

ELSE 0

ENDIF

0 Stars

Extend the machine-learning framework for pressure analysis on a single well to multiwell systems.  

The framework should capture the well interference accurately and be able to test a greater area of the reservoir. Develop a machine-learning model to reconstruct the flow-rate history by use of pressure data. Ensure that both models maintain the advantages of the machine-learning- based single-well pressure interpretation in terms of the accuracy of prediction, computational efficiency, and tolerance to noise.

0 Stars

It would be helpful if Alteryx did not try to report blank dates in the data profiling tool that are not existent in the dataset. If our data is missing dates, it would be better to report these as a warning, rather than making the profiling imply that they should be within the dataset. Attached is a simple dataset to illustrate.Dates Data Profiling.PNG

0 Stars

when using the R-Tool for simple tasks (like renaming files, for example) in an interative macro - there's a delay on every iteration as the R Tool starts up R.

 

The following are repeated on every iteration (with delays):

2018-08-19_21-41-23.jpg

 

Can we look at an option to forward scan an alteryx job to look for R Tools, then load R into process once to eliminate these delays on every iteration?

 

0 Stars

This is an interface issue but I wish Alteryx can allow user to scroll across the ribbon toolbar (e.g. In/Out, Prep, Join, Spatial tools...) when the toolbar is active.

 

That is, for example, when I click on "Transform" and notice my tool is not there, I can quickly scroll my mouse to move to other toolsets. Microsoft Office is a best practice for this and I think this will make it much efficient to locate tools.

 

Idea.png

 

 

0 Stars

Currently only 5 workflows are displayed per page in a collection.  Currently we have about 30 workflows (soon to be about 100) and paging through workflows to find the one you want to run is time consuming.

 

It would be great if there was an option on the page so the user could select the number of workflows per page.

0 Stars

When using the Transpose tool I'm pivoting out networks names to column headings then I want to populate those fields with an "X".  To do this I have to first create a column first with an "X" in it and populated the various Networks columns with that.

 

How about another drop-down that says something like "I'll key the value I want to populate the fields with" and I can key "X" or "Y", etc.

 

It's possible I just don't know enough about the tool but I can't see how to do this other than my way.

 

 

0 Stars

When using the Levenshtein distance matching in the fuzzy match it gives you the option to select a match threshold % but does not allow for other options.  Is it possible to provide these additional options in a future release?

 

fuzzymatchoption.jpg

0 Stars

Similar to the regular formula tool, it would be great if we would be able to configure multiple text to column processes within one tool rather than having to line up several tools when having to convert various fields of different logic at the same time.

0 Stars

Designer should support statistical testing tools that ignore data distribution and support Statistical Learning methods.

 

Alteryx already supports resampling for predictive modeling with Cross-Validation.

 

Resampling tools for bootstrap and permutation tests (supporting with or without replacement) should be tools for analysts and data scientists alike that assess random variability in a statistic without needing to worry about the restrictions of the data's distribution, as is the case with many parametric tests, most commonly supported by the t-test Tool in Alteryx. With modern computing power the need for hundred-year-old statistical sampling testing is fading: the power to sample a data set thousands of times to compare results to random chance is much easier today.

 

The tool's results could include, like R, outputs of not only the results histogram but the associated Q-Q plot that visualizes the distribution of the data for the analyst. This would duplicate the Distribution Analysis tool somewhat, but the Q-Q plot is, to me, a major missing element in the simplest visualization of data. This tool could be very valuable in terms of feeding the A/B Test tools.

0 Stars

For most of our "Production" mode, we launch our apps with an xml file containing the parameter send to the app.

We would like to have the path of this file in the Engine Constant.

0 Stars

This wasn't pretty (actually, it was challenging and pretty when I was done with it)!

 

My client receives files that include a static and dated name portion (e.g. Data for 2018 July.xlsx) within the file there are multiple sheets.  One sheet contains a keyword (e.g. Reported Data) but the sheet name also includes a variable component (e.g. July Reported Data).  I needed to first read a directory to find the most recent file, then when I wanted to supply the dynamic input with the sheet name I wasn't able to use a pattern. 

 

The solution was to use a dynamic input tool just to read sheet names and append the filtered name to the original Full Path.

[FullPath] + "|||<List of Sheet Names>"

This could then feed a dynamic input.

 

capture.jpg

Given the desire to automate the read of newly received "excel" data and the fluidity of the naming of both files and sheets, more flexibility in the dynamic input is requested.

 

Cheers,

 

Mark

0 Stars

There are quite a number of XML configurations available in Alteryx Designer as well as in Alteryx server.  And there are possibly in different locations and each of them them is specifically for different configuration options.

 

Currently, there it isn't a official list of all these configuration files as well as all the configurable options.  It would be good to have a centralized area to configure and visualize all these.  This not only helps easier to know how to customize the tool but also help easier to maintain the backup/restore of the configuration files.

 

Moreover, there are possibly some settings go into the registry.  This would be also good to have this centralized as well.

 

Ideally, a user interface would be good for these configuration with general/advanced tabs to classify the possible configuration.  For server, ideally, it could be comes up the controller to distribute all these settings.  For Designer, once it is configured to the Gallery, it should be able to grab the configuration and apply in the machine.

 

Hope all these make sense and do-able.

 

Thanks.

 

Regards,

Kong

0 Stars

When working on the Weekly Challenge #108, I was trying to design a non-macro solution.

 

I ended up settling on the Generate Rows tool and was trying to find a way to generate rows until I had reached or exceeded the maximum density, however, I ran into an issue where I'd always have one too few rows, since the final row I was looking for was the one that broke the condition I specified.

 

In order to get around this, I came up with the following solution:

 

Spoiler

 

Idea_IncludeConditionBreak_GenerateRowsTool.PNG

Idea_IncludeConditionBreak_GenerateRowsTool.PNG

 

Essentially, I just set my condition to twice that of the true threshold I was looking for. This worked because I was always doubling the current value in my Loop Expression, and so anything which broke the 'actual' condition I was looking for ([MaxDensity]), would necessarily also break the second condition if doubled again.

 

However, for many other loop expressions, this sort of solution would not work.

 

My idea is to include a checkbox which, when selected, would also generate the final row which broke the specified condition.

 

By adding such a checkbox, it would allow users to continue using the Generate Rows tool as they already do, but reduce the amount of condition engineering that users are required to do in order to get that one extra row they're looking for, and reduce the number of  potentially unseen errors in their workflows.

0 Stars

The idea is the ability to skip tools in a workflow. Check the attached example:

 

Input (TRX_TABLE): Contains transactional raw data (unstructured & uncleaned data)
Filter (TRX_DATE <= 90 days from TODAY): It only filters the data 90 days old from today. Works as an incremental data loader
If the filter tool is NOT SKIPPED the workflow loads the filtered data (incremental behavior)
If the filter tool is SKIPPED the workflow loads all the data (full behavior)
This way I can quickly switch between both modes for testing & production environments

0 Stars

Instead of counting the number of occurrences of the delimiter and then specifying it is there a way to split column for:

1. Every occurrence of the specified delimiter?

2. Only the last occurrence

3. Only the first occurrence

 

Thanks,

0 Stars

Hi,

 

I am sure that I can't be the only person that would be interested in an output tool that allows categorical fields on both axes.  THis would allow you to visualise the following example and I would suggest that this was either similar to the heatmap with boxes or the colour / size of the entry was determined by a third numerical value - such as 'Confidence' from the table below.  THere might be ways to extend the idea as well as having a fourth parameter that puts text in the box or another number but it would be useful and not too hard I am sure.

 

LHS

RHS

Support

Confidence

Lift

NA

{Carrots Winter}

{Onion}

5.01E-02

0.707070707

1.298568507

210

{Onion}

{Carrots Winter}

5.01E-02

9.20E-02

1.298568507

210

{Carrots}

{Onion}

4.39E-02

0.713178295

1.309785378

184

{Onion}

{Carrots}

4.39E-02

8.06E-02

1.309785378

184

{Peas}

{Onion}

3.20E-02

0.428115016

0.786253301

134

{Onion}

{Peas}

3.20E-02

5.87E-02

0.786253301

134

{Bean}

{Onion}

2.20E-02

0.372469636

0.68405795

92

{Carrots Nantaise}

{Onion}

2.08E-02

0.483333333

0.88766433

87

 

Many thanks in advance for considering this,

Peter

 

Top Starred Authors