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

In Alteryx Designer (version 2018.3.5.52487)

I am getting error ORA-00001 Unique Constraint Violated for any error when updating my Oracle table.

Specifically, my workflow's output tool Output Options is "Update, Insert if new" so I should never get an ORA-00001 error.  If the record exists, it should be updated, if it does not exist, it should be inserted.  The update happens most of the time, however when the update fails, the actual error my database is raising is an ORA-20001 error with a custom error message that I want to pass all the way back to the person reading the workflow log.  When I run an update in the database I receive the correct error: ORA-20001: No overrides to Sales allowed on data in closed periods. INVOICE_NBR=12345.  But the error Alteryx is presenting my user is: Error: MyWorkflow_output: DataWrap2OCI:Smiley FrustratedendBatch: ORA-00001: unique constraint (MY_SCHEMA.MY_TABLE_PK) violated.

Am I misinterpreting the error in Designer or is the incorrect error being presented to me?

 

 

It would be most excellent if I could click directly into the "Enter Expression Here" dialog to start editting my custom filter, rather than having to click the "Custom Filter" radio button.

 

For me it typically requires three clicks to get going. I often start with a "Basic filter" then:

1) Click into "Enter Expression Here" dialog and nothing happens.

2) Remeber that I need to click the "Custom Filter" radio button.

3) Click back in the "Enter Expression Here" dialog to put my cursor where I want it.

 

Thanks!

For people recently met with RegEx, you are lucky if the expression is short and understandable or "human readable".

But there are extreme cases too where it's really a pain to solve the puzzle.

 

if you'd like to catch e-mail addresses from masses of unstructured data this will work;

 

/^([a-z0-9_\.-]+)@([\da-z\.-]+)\.([a-z\.]{2,6})$/

 

and here is the elaboration;

when colorful it's fun but barely readable still... Here is a Regexper version

 

image.png

 

This visualizer I came across at https://regexper.com/ is awesome.

 

  1. Can you please integrate this into Designer for ease of reading and understanding existing RegEx...
  2. Can it be possible to develop an interactive tool to prepare;
    • The graphical representation of our regular expression first
    • And then writing it in the same old fashion...

Please support the idea if you like...

 

0 Stars

Our company is loving the Insight's Tool, but I am constantly being asked by users if they can export the data behind the graphs that is feeding in. For example we have an inventory dashboard for vehicles that starts at a Corporate level, but is drillable down to a "Regional" and then even more focused "Managed Area" level. Once users get down to the "Managed Area" level they want to export the line level data that is feeding into the Insight chart to actually view, work, and action the data at a vehicle level. 

 

Essentially an option to export the data feeding into the graphs. 

Add the option to flip comment boxes, so they can be read down-up, instead of left-right... (see below in red, how it looks and how it could be). 

 

image.png                                 image.png

0 Stars

Use case:  Person running app to select folder from limited list similar to how the tree tool allows for a user to select one or more files.  This selected folder would then be connected via an Action tool to a Directory tool (or by adding a formula tool to a Dynamic Input).  The Folder Browse Interface does not have the ability to restrict or provide a starting parent folder.  The app below pulls data from SharePoint site, which cannot be easily browsed to.  Currently I have the user select a file in the required folder, then use RegEx parse and a Formula tool to pull in all requested files from that folder.  It would be a better user interface if the user selected a folder.  A test sample of the workflow is attached (final version ends in an Alteryx database this is picked up in a chained app).

Good Afternoon,

 

Working with the Alteryx Insight tool there are a few functionality features our team believes would be quite useful:

 

-When you have multiple charts within an Insight the ability to "Drill Out" of an individual graphs versus having to "reset" the entire dashboard would be incredibly useful and save a lot of time

 

-When drilling into graphs we have found users often forget what particular category they drilled into leading to them having to reset the entire dashboard and start over. Could a "legend" type area be added to drill able graphs to show the user what they have drilled into?

 

-The ability to "select all" or "de-select all" options in a filter on the right hand side of the Insight

 

-The ability to drill into your graphs when in the Design Mode or "Configure Insight" to see how any formatting changes impact all layers of your graph once you begin to drill versus having to switch over to Preview Mode and test all layers and then switch back to Design Mode to make necessary changes

 

-The ability to adjust formatting on individual layers of a drilled graph. For example on the x-axis of your first layer have labels set at font size 10 with no angle, but then on your second layer once you drill have the x-axis font size adjusted to font size of 6 at 45 degree angle in the case where your data labels are longer once you drill

 

Thanks,

 

Nathan Brock 

We need an option to schedule a continuous bi-weekly payroll workflow. It is every two weeks starting on a certain day of a week. Some months have 3 and other have 2. If we had an option to select the starting day in a particular month and then select bi-weekly bullet (or every 2 weeks) from that date it would be perfect. thanks

0 Stars

hello,

Recently I used the optimization tool and it's awesome. However, there is no option for sensitivity analysis and It would be great to see it in a future version. Thank you!

 

King regards,

When we create new workflows, we like to have them in our company template, to stnadardise documentation. This makes it easier for a supervisor to review, and for a colleague to pick up the workflow and understand what is going on. For instance, we have all data input on the left, and all error checks and workflow validation on the right, and a section at the top with the workflow name, project name, purpose etc. We have a workflow that we use as a template with containers, boxes and images all in the appropriate places

 

It would be great if there was an option to select a workflow as a template. When a new workflow is opened, it would load this template rather than having a blank canvas.

0 Stars

Since we know Alteryx uses R for a lot of its predictive and data analysis tools. It takes a while to run the workflow whenever there is R based tool is involved. I was told by a solution engineer that its because its opening and closing R in the background.

 

Sometimes my workflow has a bunch of tools which are running R in the background and it takes forever to run the workflow.

 

I think there should be a user setting which allows user to choose if the want to start R along with Alteryx and keep it running in the background.

 

Thanks,

0 Stars

My organization is considering a move to a Microsoft Azure platform but requires support for Bring your Own Encryption (BYOE) or Bring Your Own Key (BYOK). As such, leveraging alteryx on this data lake would require this level of support.

 

I would like to see Alteryx support this in the future, ensuring that we are able to leverage the power of alteryx designer within this platform.

0 Stars

The older versions of the Publish to Tableau Server Macro had an option to Request an authentication token however the latest version does not.  Please return this option to the tool as it is very useful for constructing Rest API call scripts.

 

Thank you!

 

~ Eric Marowitz

0 Stars

Please allow a hover over that would show you the value of a variable in the formula tool. At times I get long formulas and it would be nice to see the values of each variable by just putting your mouse on top of it. Just show the first row like the preview. There is similar functionality in visual studio and it makes coding easier. 

I'm on 2018.2.

 

When I click on existing Comment Boxes out in the Workflow I'd like to be able to tack on additional information within the Comment box.

 

If I hit Enter, I'm not able to type anything in the Comment Box.  I think Enter is taking me out of the Box.  If I hit the space bar, I'm able to type - but a lot of times I'm updating info and I want to start it on a new line.

 

Yes, I know it works fine in the Configuration Window.

 

Can we make the actual Comment Box work like the Text Window in Configuration?

 

 

In the Select tool, it would be very helpful, particularly with tables with lots of columns, to show the number of columns showing and the number of columns selected.  This would help accounting for all columns when having to split up a table's columns for different kinds of operations before joining them back together again.

Typically I drag tools from the tool pallet to my workflow.  Sometimes, when I need to insert a tool into my workflow, I will right click to get the Insert tool dialog to find the tool I want to insert between two existing tools.  With the new UI, it is hard to see the tool categories as these were redesigned for the darker back ground. The preparation category is sandwiched between 3 other categories that start with "P" and I typically lean on the color/shape of the tool icon to find what I'm looking for.  Now I have to read the text to really know for sure. 

 

Perhaps you could lightly shade the middle of the tool category icons to make them easier to see or perhaps make the background behind the tool categories match the new toolbar color.  

 

new ui.pngTool categories icons are hard to distinguish since they are now just light colored outlines on a light background.

0 Stars

Please test/certify Teradata 16.2 for designer, server, scheduler, and Gallery applications.  

When my workflow is done running, this box pops up:

Capture.PNG

Previous to 2018.4, the space bar would select ok and the box would go away. Now the space bar selects the checkbox.

 

Please change it back so that the space bar selects ok.

0 Stars

Can a spell check option be included that will check the spelling in the comment tool text box and tool container captions?

 

Ideally a global check would be nice for the annotation section of each tool, especially if it can be determined if I changed the annotation from the default one on some tools.

Top Starred Authors