Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

0 Likes

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 Likes

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 Likes

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 Likes

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 Likes

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 Likes

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 Likes

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 Likes

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

 

0 Likes

It may just be me, but after I upgraded to 2018.2, the Table/Query edit window doesn't take up the full window when I maximize the parent window. 

 

I'm surprised no one else has mentioned this, maybe it's just me.  See attached.

0 Likes

When in the flow of designing a workflow, I often accidentally click on the help ? Icon on the side bar of the configuration window, thereby launching a browser window, taking me out if Alteryx and interrupting my flow. Would love to have some UX indication, perhaps a different color, that clicking on this icon will redirect the user out of Alteryx.

0 Likes

I am parsing retailer promotions and have two input strings:

1. take a further 10%
2. take an additional 10%

 

I am using the regex parse tool to parse out the discount value, using the following regex:

further|additional (\d+)%

 

When the input contains examples of both options (i.e 'further' and 'additional'), the tool only seems to parse the first one encountered.

 

E.g if I state the regex string as:

further|additional (\d+)%

 

It only parses line 1 above

 

And if I state the regex string as:

additional|further (\d+)%

 

It only parse line 2

0 Likes

We have to run the full workflow at a time, if you can please think of something like partial running of the workflow and also while designing the flow if we add new tools, we have to run the entire flow again. 
Why can't it hold the intermediate data to avoid re-running the entire code.

0 Likes

Create a standardized Mailbox application that could bolt onto Alteryx Server, to handle incoming attachments from sources like a Service Desk (Service Now for example) and other applications.

 

Essentially anything that regularly exports data in the form of an emailed attachments to which Alteryx could, using a series of predefined user rules and a designated email address, put those attachments into various directories ready for processing by automated Alteryx workflows.

 

This would save a huge amount of time as people currently have to manually drag and drop files. At least the on board Alteryx designers here haven't been able to come with a solution. Would also save any messy programming around systems like Outlook and bending any security issues within those systems. Many, many other applications have this simple feature built in to their products, especially service desks. I believe there would be a huge benefit to this very simple bolt on.

0 Likes

I run into this a bunch.  There are some Alteryx workarounds for some use cases but not all.

 

 

0 Likes

Hi,

Is there an easy way through Alteryx to rename a file once I have processed it... Would like file name to be- FileName.csv.Date.Time (FileName.txt.20180424.055230)

 

 

Thanks.

 

 

 

 

 

 

0 Likes

 

Why do we need yxmd files? Why shouldn't the default be yxmz? The workflow logic is the same. If you don't add any interface tools it will run, and it you want to have a interface you can. 

 

If you start off with an yxmd and then decide to make it an app you now have two files to worry about.  

 

As a habit I no longer save things as yxmd. As soon as I start a new workflow I save it as an yxmz.

 

Thoughts?

 

0 Likes

The layout of tables in the Visual Query Builder should be persistent.  The placement, made by the user, should be persistent when called-up again.

0 Likes

Hello,

 

It would be nice if Alteryx had a way to create a time lapse video based on a date field.  Create a map showing data over time (day, week, year, etc) that shows it cumulative or individual for each time frame.  I needed to map a set of location points, with a date field, to show where and when they opened throughout time by each year or by each decade, so it starts with only a few locations, then keeps adding the new locations with time to show all locations at the end or present time.

 

Thanks,

Bob

0 Likes

I have encountered problem with Oracle Direct Connection tool. I have the correct host, port, service name, user name and password (the same configuration works with Toad), but Alteryx still complaints the service name is not found on tnsnames.ora (ORA-12154). Well, the reason to use Direct Connection is that I do not have admin rights on my computer to edit the file, so it seems this kind of problem can only be resolved by reaching out to our IT service to edit tnsnames.ora for me.

 

Alteryx2.png

0 Likes

I would like to able to limit the data being read from the source based on the volume , such as 10GB or 5 GB etc. This will help in case of POC's where we can process portion of the dataset and not the entire dataset. This will have many different used cases as well.