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.
Sometimes formulas get pretty long. There are cases of deeply nested conditionals, concatenation of long strings, cases where multiple casts and parses are used, etc. where formulas get pretty large and unwieldy. The current system of wrapping lines and managing the size of the properties pane can be a hassle, especially if you are trying to use any sort of whitespace formatting to make the formulas more readable.
My solution is this is pretty simple, add a pop-out window for formulas. It could be a context menu option from right-clicking the formula box itself, a button on the bar at the top of each formula, or any number of other things.
A really good example of this is MS Access. You can right-click any text box that takes an expression and open it in the expression editor pop-up window. The current system is more like excel where you're stuck with whatever box size you're given.
I would like to have all my annotations show on top of the tools by default. I can change them one at a time, but I would like to be able to change the default setting to be "Show Annotations on the Top" always.
I really love how I can drag and drop a file directly onto the canvas from Windows Explorer and Alteryx knows to create an Input Data tool. But when I tried it with a folder today, hoping to see a Directory Input tool appear, it wouldn't do it. Could we have a similar functionality for automatically creating a Directory Input tool?
Was very happy to see the Bulk Loader introduced for Snowflake during last release. This bulk loader is specifically available for Snowflake environments that are hosted on AWS, but does not provide functionality for those environments using Azure. As Snowflake continues to build momentum, I imagine this will be a common request. Is there something in the pipeline to add this functionality?
For an interim solution, we will be working toward developing some generic scripts/snowsql to mimic that bulk load, but ultimately we'd love to have this as part of the tool.
I like the new cache option in 2018.3, but I would like it to function a little bit different. Let's say you cache at a certain point and then continue to build after that. If I reach another checkpoint and want to cache, it currently re-runs the entire workflow (ie it ignores my cache upstream and just goes back to the beginning of the workflow); instead, I would rather have it utilize the upstream cache. Personally, caching is usually an iterative effort during development where I keep caching along the way. The current functionality of the cache is not conducive to this. Thanks!
We have recently upgraded to 18.3 and noticed that the Filter tool expression box has lost its colour coding of expression elements. The Formula tool (which still has the 18.2 look and feel) however still has the old colour coding.
It would be great if the colour coding could be included for all tools with expression editing boxes.
I like the new cache option in 2018.3, but I would like a user setting added that would allow me to 1) write the cache files to a local drive and 2) have them persist when I re-open Alteryx. Currently, the files are written to the user defaulted temp space and don't persist when Alteryx is closed down. Thanks!
I'm only just starting to explore the python and html sdks, but I think this functionality would be really useful for Alteryx tools.
I foresee cases where a custom tool is developed and we want to install it for 20+ users. Rather than having each user manually open and install the file, and troubleshooting for each of them (which could also become challenging if we want to deploy an enhancement to a tool in the future), I'd like a method (preferably via command line) to automatically install a tool for a user without any interaction/input.
This would allow for targeted tool deployment as well as large-scale tool maintenance as custom Python tools mature in the enterprise space.
Alteryx's spatial tools are really powerful and offer a lot of value for analysis. However, when rendering a map for output, there is currently no way to place an image inside of a polygon. This feature would be very useful for customized layers on maps and other spatial-based processes.
My rough suggestion would be to scale a selected image to the size of the polygon's bounding rectangle, and then trim the edges of the image to fit inside the polygon itself.
I've seen this question before and have run into it myself. I'd like to see a new tool that would allow a developer (of a workflow) to choose a path of logic based upon criteria known only during the execution of a module.
If LEFT INPUT Count of records < 10,000 THEN Path1 (e.g. use a calgary join)
All the items in the 'View' menu have useful shortcuts. For instance, I'm always using Ctrl+Alt+D for the interface designer.
It would be nice to be able to quickly check workflow dependencies; at the moment there are far too many clicks to get there given the amount they are accessed (by myself and my colleagues at least...)
Quite often the window is only required briefly to check whether absolute/relative paths are used and to see inputs/outputs. It would really improve speed and ease of use if the window could be brought up with a couple of key strokes.
I constantly find my using pre and post SQL Commands in the Output tool to run SQL when I don't actually have any data to output.
One example is when I load data into S3 and want to load it into Redshift. I have SQL code to run but no data to Output - I end up running a dummy row into a temp table.
So can we have an SQL tool that simply acts the same as a Pre-SQL command without the associated data output. Once the command is run we should be able to continue the workflow, so the tool should have an option input and output, like the Run Command tool.
Now that Alteryx releases updates to Designer every quarter I'll likely be updating my copy of Designer frequently. Meanwhile, my IT team doesn't want to have to update Server every quarter to stay compatible. Problem there is, when I create workflows in the latest version of Designer they can't run on the older version of Server, nor on the Gallery.
Some features that would allow me to work around this:
If I could elect what version I want to use when uploading to the gallery.
If instead of having to upload workflows from within Designer (which thereby opens the workflow in whatever version I have installed on my machine) I could upload workflows from the Gallery website by navigating to a folder on my directory and selecting a given workflow. That way I could open the workflow in Notepad beforehand and alter the version number to match Server.
I'm guessing this is a niche problem that few others will encounter:
Not everyone is as big a nerd as me and will insist on updating Designer each quarter
Other companies may have IT teams that update Server each quarter
You can install an admin and non-admin version of Alteryx on your machine (I plan on doing this once IT responds to my internal service request).
You could use the admin version for the latest and greatest version of Alteryx
You could use the non-admin version to match whatever version of Server IT has installed and use that to upload (first opening the workflow in notepad to manually overwrite the version number to match server)
Maybe it was a lack of planning, but I've had a need to rename a variable within a workflow and would like to (outside of the XML view) be able to rename the variable so that downstream tools don't have to be reconfigured (e.g. formula, join, union).
I work as an accountant for one of the nation's largest firms. In my day-to-day work, I utilize alteryx to cleanse and format data provided by our clients in preparation for use in another program that is very specific with its imports.
I was recently reviewing an Alteryx workflow prepared by a colleague. Upon attempting to run it again (with new input data) I noted some data fall out and am now reviewing the workflow tool by tool (first to develop understanding of the developer's mind, and second to make changes where needed).
During this review, I thought it would be very cool to have a Review/Markup view, where each tool could have a checkbox that could be checked/unchecked if that specific tool was reviewed/unreviewed. There could also be a circle function that could bring attention to specific places that are of concern in a workflow. This might work similar to how when one drags an Interface tool on the canvas, appropriate connections above non-Interface tools appear, only it would be a view that could be turned on/off.
In addition, I have a tendency to annotate the heck out of my workflows I create -- however there isn't really a way for reviewers to do this without modifying the workflow annotations nor adding a Comment tool with comments. It's especially difficult to do the later since space might be tight. Having a comment function that only shows up in the Review/Markup view would be amazing and very appreciated as I don't want to visually alter the workflow to accommodate such comments if it can be helped.
It would be even more helpful if a review/markup report (maybe a temporary PDF or .yxdb) that would summarized what was summarized as "reviewed, with no comments", "reviewed, with comments', "unreviewed, with comments", "needs attention", etc.
Lastly, with regards to fallout data, I would like to tag/trace a record and, after running the workflow, have the last location of that record be circled in red (or some other visual cue) on the canvas. Currently, I just create a "Flag" column (or, if it works, track a specific RecordID in Alteryx and follow my best guess of where the data may have fallen off -- something that can be very time consuming when I'm not familiar with the workflow.
The organization I work for has experienced some of the best time savings from Alteryx and currently supplies licenses to our staff members. In particular our Audit function may need to review some client processes, which may be entirely in some part Alteryx. As our managers attain Alteryx familiarity, they may also want to review our workflows for completeness and data integrity purposes. Having these functions above would definitely be something to look into and would further drive the review function further away from other more archaic programs and increase our usage of Alteryx throughout, and I'd be happy to be part of a testing for this if possible!
It would be really cool to have a workflow that you could configure to your server that we could schedule to pull down the new Cass updates and install them. Since they have to be reinstalled every two months, it would help to manage that.
I think that the data updates are set up with an FTP site, Cass could be done essentially the same way. Download it there and then use the command module to run the install? I may be over simplifying the process but it seems like this is something that Alteryx could tackle.