This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.
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.
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.
I'm trying to emulate a graph from the book, Effective Data Visualization by Dr. Stephanie Evergreen. Here's what I have so far:
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:
Have a Y-Axis (none) line on for both Old/New Sites (dual-axis)
Replace the Y-Axis number with the Label for the departments
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.
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)
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.
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:
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).
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.
By adding a 'robots.txt' file to web pages for prior versions of the tool these results can be suppressed from Google search results.
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?
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!
PS: Yes, I know I can do Ctrl+Tab...but mouse scrolling is more efficient.
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.
- 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.
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.
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.
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,
FROM sales, customers
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,
FROM sales, customers
GROUP BY customers.cust_first_name, customers.cust_last_name;
There is a similar capability for SQL Server too...
I suggest adding this feature in in-db tools so that no one needs to alter the SQL query itself...