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.
When I use the Comment Tool its difficult to select the tools inside it, but when I use the Container Tool the Container Text doesn't support Font Sizes, and doesn't support multiple lines of text so I end up moving the Comment into the Container, but still have problems selecting a group of tools.
So a combined Comment and Container Tools would be wonderful!
Bonus: If the Comment Tool could support Multiple Font Sizes.
I didn't see it as in the Idea section, but questions and workarounds have been discussed in the community a few times (11/15, 3/18, 4/18), and suggestions seem to be just to buy the $400-600 ODBC driver from CDATA (or ZappySys), or I could use a VBA script in Excel trigger a refresh, or create my own Alteryx connector macro (great series btw, though most was beyond my understanding!)
While not opposed paying, kludging, or learning to program, they're just one more thing to build/buy, install, maintain, and break at the most inconvenient time
OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. OData also provides guidance for tracking changes, defining functions/actions for reusable procedures, and sending asynchronous/batch requests. OData RESTful APIs are easy to consume. The OData metadata, a machine-readable description of the data model of the APIs, enables the creation of powerful generic client proxies and tools.
It's been a while since I was last on these forums, and I can't find the suggestions subforum, only one massive 'Designer' forum. Hopefully I'm posting this in the correct place.
Anyway, the font colour on my Basic filter dialog dropdowns is for some reason bizarrely light and difficult to read. How do I fix this? It used to be a black font, so I'm trying to figure out what I've done wrong. It needs to be darker. Thanks
When a tool container is disabled, I'd like the lines that are going into it to be different from "enabled" lines.
They could be grey or dotted for example.
When working on a workflow and disabling containers, I find that the lines entering disabled containers become confusing or cluttering. It would be much simpler to focus my attention efficiently if lines that remain enabled could be distinguished quickly.
Similar to the Select tool's Unknown Field Checkbox, I figured it would be useful for the Data Cleansing tool to have this functionality as well in order to avoid a scenario where after a cross-tab you have a new numeric field, one of which has a Null value, so you can't total up multiple fields because the Null value will prevent the addition from happening. If the Unknown Field box were checked off in the Data Cleansing tool then this problem would be avoided.
This got me to think a little more about localized logging options in Alteryx.
At a high level, there are ways to accomplish this in Designer at a User or System level by enabling a Logging directory and then parsing those logs with a separate Alteryx job. However, this would involve logging ALL Designer executions, which seems like it may be overkill for this need. A user can also manually save a log after each execution, although this requires manual intervention.
I think adding an option in the Runtime settings for Workflow Configuration to Enable Logging and (optionally) specify a Logging directory would be a great feature add for Designer. In my opinion this should not apply once a workflow runs on Server (Server logging should be handled in a fully standardized way), but should apply to designer "UI" execution. Having the ability to add a logging naming convention (perhaps including a workflow name and run date in the log name) would be icing on the cake.
This would allow for a piecemeal logging solution to log specific flows or processes that might be high visiblity or high importance, while avoiding saving hundreds or thousands of logs daily of less important processes, and of dev test. It would also reduce or eliminate a manual process to save these logs individually.
It would be really helpful if Alteryx server could connect directly to files on cloud file storage such as Dropbox, Box and OneDrive. For example; a workflow could access specific source files or a folder with multiple files stored on Dropbox and could run the workflow against those files and then write the output to another folder on Dropbox. We are making less and less use of internal file servers, so accessing files directly from the cloud allow for additional deployment scenerios and flexibility.
I need to be able to save workflows as a prior version to enable end users with the lower version of Designer to be able to open and run them. I have attempted the version tricks (editing the backup file and changing the version) but I can't get it to work in a way that is realistic for my end users to be able to handle. I have also downloaded a couple of "downgrade" apps from the Gallery but they're so old they didn't work (even with some tailoring).
In our organization, I have a higher version because I was testing it. However, I am also a developer and need to be able to get workflows written that are compatible with at least the last version (i.e. I'm on 2018.2 and our users are currently on 2018.1). I really think there needs to be an easier way to be able to save as a different version (and possibly warn if there are tools within the workflow that are not available on the prior version).
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!
Some Alteryx tools, like Select, update when a field name or data type is changed upstream. Sometimes it causes an error, but often Alteryx can self-adjust and be OK. However, other tools such as Union and Summarize, don't recognize the change - they don't self-adjust or throw an error until runtime. It would be great if these other tools (there must be others besides Union and Summarize) could recognize changes at design time. Even if they just threw an error, it would be better than current state.
This feature isn't a must - but would definitely be a nice to have.
Similar to the excel having a tab with key figures like average, count and sum
It would be a really good idea to do something similar within Alteryx just to have a quick glance on key figures/functions (example attached - apologise for the bad paint job but definitely would look good with Alteryx colour scheme)
I have a dual monitor setup. My canvas lives on the left monitor, and I combine tool config and results on the right monitor. I've noticed that it's incredibly difficult to resize the config vs results window size. This is because you have to hover over EXACTLY the right part of the divider until the resize icon appears, as below:
The difficulty arises because the target zone, over which the cursor changes from an arrow to the resize tool, is only 1 pixel wide. If you have a high resolution screen, or a slightly fiddly mouse, it's almost impossible to successfully hover over the correct place. Please consider increasing the width of the hover zone to facilitate window resizing. I hope I've explained this adequately, please let me know if I need to amend. Thanks!
One of the biggest and most impactful changes would be support for detailed unit testing for a canvas - this could work much like it does in Visual Studio:
In order to fully test a workflow - you need 3 things:
Ability to replace the inputs with test data
Ability to inspect any exceptions or errors thrown by the canvas
Ability to compare the results to expectation
To do this:
Create a second tab behind a canvas which is a Testing view of the canvas which allows you to define tests. Each test contains values for one or more of the inputs; expected exceptions / errors; and expected outputs
Alteryx then needs to run each of these tests one by 1 - and for each test:
Replace the data inputs with the defined test input.
Check for, and trap errors generated by Alteryx
Compare the output
Generate a test score (pass or fail against each test case)
This would allow:
Each workflow / canvas to carry its own test cases
Automated regression testing overnight for every tool and canvas
For this canvas - there are 2 inputs; and one output.
Each test case would define:
Test rows to push into input 1
Test rows to push into input 2
any errors we're expecting
The expected output of the browse tool
This would make Alteryx SUPER robust and allow people to really test every canvas in an incredibly tight way!
I just downloaded the new 2018.4 version of Desktop, and I feel like it's going backwards with the Window UI. I prefer to keep my Results window on a separate screen where I can review it side-by-side with my workflow. I have three large monitors, and I have no need to keep that window tabbed, or docked.
With the removal of he 'Close' option, I no longer have a way of closing that window without putting back in a mode I do not want.
When i first started using Alteryx, the results window acted the same as any normal Windows window, but over time I've lost the ability to quickly maximize the window AND now I can't even close it. One of the most critical windows is getting harder and harder to use.