This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I think It would be very beneficial to be able to find the first instance that a field appeared or when its name changed.
So consider the following:
1) Somewhere in my workflow, I use a formula tool and create a new field called Total Assets which is the sum of Asset1 and Asset2.
After my workflow is built (and I failed to do any sort of documentation) it would be nice in the results window if each field name was a highlighted link that took me to the first instance that a field appeared.
In my scenario above if I am downstream and wonder when Total assets appeared (as I might have multiple formula tools, but if could click the field name and it bounced me right to the first instance the field existed -- in this case a formula tool, this would be a huge time saving when troubleshooting.
1. An ability to right click on a connection and disable it to prevent any processing beyond that connector.
2. An ability to right click and make a tool 'transparent' (on certain tools like filter, with perhaps icon color change to show it is transparent) to see what happens with/without that tool much further down the road in large workflows.
3. An ability to left click on empty space between tools and connectors (the background) and drag the workflow around for faster navigation in large workflows. I know that there is an overview feature for faster navigation, but this should add further ease in navigation process.
4. An ability to make container any shape (lasso-like) and not just rectangular. It would make for much clearer distinction between containers.
5. How about a 'done' button in the new interactive chart so I don't have to 'close'out of it? After making all the adjustments, having to 'close' the display is not very reassuring.
6. How about third dimension (for size) in the scatter tool?
I am not sure if some of the features I requested are already there, if so please point me in the right direction. I did try to search in ideas and community section, but wasn't able to pinpoint to any specific topics I bring up above.
When using the formula tool -- one of the nice features is that when you start typing in a function or variable -- the tool will show formulas/variables that begin with that letter and keep changing as you type in more letters. I believe this is called predictive typing.
However, this does not happen in tools like multi-row or multi-field where a user would have to search for functions and variables if they weren't sure what they are.
Can predictive typing be added to the multi-row and multi-field tools? If I want to take it further, any tool that allows a user to use the formula functionality should be able to see predictive typing.
When outputting files, it is usually beneficial for characters that would cause trouble with formatting/syntax to be properly escaped. However, there are situations where suppressing this behavior is desirable.
Of particular importance for such a feature is in the outputting of JSON files. Currently, if a file is output as JSON it will always have quotations escaped if they occur within a field, regardless of whether this conforms to the JSON standard. There are a variety of current workaround for this, including pre-formatting all fields to look like JSON and then outputting as a \0 delimiter CSV, but in many cases there is no need to escape any characters when outputting a JSON.
A simple toggle--as was created for suppressing BOM in CSVs--to disable character escaping would make the creation of JSON objects simpler and reduce the amount of workarounds required to output proper JSON.
After developing complicated workflows (using over 200 tools and over 30 inputs and outputs) in my DEV or QA environment, I need to switch over to Production to deploy it, but it's incredibly annoying to have to change 30 data inputs individually from QA to Prod, DEV to QA, etc. If I need to go back to QA to change something and re-test, I have to do it all again. etc.etc.
I need a way to be able to change mass amounts of data sources at once or at least make the process a lot more streamlined to make it bearable. Otherwise it is incredibly difficult to work within multiple environments.
Noticed an issue in the Browse tools, specifically if you’ve run a module once, where browse tools are displaying information, and then you add new browse tools into the process (without clicking run yet). What I’m seeing is if I’m looking at the “existing” Browse that is showing data, and then click directly onto a Browse tool that was added after the run (not remembering I just added it), the “new” Browse tool is showing the previous Browse tools info, I literally have to click on the canvas, and then back to the new Browse tool for Alteryx to recognized there isn’t any data to display in it yet. My point being it can be misleading to the user if they don’t recognize the wrong info is being displayed (because as you click back & forth between the two, the data stays the same, making the user think the issue is in the process rather than just the display, can waste a lot of time backtracking for no reason). I’ve seen this behavior over at least the past 3 engine updates, just FYI.
Please add the "Don't Output Input Objects" option.
It would be nice to eliminate the input objects when the processed output object is all that is desired. When processing spatial data, keeping the input objects can lead to massive amounts of unnecessary data in the output data stream.
Would love the option to pass a field to the AWS S3 Connector for the Key & Secret Access key. We are building an extensive datamart using AWS S3 and instead of manually changing keys each quarter (per our security) manually in each workflow & tool, we'd rather change it in one spot and have it filter into all affected workflows.
The silent install for the census data I not completing successfully. It appears that it can't create folders. When attempting to run the command: DataInstallcmd.exe /s /install all /log "C:\temp\logs\alteryx.txt"
I received an error in the log: Install failed: Directory: C:\Program Files (x86)\Alteryx\DataProducts\ does not exist
I received this error regardless of how I attempted to run this command, as a user with admin permissions, as a user with admin permissions running the command as an administrator, from an elevated command prompt, etc. It was not until I manually created the directory via the following command that the silent install ran successfully.
I have created a workflow that runs on Alteryx Server for a group of users. If two people were to run the workflow consecutively, chances are one could overwrite the other's file. It would be great when the user adds a description to the Optional Job Name field before hitting run, then that text could be included in the workflow and then used as a pre-append title for the file name.
One way to get around this could be to create a manual input that replaces a dummy string hard coded into the flow. A lot more moving parts, through.
On the output data component, when outputting to a database, there are Pre & Post Create SQL statement switches. This allows for the execution of a SQL statement in the DB but only after a create table action. To use this functionality you must have populated a table using the 'create new table' or 'overwrite' option, which is no good if you're using the Update or Append options. Change these switches to Pre & Post SQL Statements as per the Input Data component. This will allow you to execute SQL statements in the DB either before or after the population action. Can be really handy if you need to execute database stored procedures for example.
Please note: You can already work around this by branching from your data stream and creating or overwriting a dummy table, then use the pre or post create switch for your SQL statement. This is a bit messy and can leave dummy tables in the DB, which is a bit scruffy.
When outputting to files in avro format, it would be nice to have Alteryx either throw an error/warning or automatically add a prefix when field names do not conform to the Apache Avro specifications. For example, if I were to try to output an .avro file with a field named "2018 actions", Alteryx could throw a warning/error to remind me to rename the field, or Alteryx could change the field name for me to something like "X2018_Actions".