This is a QoL-request, and I love me some QoL-updates!
While I'm developing I often need the output of a workflow as input for the next phase of my development. For example: an API run returns job location, status, and authentication ids. I want to use these in a new workflow to start experimenting what'll work best. Because of the experimenting part, I always do this in a new workflow and not cache and continue in my main flow.
Writing a temporary output file always feels like unnescesary steps, and tbh I don't want to write a file for a step that'll be gone before it reaches production. Esp if there is sensitive information in it.
I surprisingly couldn't find this anywhere else as I know it's been discussed in person on many occasions.
Basically the Formula tool needs to be smarter in many ways, but this particular post focuses on the Data Type component.
The formula tool, should not always default to V_String as the data type when entering data or a formula into the formula tool, it should look at the data type and estimate the most likely option.
I know there are times where the logical type might not be consistent in all fields, but the Data Preview and the Function of the formula should be used to determine the most likely option.
E.G. If I type a number or a date directly into the formula tool, then Alteryx should be smart enough to change the data type from the standard V_String to Int, Double or date.
This is an extension to the ideas posted here:
I often need to create a record ID that automatically increments but grouped by a specific field. I currently do it using the Multi-Row Formula tool doing [Field-1:ID]+1 because there is no group by option in the Record ID tool.
Also, sometimes I need to start at 0 but the Multi-Row Formula tool doesn't allow this so I have to use a Formula tool right after to subtract 1.
So adding a group by option to the Record ID tool would allow the user not to use the multi-row formula to do this and to start at any value wanted.
We have 'CountDistinct' and 'Concatenate' options within Summarize tool.
But 'Concatenate' displays all the instances of value for a Grouped field, this might include lot of duplicates.
It would be great to have an option like 'ConcatDistinct'.
For example -
Group by 'Branch' and 'ConcatDistinct' Customer should result as Figure 1 instead of Figure 2 -
While this is achievable in different ways currently with a set of tools, but it gets tedious when number of fields is large from which distinct values are to be captured.
As each version of Alteryx is rolled out, it would be much easier for our users and admin team to validate the new version, if Alteryx allowed parallel installs of many different versions of the software.
So - our team is currently on 11.3 - if we could roll out 11.5 in parallel then we could very easily allow users to revert to 11.3 if there are issues, or else remove 11.3 after 2-3 weeks if no issues.
The same goes for versions which are in BETA.
This would be a huge help!
When creating a workflow I generally open a "TEMPLATE" first and then immediately save it to the "NEW WORKFLOW NAME". My template includes all my preferences that aren't set naturally within the user settings and won't get RESET by them either. It has a comment box and containers as well as logos and copyrights. It would be nice to have ready access to this feature. Maybe others have standards that they want applied to all users and their workflows too.
(1) I would like to have more text formatting options available in the Comment Tool, such as:
(2) Option to remove or recolor the blue outline of the comment box. (Especially when I have a comment in a color-filled comment box, I would prefer a comment box without a dark outline.)
(3) UX - Add an arrow cursor to indicate resizing functionality
When building a workflow with testing tools, you tend to want to be able to put these in container and then minimise this to improve readability of the workflow.
For example instead of this:
You might want to minimise the error checks like this:
However when running apart from reading through the results window, there is no immediate indicator that there is a tool inside the container that has errored:
So the feature enhancement request is to add in an exclamation marker to show the user that a tool inside has an error and you can then easily open it up and investigate further.
Having the open / close ( expand / collapse ) button for the tool container in lhe top right corner implies that everytime a big container is expanded, to close it the user has to move the pointer to its new position, which sometimes mean scrolling / zooming out and then zooming in to locate it.
I suggest to locate that button in the top left corner by the side of the enable/disable switch or even a double click mechanism for open/close, which would enable to user to open, see what is inside the container, and close it without moving the mouse to locate the new location of the button.
I wasn't able to find an existing idea for this, so here goes...
We often put URLs in Comment boxes in order to direct workflow users to different resources, but users are then required to go into the Comment and copy the string (and then paste in their browser). It would be quite handy if the Comment tool simply turned text strings with a url format into clickable links (as seen in Word, Slack, etc).
It would be even more handy if it also had basic text formatting tools (bold, italic, underline, coloring, highlighting of specified characters/words) -- or if it could just render html (like this text tool I'm typing into right now) 😎
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.
Can we set our own Comment tool default preferences? - For me I want to set the text alignment to be "Center" by default, currently it's always "TopCenter" when I open it.
Can you put a check box on the container title bar to make it easier to enable/disable containers in the process window? And can you make the minimize/maximize option for a conatiner a separate option from enable/disable?
I would like to see a "tool" that you can use as an off-screen connection (pair) between data anchors. Currently, you can create "wireless" connections between anchors. This essentially helps, but isn't friendly if you add/modify contents between points A & B. It also doesn't aid in documentation of the workflow.
If by comparison, I put a connection tool on at point A it would be great to see it annotate itself with the incoming Tool ID and when I connect it to the paired point B, it would similarly explain the incoming tool id onto that point too.
I currently use a SELECT tool to explain visually that this data is being used elsewhere. I create a wireless connection to the receiving data (could be multiple) and document the source. The performance of the workflow may be slowed by these select tools.
I'm very open to other ideas or reformats of this proposal. I don't think that it is going to change the world, but it would help me with my OCD.
When we have too many steps in a workflow, it is mandatory to use container to represent better business flow. It can collapse many steps to represent one business flow.
But, when we open collapsed tool container, workflow canvas not resizing to give space for tool container, it overlap on existing tools.
It is better to resize workflow canvas when we collapse or resize tool containers.
Maybe they get bigger when you hover, so its easier to grab? Thanks 🙂
It would be great if it were easier to add a comment tool to the canvas. As I think about what my workflows are lacking, it's good documentation. My biggest hurdle...is myself. I am simply too lazy to stop what I'm doing and add comment tools. What if you could either 1) double click on the canvas and it brings in a comment tool where I can start writing comments or 2) add a Keyboard short cut in order to add a comment tool (control + shift + C perhaps)? Either of these would help me build better documented workflows.
I often search for a tool on the canvas using control find and the tool number. If the tool is already in the visible pane, Alteryx highlights the tool with a faint dotted box. The problem is that I often have hundreds of tools that are visible and I have to constantly hunt around the canvas to locate the highlighted tool. Please update the control find settings so that when you use control find, Alteryx centers the current view on that exact tool. That way your eye can scan the middle of the canvas and locate the tool every time without this wasted effort searching for the tool outline.
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).
I am currently using alteryx to generate pdf reports and noticed there is no option to have multiple row headers. In my line of work i cant skip this as the end users insist on having it like they have always had it.
I definitely think this should be available as many of us like replicate canned reports which are otherwise in excel and hence see the need for such an option.
The following might give an example of the multi row header,
Also the ability to merge certain columns to create the above effect should be available.
I love using containers, but depending on how I am moving around the workflows or trackpad (when traveling) I find it hard to navigate quickly getting a container on the canvas between either add a container from the tool palette or having to highlight the tools and right-click for menu navigation to add the container. This ranks up there with the hotkeys for aligning the tools which make for quick work of making the workflow look organized and presentable.
*This is an idea from @sayuri from the Portuguese Community*
We are working on building out training content in a story mode and would like to have short snippets playing in a loop for people to see embedded in the workflow. Currently you can add a .gif to a comment background and it will provide a still image on the worklfow itself but functions as a gif in the configuration display. The interesting part is when you are running the workflow the .gif works and then it pauses it when the workflow has completed!
So while working through a workflow that takes up a bunch of canvas space, I find myself jumping between two points, one at the beginning and one at the end. Every time I need to jump to the other point, I have to zoom out and scroll over and down and then zoom back in.
What if there was a tool that you could drop on the canvas as a "point of Interest" that if you select it (perhaps) on some other part of the interface, takes you right to that spot in the workflow. I know that currently you can look up tools and it will take you to the location of the tool, but it can be difficult when you are jumping around 4 or 5 different spots to remember which tool number is which.
I would use this all the time!
Just a thought
When looking at a complex canvas - my first instinct is to group this into sub-modules (e.g. "/load Data"; "clean data") to make this simpler to understand.
We mostly do this through the use of Containers.
However - it would be more useful if you could then take an entire container and convert this to a macro. This would be very similar to the way that Visual Studio allows you to take a block of code and convert it to a sub-procedure.
This would be a super-quick way to allow people to make canvasses more maintainable and easier to understand and test!
When documentin alteryx screen I sometimes hit printscreen and need to paste important matters to Comment tool...
But there is no paste from clipboard 😞
I suggest adding a minor icon that enables not only reading from png but pasting a screen or other image copied directly from memory...
For I need the following setting so I printscreen and capture as is;
Then put that into a PNG or JPG file using paint. And then prepare a comment box with that image in the background...