Could we please have a Type field added to the "Select Fields to Cleanse" configuration window for the Data Cleansing Tool? This small feature would save a lot of time (saving the time needed to check the Metadata for every field every time I use the Data Cleansing Tool). Similar functionality to the way the Summarize Tool displays both Field and Type (just one additional field).
Pardon my sad photoshopping 🙂
Note: I realize the Data Cleansing is a macro and this functionality is not currently available with the "Check Box" interface tool.
Alteryx Server was recently updated to allow TLS-mediated connections to the MongoDB persistence layer. This allowed us to switch off of the embedded MongoDB to a highly-available MongoDB Atlas cluster. To our surprise after the switch, when we went to edit our workflows that make use of the persistence layer's data (Server Usage Report, etc.) to hit the new Atlas cluster, we found that the MongoDB Input tool does not support TLS connections. This absolutely needs to be changed. Based on organizational constraints, Atlas is our only option for a HA persistence layer. We absolutely have to have TLS support for the MongoDB Input tool. There is no other way for us to natively query our server persistence layer in Designer. Please bring the MongoDB Input tool into alignment with the MongoDB connections that are supported by Alteryx Server.
While almost all interface tools allow for default values, the listbox / manually set values does not. The idea would be for a property on each line that when displayed to the user would have one or any values checked upon entry. The configuration might look like Name:Value:Default. I.e.
I would use this to pre-populate the listbox with entries from a database that would essentially allow the user to edit his previous entry. In this example, the user previously selected Alabama and the results were stored in a database. When editing the record using an analytics app, I would want the user to see what he chose and the other options available.
I've just downloaded the latest version, 2020.2.3, which I do like overall. However, I was horrified to see an issue that keeps coming back, I'm hoping this time it doesn't take as long to fix. I'm referring to the Select tool no longer showing the whole (or at least the majority) of the field name...again (this is at least the 3rd time this has come back). It appears you only show the first 6-9 characters making it so I have to hover my mouse over each column to get the full name or drag the field pane out every time I click on a select tool/join tool/spatial match tool/find nearest tool/etc etc.
I suggested in the past each time this has happened before, that you just drop the description field, which you give the most room to by far. I've been using Alteryx since you were SRC (too depressing to count how many years that's been...so old) and I have not once put anything in the description area, does anyone really ever use this area on a consistent basis? Or if you can't drop it, maybe not allocate all the room to it & make it one of the smaller panes, which would allow for the actual field names to have more display room, which then allows your user base to more easily tell what is in the data they just loaded.
This is definitely a step backwards in my mind in design/time efficiency, holding out hope this was an oversight & will be fixed next release (fingers crossed, rabbit foot rubbed, lucky shirt on, donated to charity, & knocked on wood)! Please please please.
It would be great to have the below functionality in Alteryx.
A workflow is built in Alteryx and button click in Alteryx can be used to generate SQL code that can be ran on a specific database platform, such as SQL Server to run external editors such as SQL Server Management Studio. Thanks.
When you use Create Points tool - you then almost always need to use a Select tool to rename that point.
Can we please add a single text field to the Create Points tool - which would then allow us to create and name a point in one step?
When entering a number of column names in the RegEx parse mode - please can you allow either Enter or down-arrow to move down to the next cell (standard windows convention)?
Currently Enter just exists the edit mode; and down-arrow does nothing.
This has probably been mentioned before, but in case it hasn't....
The dynamic input tool is useful for bringing in multiple files / tabs, but quickly stops being fit for purpose if schemas / fields differ even slightly. The common solution is to then use a dynamic input tool inside a batch macro and set this macro to 'Auto Configure by Name', so that it waits for all files to be run and then can output knowing what it has received.
It's a pain to create these batch macros for relatively straightforward and regular processes - would it be possible to have this 'Auto Configure by Name' as an option directly in the dynamic input tool, relieving the need for a batch macro?
I just installed 2020.2 & I LOVE this update within the Formula tool:
Are there any plans to bring this ability to the Filter tool as well, where I can double click on my column name & have it grab the brackets as well?
Not going to lie, love that you added the Open/Save/Undo buttons back to the top toolbar too! Latest version looks great, thank you!
Could we please change the Interactive Chart tool, to:
Sample Flow - derivation of challenge 201:
- The first interactive chart on this flow has no sorting at all performed by the charting tool - this may be due to the fact that the X & Y axes are in string fields. Generally line charts would attempt to sort both the axes and the values (where the values should order according to the X axis). Please can you add a default sort anyway?
- If you then change the data types on these fields to be numeric - the charting tool still does not sort them until you reconfigure the tool manually
- REquest: please can you get the tool to remember the data types, so that it can prompt you; or even better just reconfigure?
(image looks identical after retyping the fields)
- When you do a manual reconfigure of the tool after changing the types - the axes are sorted, but the values are not - so you end up with a chart that crosses back and forth. Generally line charts are ordered in the order of the X Axis for the values
- Request: Please sort values on the line chart automatically in order of the X value?
NOTE: Finally got the outcome needed by forcing the sort before the interactive chart tool
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:
The crosstab tool replaces any non-alphanumeric characters with underscores in column names. It would be helpful to keep the original values as column names (or to have the option to toggle whether or not special characters are replaced with underscores).
This is often an issue for reporting and for dynamically-populated app inputs (e.g. drop-down), where we need to retain the special characters.
For example, say I have the following dataset:
Currently, the crosstab tool produces this:
I would like this:
There are currently (somewhat cumbersome) workarounds such as adding an extra row with the original names, and then using Dynamic Rename to rename the columns, but it would be great to be able to use the data straight out of the crosstab!
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.
I want to check out which things downstream are receiving data from the true and false branches of this filter.
I could step through them one by one.
It would be much easier if I could simply select the tool and see directly which tools are connected to which output by colour, or line style.
As what title said, it was hard to see the records display when the records is too large.
I have to adjust the Config Window to see the records. It is pain when checking a workflow with Join.
1. Used fraction: 100,000/1,000,000 Records Displayed
2. Change based on the size it have, minimum will be 1,000,000 Records. Partial displayed will show if it expand.
3. Reduce the space for Search Bar, only Expand if selected.
4. Use another line.
10 Records (no Issue)
1 Miillion Records (Issue to see the records)
When writing an expression in a Formula tool, I love that you can just type an open bracket and suggestions pop up that allow you to auto-fill the rest of the variable name. What I find frustrating, however, is that once you type the open bracket, the highlighted field automatically moves to the one where your mouse is pointing, regardless of if you have moved your mouse or not. I think it makes more sense to always highlight the first field in the list and only take mouse position into account once it has actually moved.
It is hard to describe in just a picture as opposed to a video but essentially I had my mouse below where I was typing in the screenshot below then when I typed the open bracket, the 3rd field listed automatically got selected even though I never moved my mouse.
Sometimes, as a sanity check, I would like to be able to model only the mean of my data set, i.e. I would like to use a predictive tool with no predictors included. The result would be a model with only an intercept, and this value would be the mean of the target variable. This would not be an important feature for final models, of course, but when starting to look at a data set and build up a model, it can be useful to first ensure the model is producing the expected output in the simplest case.
Note, this can be achieved when just one predictor is included, but it takes some math (see below), so it would be nice to be able to have this as a built-in option.
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.
The expression editor in the RegEx tool is only a single line, which makes it really hard to edit long regular expressions. See attached photo comparing the expression editor in the RegEx tool compared to the formula tool for the same expression. Please make the RegEx editor box either wrap to multiple lines, have a pop-out expression editor, or something so we can see long expressions.