I love the dynamic rename tool because quite often my headers are in the first row of data in a text file (or sometimes, Excel!).
However, whenever I open a workflow, I have to run the workflow first in order to make the rest of the workflow aware of the field names that I've mapped in the dynamic rename tool, and to clear out missing fields from downstream tools. When a workflow takes a while to run, this is a cumbersome step.
Alteryx Designer should be aware of the field names downstream from the dynamic rename tool, and make them available in the workflow for use downstream as soon as they are added (or when the workflow is initially opened without having been run first).
I would like to see Global Variable being made available in Alteryx. I have seen the Global Constant being made available under Workflow "User" configuration. But this is constant and needs to be defined at Design time.
How about a Process Id that needs to be auto genearted and the same needs to be available across the formula tools used with in the workflow.
I would like to have something similiar to in SSIS called as Sequence Container implemented in Alteryx. A sequence container would ensure that the process flows in a particular order. Lets say I would like to read 3 different files having different schema each and I want to read/validated it in particular order. I don't see any tool that would help me do this.
The Delete and connect around in the right click menu is really nice for not having to go find the connector and re plug it in. I would ask that there is essentially the same option when cutting a tool. When the tool is cut the data path is uneffected. Also, it would be nice to be able to right click(or left click and ctrl+v) on a data path and paste the tool directly in, instead of having to paste then connect everything back up. Lastly, I often find myself pulling out the wrong tool/wanting to replace a tool with another. I think it would be nice to have the option of dropping a toll directly onto another to replace it. Again connecting drectly into the data path.
So have been using the fuzzy match function quite a bit of recently. Love the tool, however it could benefit form being able to wire in a list of 'Don't generate' keywords.
At the moment we can enter them manually, however where for example i might want to exclude city or area names etc... from the do not generate list this becomes quite a tedious manual entry task, so being able to load in keyword data from pre-existing lists etc.. would be a time saver.
We have a large SAS Programming team that keeps most of thier data sets in a Unix environment. A more robust ODBC connection to this data would greatly enhance our use of Alteryx. The current SAS odbc Driver tends to lock Alteryx up. Creating edits to the connection also tends to lock ateryx up to an unrecoveable point.
It would be nice to improve upon the 'Block Until Done' tool.
Additional Features I could see for this tool:
1: Allow Any tool (even output) to be linked as an incoming connection to a 'Block Until Done' tool.
2: Allow Multiple Tools to be linked to a 'Block Until Done' tool. (similar to the 'Union' tool)
The functionality I see for this is to enable Alteryx set the Order of Operation for workflows and Allowing people to automate processes in the same way that people used to do them. I understand there's a work around using Crew Macros (Runner/Conditional Runner) that can essentially accomplish this; howerver (and I may be wrong). But it feels like a work around, instead of the tool working the way one would expect; and I'm loosing the ability to track/log/troubleshoot my workflow as it progresses (or if it has an issue)
Happy to hear if something like that exists. Just looking for ways to ensure order of operation is followed for a particular workflow I am managing.
It seems that I'm unable to use my mouse wheel to scroll through or "Control + A" to select all in the "Table or Query" field of the "Connect In-DB" tool. I have to click the top of it and drag down the text to highlight it all.
Idea: Allow the user to set the data type including character field width in the Text Input tool.
The Text Input tool currently auto-senses the correct type and width of the field in a Text Input tool. However, this sometimes restricts the usage of the data downline.
1 - I often run into the situation where I've copied some data from a browse tool and then pasted that as an input to a new workflow. Then I'll turn that workflow into a macro. But then I run into an issue where the data that comes into the macro is larger than the original width in the Text Input tool. This causes problems.
2 - The tool senses that a field containing zip codes should be numeric and then converts the data. This corrupts the data and makes me insert a Select/Formula tool combo to pad the zeros to the left.
As of Version 10.6, Alteryx supports connecting to ESRI File GeoDatabases from the input tool but it doesnt support writing to a geodatabase. This is something we would really like to see implemented in a future version of Alteryx. Those of us working with ESRI products and/or any of the ESRI online mapping systems can do our processing in Alteryx and store large files as YXDBs, but ultimately need our outputs for display in ArcOnline to be in shapefile or geodatabase feature class format. Shapefile have a size limit of 2 GBs and limitation on field name sizes. Many of the files we are working with are much larger than this and require geodatabases for storage which are not limited by size (GDB size is unlimited, 1 TB max per feature class) and have larger field name widths (160 chars). Right now, we have to write to one (or many) shapefile(s) from Alteryx, then import them into a GDB using ArcMap or ArcPy. This can be an arduous process when working with large amounts of data or multiple files.
The latest ESRI API allows both read and write access to GDBs -- is there a way we can add this to the list of valid output formats in Alteryx?
In the workspace (i.e. the white space) the perimeter is not fixed so when working with tool containers near a border and you place a tool inside the container the container expands outside the workspace, which makes the container useless since you can't select it
The ability to disable multiple tool containers at once
I utilize the Workflow Events quite a bit, but the standard options fall short in a few critical cases.
For example: I use the events to send me an email after the workflow runs with errors.
Usually that is all I need. But, I have run into a few situations where the workflow didn't run at all - thus, no email was sent.
One such instance was on our server. While still initializing (before it even hit tool #1) the job hung. It sat like that for over a day before I noticed that there were no jobs running through a particular worker at all and saw this one sitting there.
A second such instance was recently when I changed Persistence Options and accidentally deleted the source for a scheduled job. The workflow marked itself complete in the scheduler and gave an error message of "Corrupt: Internal Error in PersistenceContainer......"
I realize that these are unexpected events and application errors (which I've worked with support on); but it would add great value to have that fallback mechanism to let us know the error happened.
Understandably, it would probably take a lot of work to engineer a schedule monitor that would catch this - but I think it would be worthwhile.
One option to do this: have an Event to email or run a command if a workflow hasn't started within a certain grace period after its scheduled time.
I have been using Alteryx for not a very long time, but allready feel frustated by the difficulties when it comes to access the data result shown in the Browse Tool (from Linear Regression, Principal Component Analysis, etc.).
Lots of the output shown here is really important data that you really want to be able to access for further analysis in Alteryx or in another tool.
This data should be easy to access, following the Alteryx self-service philosophy.
It would be great if we users could have the ability, ideally in a simple interface (maybe workflow option) to create .yxi macro installers. This would allow us to create and really simple, quick and straightforward way on installing macros in Alteryx rather than having to copy into certain directories or add through the user settings.
I know we can edit the XML on
@AdamR CREW Macro installers etc. but this would make it really simple for single macros.
I'm assume this might already be on the road map, but will be useful to discuss.