We have discussed on several occasions and in different forums, about the importance of having or providing Alteryx with order of execution control, conditional executions, design patterns and even orchestration.
I presented this idea some time ago, but someone asked me if it was posted, and since it was not, I’m putting it here so you can give some feedback on it.
The basic concept behind this idea is to allow us (users) to have:
This approach involves some functionalities that are already within the product (like exploiting Filtering logic, loading & saving, caching, blocking among others), exposed within a Tool Container with enhanced attributes, like this example:
The approach is to extend Tool Container’s attributes.
This proposition uses actual functionalities we already have in Designer.
So, basically, the Tool Container gets ‘superpowers’, with the addition of some capabilities like: Accepting input data, saving the contents within the container (to create a design pattern, or very commonly used sequence of tools chained together), output data, run the contents of the tools included in the container, etc.), plus a configuration screen like:
This should end a brief introduction to the idea, but taking it a little further, it will allow even to have something like an Orchestration layout, where the users can drag and drop containers or patterns and orchestrate them in a solution, like we can do with the Visual Layout Tool or the Interactive Chart tool:
I'm looking forward to hear what you think.
This has probably been mentioned before, but in case it hasn't....
Right now, if the dynamic input tool skips a file (which it often does!) it just appears as a warning and continues processing. Whilst this is still useful to continue processing, could it be built as an option in the tool to select a 'error if files are skipped'?
Right now it is either easy to miss this is happening, or in production / on server you may want this process to be stopped.
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.
Love the new updates to the Browse tool in 2019.2! However, if you choose the option Open results in new window, which I do often so I can see my whole dataset, the search/filter/sort functionality goes away. Would be great if that new functionality also worked in the new window. Thanks!
Can't wait for the new base maps!
In-app screens, lot of space is wasted because components/tools can just be stacked one below the other.
It would great if we could also insert them horizontally.
Tags : screen, app, macro, layout, tools, UI
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.
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.
The drop down\list box have numerous ways to list values. One of them that I like is connecting to an external source. You simply have an external source file with a Name column and a Value column. It will display the data in the Name column and pass the data in the Value column. Now suppose instead of connecting to an external source I wanted to use connected tools. Currently, I would have to crosstab this data and the drop down\list box would display and pass the column names.
What if the drop down\list box could have an additional option added where you could connect tools and it would act identically as an external source (display the data in the Name column and pass the data in the Value column). This would be much easier and more functional!
Currently if one wants to compare different alteryx files or different versions of the same file - one needs to compare the XML files. If you are not very familiar with navigating XML, this poses a risk as one may not be able to identify all changes.
It would be a great addition to Alteryx to integrate Alteryx with Git, Subversion, CVS, Mercurial, and GitHub as this tool is becoming the go-to tool for data processing for data analysts and even programmers.
This additional functionality to compare previous versions (diff) and also to merge alteryx workflows if two people are working on the same workflow, and also to easily see what changes have been committed/ made by other developers and when would make Alteryx a much more powerful tool and would open doors to other types of users, as essentially you can run anything through Alteryx.
Hi Alteryx User and Alteryx Dev team,
I saw there are number of posts from the community asking for solution to calculate the NetWorkDays (e.g. similar to the networkdays in excel which to calculate the number of days different between the two days excluding weekend and holidays.)
Although we could build a macro for it, the performance is not ideal, especially when the data set is huge and/or the date range required is far apart from each other because there is currently NO a build-in function in Alteryx. Alteryx will have to expand the date range by date and check whether each is a weekend or holiday. It will an excellent idea if a build-in function for Networkdays could be built to minimize this hassle from everyone around the world.
We are looking forward this idea could be take forward.
Please consider adding the ability in the Power BI Output Tool to create/modify multiple tables per dataset - having to work with only single table datasets in Power BI is very limiting.
The introduction fo a rank tool would be hugely beneficial. Whilst there are currently means to rank using a combination of other tools formula/running total/multirow etc... a specific "Rank Tool" would be provide a seemless and smoother way to rank your data either for further analysis or purely to output this field.
This tool should include a sort by and group by functionaility as well as options for ranking (such as dense ranking or unique ranking) and in addition multi levels of ranking (ie. Rank by "Field A" Then By "Field B" etc...).
As seen in This Discussion Post, the idea here is to be able to add a link to example workflows in macro descriptions - like the ones seen in native tools.
Many thanks to @jdunkerley79 for demonstrating how this can be done by manually editing the macro's XML - specifically by adding a child element to the <MetaInfo> section, like so:
<Example> <Description>Open Example</Description> <File>\\aSERVER\aRootDir\path\to\Alteryx\Macros\Date Wizard\Date Wizard Examples.yxmd</File> </Example>
"Alteryx default behavior is to look for examples under .\Alteryx\Samples\02 One-Tool Examples or Alteryx\Samples\02 One-Tool Examples (or .\Alteryx\Samples\en\02 One-Tool Examples)."
Having said that, trying to reference a macro example in the same folder (using a relative reference) will throw an error given the following situation:
Date Wizard.yxmc XML edits:
<Example> <Description>Open Example</Description> <!-- THIS WORKS --> <File>\\aSERVER\aRootDir\path\to\Alteryx\Macros\Date Wizard\Date Wizard Examples.yxmd</File> <!-- THIS DOESNT <File>Date Wizard Examples.yxmd</File> <File>.\Date Wizard Examples.yxmd</File> <File>./Date Wizard Examples.yxmd</File> --> </Example>
This shows a link in the Macro description but yields an error (shown below) when it is clicked.
Once again, this works fine with an absolute file path reference.
Here is ultimately what I am suggesting: Can we add an option to the Interface Designer (that updates the XML) and have it allow relative paths? Allowing relative paths would obviously be essentially to maintaining the macro's ability to be "lift-and-shift" when packaged/moved/uploaded to servers/galleries etc.
I'm assuming the option could look something like this, similar to the "Help" file -only it would show link in the macro description...
In conclusion, this would be very useful in providing links to example workflows for custom macros that may be complex and/or not self-explanatory.
Is there a way we can turn on and off any tools in the workflow. This way we can run the tool and when a certain tool is marked off it is not executed. This way we can test the workflow and check different output without deleting the tools existing on the workflow, we can just turn then on or off.
I would like to request the ability to connect to a SharePoint List to bring data from and write data to via Windows Authentication. Currently, the only way to connect to a SharePoint List is via username/password which does not work for our current environment.
We frequently report on our data by week. However, the DateTimeTrim function (in the Formula Tool and others) does not support this trim type.
Some workarounds have been posted that involve calculating the day of the week and then subtracting it out:
It would be very helpful to update DateTimeTrim as follows:
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!
PLEASE add a count function to Formula/Multi-Row Formula/Multi-Field Formula!
I have searched for alternatives but am just confused about how to store the result for the total number of rows from Summarise or Count Records in a variable that can then be used within a Formula tab. It should not be that difficult to just add equivalents to R's nrow() and ncol().
Allow users to disable any steps in workflow except input and Join conditions.
To edit existing workflow sometime we may required to remove few steps, it is better if we have option to disable and update mapping instead of delete.
We are starting to use Alteryx as a full ETL DW build tool (and blogging about it too..)
Compared to other tools in the market there do not seem to be the usual SCD(slowly changing dimension) and other "standard" tools or templates to start building.
It would be great to have a template/Macros/guide to starting to build a DW solution. It is rather daunting starting with a blank page!
When you copy and paste a layout tool to keep the formatting you just spent hours fixing it goes away as soon as you paste it. This is infuriating. Please keep the formatting from resting upon pasting.
Attached are pictures of a copy and pasted layout tool connected to the same incoming data source.
You can clearly see that the order and formatting has been removed. #Infuriating
I couldn't find much on enhancing the Tool Container tool searching.
I am doing some work on a large workflow today and have replaced three tool containers with multiple containers within them with macros in order to simplify the overall workflow. Doing this work, I need to document the purpose of this simplification to my stakeholders within the business in terms of business value, and one aspect I thought of would be how much time is saved by wrapping all of these tools within a macro, another is how many tools are visible on the canvas, and therefore how by modulising (creating macros rather than tool containers) sections of the workflow it is much easier to see what's happening to the data
My macro replaces 50 tools with one and therefore this is quite a key quantifiable piece of business value that I can communicate.
In order to count the tools within the old container I had to do this manually. I was wondering - rather than manually count all of the tools within the old container - Could there be some functionality built into Tool containers such as a profiling tool similar to the browse? So that when you clicked on the tool container you would get some simple profiling, summary of the tools used?
Any thoughts welcome!
Note from one of our customers:
All our pharmacy images are mainly tiff format only. Since we don’t have the options TIFF to PNG or JPG converter in the BLOB converter tool in Alteryx.
We are not able convert and display the image from alteryx to PDF or Report display tool in Alteryx.
As our images are critical components of our Reporting options . This impact us to use this tool for the below use cases and we are not able move forward on this activity with Alteryx Tool.
When working with complex modules, it would be great to allow an option to add a tool upstream and automatically rewire to downstreams tools.
Text Input flows to (1) Filter and (2) Formulae Tool. If I want to drag and drop a Formulae Icon after the text input to be applied to both paths, I can't. I have to either choose To apply to Path (1) or to Path (2).
I know that you can right click, press insert after, and search for the tool, but this is not a time efficient manner. You can also delete the wiring and rewire yourself, but if you have mutliple downstream tools, this is a pain.
It would make it a lot easier to create and manage a work stream if you added the standard ability to maximize and minimize the workflow canvas and configuration and results windows.