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.
The Field Summary tool is a very useful addition for quickly creating data dictionaries and analysing data sets. However it ignores Boolean data types and seems to raise a strange Conversion Error about 'DATETIMEDIFF1: "" is not a valid DateTime' - with no indication it doesn't like Boolean field types. (Note I'm guessing this error is about the Boolean data types as there's no other indication of an issue and actual DateTime fields are making it through the tool problem free.)
Using the Field Summary tool will actually give the wrong message about the contents of files with many fields as it just ignores those of a data type it doesn't like.
The only way to get a view on all fields in the table is using the Field Info tool, which is also very useful, however it should be unnecessary to 'left join' (in the SQL sense) between Field Info and Field Summary to get a reliable overview of the file being analysed.
Therefore can the Field Summary tool be altered to at least acknowledge the existence of all data types in the file?
I have a very large geospatial point dataset (~950GB) . When I do a spatial match on this dataset to a small polygon, the entire large geospatial point dataset has to be read into the tool so that the geospatial query can be performed. I suspect that the geospatial query could be significantly speed up of the geospatial data could be indexed (referenced) to a grid (or multiple grids) so that the geoquery could identify the general area of overlap, then extract the data for just that area before performing the precise geoquery. I believe Oracle used (uses) this method of storing and referencing geospatial data.
Typing econometric formulas within the Formula tools can be very tyring when formulas are long and complex
What would be very nice, would be to have the possibility the get a a kind of "Formula" format (in adition to double , string, datetime ...).
When the format is set to Formula, Alteryx automatically detect that it is a formula and use it as such.
It would allow to import easily external models formulas without to type or paste them within Alteryx
Today I pressed F1 in the Output Tool to find out what the setting Transaction Size does. It turned out that this is not documented.
It would be a great idea to make a documentation that covers the options of a tool.
Can you devise a way to bring out the dynamic network visualisation on to Powerpoint. Right now, we can only see a static image on a browser
Idea to have the option to include the workflow "meta info" (last tab of the workflow configuration when clicking on the cavas) when printing the workflow.
The Meta Info desciption and author sections would be particularly of value. Currently on the long file name is embedded in the header.
When building workflows, it would be nice to have "Save Workflow" and "Run Workflow" added to the right click menu when in the canvas.
Add to Right Click menu:
The "Field Summary" tool and several others have a configuration requirement that provides a list of fields to select or deselect. The selection action is singular meaning you can only effect the action on one item in the list of many. As the number of fields we work with grows significantly this becomes a time consuming and tedious task.
This should be enhanced to allow highlighting of multiple fields to select or deselect as we can do in tools like the "Select" tool.
The field summary tool is an excellent resource to get an overview of the data and spot targets for analysis or data cleansing.
Unfortunately it has limitations either in the number of fields included or some combination of the number of fields and one or more of its attributes. There is nothing in the documentation I found to make a user aware of this. When you exceed N fields selected the system just hangs, indicating it is running but there is no connection progress shown and nothing seems to happen, even if you limit input to 1 record.
Through trial and error I found an approximate limit in number of fields I can include and still have it work.
I request that Alteryx update the tool help info and devise enhancements to dynamically load balance the tool so it can scale to the number of fields requested or at least warn when the limit is reached or approached. The latter warning could be similar to the red font warnings in the formula tool when you have a malformed expression. However a load balancing version is most desired.
The issue as it stands results in users wasting a lot of time trying to make the tool work as expected, then report it to support as an apparent bug in the tool which can be argued both ways.
I realize in the real world there are limits but in this real world we are seeing the number of fields to analyze increase significantly, especially when you have a data license and integrate 3rd party data to you own native data adding a hundred or hundreds more fields.
How about adding the ability to split intersecting trade areas at the points of intersection to create two new spatial objects. The two objects could then be used to process customer records and divide them into "territories" based on the line of intersection.
I tried importing a file into my text input tool and I ran across this error.
Why is there a limit? Can we get rid of it since we're not living in DOS anymore.
I am trying to use the Dynamic Replace to selectively update records in a set of variables from survey data. That is, I do not have all potential values in the “R” input of Dynamic Replace. Instead, I have a list of values that I would like altered from their current values by respondent (RespondentID) and question # (Q#). Currently, when I run the workflow, any Q#/ResponseID combos that are not in my “R” input are replaced with blanks. However, I would like an option that maintains the original data if there is nothing to replace the data with. Without this option, there are few (I'm still working on some ways) workarounds to ensure the integrity of the data.
The community could benefit from easier integration of splitting and applying functions to grouped data. The summarize tool is great for splitting your data and applying summary statistical functions. It would be super useful to take that block just one step further, and allow users to apply any other (aggregate) function to their grouped data instead of just the built-in functions in the summarize tool. I would envision that aggregate function either being a custom function that is a combination of existing user-specified functions within Alteryx (e.g. in the formula tool) and/or even an interface that allows you to use other Alteryx macros on the grouped data.
Apply user-defined functions, or other powerful Alteryx macros to grouped and data is a very common operation in the data analyst's daily workflows and being able to apply them without reverting to batch/iterative macros in a seamless manner would be naturally helpful.
During execution the user cannot scroll around. Large workflows need to be shrunk to very small icons to be able to follow the progress. Either have an option to automaticaly center on the active icon or allow scrolling during execution.
I would love to be able to double-click on an input or output file and have the file open. Second to that would be a clickable hyperlink to the filepath that could be used to open the file, or a "go to" button or something. Anything would be better than my current process of copying and pasting the filepath into an explorer window.
I think it would be nice to have the possibility to select which fields will output fo the distance tool.
When calculating distances for between large dataset, I do not always want my to 2 set of points has par of the output and would like to drop them directly in the tool.
When giving a user a dropdown list, it is difficult to give them an option of the data in a specific column. So if I have a "State" column, I would like to give the user a dropdown of all of the states currently represented in the table. So if there was "Nebraska, Nebraska, Iowa, Kansas, South Dakota", the dropdown list would give them an option to select Nebraska, Iowa, Kansas, and South Dakota. This could be useful on both List boxes and Dropdown lists. Currently there is a workaround that lets you do it, but it is not a great solution because if there is a space (Like in South Dakota), it puts an underscore in it so parsing is required.
Alteryx crashed when I attempted to use a custom OTF font in Report Text. I thought it was supported because font options was not greyed out and preview window looked correct and I was able to resize. I clicked 'Apply' and Alteryx popup window appeared saying "only TTF font is supported". Then Alteryx crashed.
Please add OTF font support. Tableau and other packages already support it.
I'm not sure if this is the right forum for a bug report, but I just solved one that has been bugging me for ages. Of the six key commands to hide and reveal the various panels, only five work, and now I know why.
Apparently the 'Results' panel used to be the 'Output' panel? I found some outdated docs that mentioned Crtl + Alt + O to open/hide the Output panel. Sure enough, the reason Ctrl + Alt + R doesn't work in the current version is that, in spite of what the menu text says, it's O that is still mapped to that panel, and not R.
I only discovered this after making sure none of my other installed apps were stealing that key combination. Thank you, process of elimination.
It would be helpful to have one of the following methods to disable output modules to prevent overwriting output files each time a workflow is run:
- A global 'Disable All Output Modules' option, which would effectively mute the workflow without removing any connections
- A module-specific 'disable/enable this module' option, to the same end