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

I would like to see more files types supported to be able to be dragged from a folder onto a workflow. More precisely a .txt and a .dat file. This will greatly help my team and I do be able to analyze new and unknown data files that we receive on a daily basis.  

 

 

Thank you. 

Hi GUI Gang

 

At the moment, I have a lovely formatted XLS with corporate branding, logos, filled cells, borders etc.  The data from the Alteryx output needs to start in cell B6.  I have tried the output tools to this named range, but Alteryx destroys all the Excel formatted cells in the data block.

 

As a workaround on the forums, many Alteryx users pump out to a hidden "Output" tab, and then code =OutputA1 in the formatted sheet.  This looks messy to the users who then go hunting for the hidden tab.  Personally I end up pumping the workflow out to a temporary CSV file.  Then opening that in Excel, selecting all, and then pasting values in the pretty Excel file.

 

This is fine for one file, but I need to split the output report block by a country field and do this 100s of time for each month end.

 

Please can we have a output tool that does the same as my workaround.  Outputs directly from a workflow to a range in Excel that doesnt destroy the workbook's formatting.

 

Jay

My specific use case relates to writing to AWS but am sure there are many other use cases for federated user session token support.

 

Specifically, using the S3 Upload tool or Athena Bulk Write (via SIMBA and Athena ODBC), the configuration works when using a IAM user, access key, and secret access key but when using a federated user via Okta there is no option to enter the session token and authentication fails.

Alteryx desktop should support federated users' session tokens.

I just got out of the Advanced reporting session at the Alteryx inspire convention. Preety cool stuff. I just have a request for the alteryx developers team. Can you please add the option to select a report coming from a Render tool directly as an attachment without having to write it out first? Just select it as a field the same way you can select a field as the body of the email. That'll make my workflow more streamlined and save space, as I'm sure it'll do for a lot of fulks out there.

We use Alteryx to extract the reports from 3D CAD system.


https://community.alteryx.com/t5/Alteryx-Use-Cases/Toyo-Engineering-Reduces-its-Workload-to-a-Fracti...


XYZ coordinate system is used in 3D CAD system but spatial function in Alteryx is applicable only for lat/long system.

Polygon generated by Alteryx can’t be imported into Tableau with proper scale and other useful spatial function can’t be used, neither.

 

It would be nice to have options to use XY coordinate system in addition to lat/long.

If XYZ, 3 dimensional coordinate system can be handled to calculate distance and overlap, that would be great.

Alteryx should raise a Conversion Error if re-sizing of a string field in a Select tool results in data truncation. It does this for integers but if a string is truncated there is no indication of this in the workflow output.

Hello Product Management,

 

I'm trying to emulate a graph from the book, Effective Data Visualization by Dr. Stephanie Evergreen.  Here's what I have so far:

 

capture.png

This was a little bit of work to create and while it isn't what I exactly had hoped for, it does approximate my attempt.  Ideally, I would do the following to complete the exercise:

  1. Have a Y-Axis (none) line on for both Old/New Sites (dual-axis)
  2. Replace the Y-Axis number with the Label for the departments
  3. Remove the (line) from the label

As observations, in order to add carriage returns to NOTES, i had to use HTML tags <br>.  The settings for points and lines required me to do lots of configuration.  Maybe a format painter would help to copy the format from one set of point/lines to the next.  Once I completed a chart/insight it would be "nice" to be able to copy and configure the other.  If you have an insight and wish to create a chart, you have to reconfigure the new element from scratch.

 

I do have an error in the creation of the chart that says, "Error parsing configuration."  I have no idea what error exists.  I submitted a ticket on that issue.  

 

I haven't created this chart via Excel, but the textbook shows you how to create the result in Excel.  The graph is easy for me to see and to understand.  I like it and think that it could be a valuable way to demonstrate the potential for Alteryx visualizations.

 

Cheers,

 

Mark

Every time we create a file output - you first have to check if the folder exists - and if not then create it.

 

Currently it's quite onerous to do a directory create - especially with all the error trapping to make this production safe - and everyone is reinventing the wheel in their own companies.

 

Given the commonality of this need - could we add a tool that allows you to check for existance of a directory and attempt to create it (with nested directories and useful status / error descriptions to act upon)

The "Manage Data Connections" tool is fantastic to save credentials alongside the connection without having to worry when you save the workflow that you've embedded a password. 

 

Imagine if - there were a similar utility to handle credentials/environment variables. 

 

  • I could create an entry, give it a description, a username, and an encrypted password stored in my options, then refer to that for configurations/values throughout my workflows. 
    • Tableau credentials in the publish to tableau macro
    • Sharepoint Credentials in the sharepoint list connector
  • When my password changes I only have to change it in one place
  • If I handoff the workflow to another user I don't have to worry about scanning the xml to make sure I'm not passing them my password
  • When a user opens my workflow that doesn't have a corresponding entry in their credentials manager they would be prompted using my description to add it.
  • Entries could be exported and shared as well (with passwords scrubbed)

Example Entry Tableau:

AliasTableau Prod
DescriptionTableau Production Server
UserIDJPhillips
Password*********
+ 

Then when configuring a tool you could put in something like [Tableau Prod].[Password] and it would read in the value.

 

Or maybe for Sharepoint:

 

AliasTeamSP
DescriptionTeam sharepoint location
UserIDJPhillips
Password*********
URL http://sharepoint.com/myteam
+ 

 

Or perhaps for a team file location:

AliasTeamFiles
DescriptionRoot directory for team files
Path\\server.net\myteam\filesgohere
+ 

 

Any of these values could be referenced in tool configurations, formulas, macro inputs by specifying the Alias and field.

1-3-2019 12-43-52 PM.png

Sometimes I want to test portions of a workflow, independent of other portions.  I find myself adding containers, just so I can disable some of the time consuming portions that are not part of my test.  It would be nice to be able to enable/disable any portion of a workflow, on the fly.  Or maybe just disable/enable any connection with a right-click.

Thanks!

Gary

Problem:

When searching for Alteryx help on Google the search results rarely return the current version of the Help documentation from the Alteryx website. Instead, what often happens is that an old version of the Help documentation is returned.

 

For example, a search for 'Run Commend Tool Alteryx' returns links for the 2018.3 and 11.3 instances of the help page:

 

Screenshot 2019-05-15 at 16.30.00.png

 

These relate to prior versions of Alteryx and a better result would be to link to the /current/ version of the page (the URL for which never changes).

 

https://help.alteryx.com/current/RunCommand.htm

 

The problem above can be replicated for almost any tool or variant of search terms.

 

Since Google is such a crucial resource for troubleshooting, there is a risk that (a) users will inadvertently access out of date documentation and (b) users will be confused by the presence of multiple search results.

 

Solution:

By adding a 'robots.txt' file to web pages for prior versions of the tool these results can be suppressed from Google search results.

 

https://support.google.com/webmasters/answer/6062608?hl=en

 

This should result in the /current/ documentation pages rising in search results and being more prominent when users search for help on Alteryx using Google.

 

Would be nice to have 3 outputs on Spatial Match, same as a standard Join.  Output unmatched objects from the Universe input.

Thanks!

I think I'm liking the new UI, but I think it's necessary to bring back save, undo and re-do buttons....

 

1. Frequent saving of workflows is crucial and not everyone uses keyboard shortcuts

2. The ability to undo (lots) of changes is a key part of iterating and rapidly building workflows in Alteryx and again not everyone uses keyboard shortcuts to do this.

 

Looks like there's potentially space to add this to the right of 'help' (I suspect this might be technically quiet difficult) or to the left of 'run', 'schedule' and 'active documents' as seen in the image below.

 

Out of interest, where has the 'documents' terminology come from?

 

2018-11-14 22_12_14-Alteryx Designer x64 - PureGym Log In.yxmd_.png

 

 

 

I really like that I can scroll -- using my mouse -- between the tool groups in Alteryx. Can this UX be added to scroll through my workflows? I usually have a bunch open, and this functionality would be awesome to have there, too! Smiley Happy

 

PS: Yes, I know I can do Ctrl+Tab...but mouse scrolling is more efficient.

 

idea.gif

There's often a need to do a cascade of filters which would normally be handled in a programming language by a Case or a Switch statement.

For example:

- if it's a cat then go left, otherwise go right 

      - if it's a dog then go left otherwise carry on right

             if it's a fish then go left otherwise carry on right

                   otherwise do xxxx

 

This could be handled more elegantly by a conditional split tool that allowed you to specify multiple conditions like a case statement, and which then generated multiple output nodes; with the last one for any leftovers.

 

 

When you drag a comment box into a workflow it should sit underneath all other data tools by default.

 

Currently, the order of tools is set by the order of placement (that is, tools placed in the workflow first are placed below subsequently placed tools).

 

Who needs a 1073741823 sized string anyways?  No one, or close enough to no one.  But, if you are creating some fancy new properties in the formula tool and just cranking along and then you see that your **bleep** data stream is 9G for nine rows of data you find yourself wondering what the hell is going on.  And then, you walk your way way down the workflow for a while finding slots where the default 1073741823 value got set, changing them to non-insane sized strings, and the your data flow is more like 64kb and your workflow runs in 3 seconds instead of 30 seconds.  

 

Please set the default value for formula tools to a non-insane value that won't be changed by default by 99.99999% of use cases.  Thank you.

 

 

Often as I am scraping web sites, some clever developer has put an invisible character (ASCII or Unicode) in the data which causes terrible trouble.

I've identified 89 instances of zero-width or non-zero-width glyphs that are not visible and/or Alteryx does not classify as whitespace. There are probably more, but Unicode is big y'all.

Unfortunately, the Trim() string function only removes 4 of these characters (Tab, Newline, Carriage Feed, and Space).
REGEX_REPLACE with the \s option (which is what the Cleanse macro uses) is a little better but still only removes 20. And it removes all instances, not just leading and trailing.

I've attached a workflow which proves this issue.


@APolly: this is what I mentioned at GKO.

And I did see this post (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Elegantly-remove-all-ASCII-characters-...), but it's too brute force. Especially as Alteryx is localized and more users need those Unicode characters.

Hello,

As I mentioned in this previous idea : https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Generic-In-database-connection-please-stop-i...

 

field mapping in generic in-db connection is based on Microsoft Sql Server. Given the specificity of MSQL Server field types, I would like to change that in order to at least be able to use another database. Without that, this feature has no sense at all.

Best regards,

Simon

In-DB_idbx2_325x127

 

 

 

If you are connecting to an Oracle database you can get faster results with adding a short hint to your SQL query. For a query like this

 

 

SELECT customers.cust_first_name, customers.cust_last_name, 
MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;

 

 

add /*+ PARALLEL(4) */  (or depending on your CPU size 8) and that SQL becomes this;

 

 

SELECT /*+ PARALLEL(4) */ customers.cust_first_name, customers.cust_last_name, 
  MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;

 

 

There is a similar capability for SQL Server too...

 

SELECT *
FROM Sales.SalesOrderDetail
OPTION (MAXDOP)

 

 

I suggest adding this feature in in-db tools so that no one needs to alter the SQL query itself...

 

You can check out the inner workings for oracle here; https://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm

Top Starred Authors