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.
In a browse tool, sometimes I need to check any metrics haven’t been lost or omitted in different summarise tools (eg the totals still add up with different group by).
I would LOVE the quick win of selecting some cells in the browse tool results pane, and a label somewhere shows me the sum, average, count, distinct count, etc. I hate to use the line but ... “a bit like Excel does”. They even alow a user to choose what metrics they want to show in the label by right clicking. 🙂
This improvement would save me having to export to Excel, check they add up just by selecting, and jumping back, or even worse getting my calculator out and punching the numbers in.
With the continued growth of Graph Databases, it would be nice for Alteryx to creates a new tool set that would allow input/output connectors for Graph Databases like Neo4j which software tools like Pentaho and Talend already have.
I recently came across a workflow that has hundreds of tools and I need change a "variable" within several filter tools. There is prob 30-40 filters and they vary in what they filter. A find and replace feature would be awesome, or even a simple find function that shows were the variable is located within a workflow/tool. Could use user constants but these workflows were already made when I joined and it would be more difficult.
So a feature similar to the MS Word feature of search/find/find all/replace/replace all would be great for the actual variables with the tools.
Think of a pivot table on steroids. In my industry, "strats" are commonly used to summarize pools of investment assets. You may have several commonly used columns that are a mix of sums and weighted averages, capable of having filtering applied to each column. So you may see an output like this:
% of Balance
% of Balance (in Southwest Region)
Loan to Value Ratio (WA)
Curr Rate (WA)
Mths Delinquent (WA)
Right now, I feel like to create the several sums and weighted averages, it's just too inefficient to create all the different modules, link them all together and run them through a transpose and/or cross tab. And to create a summary report where I may have 15 different categories outside of Loan Status, I'd have to replicate that process with those modules 15 times.
Currently, I have a different piece of software where I can simply write out sum and WA calcs for each column, save that column list (with accompanying calcs) and then simply plug in a new leftmost category for each piece of data I'm looking at. And I get the Total row as well auto-calculated as well.
Today I have some workflows which have certain steps that occur after files are output. I have these set up inside of Tool Containers so that I can easily enable/disable them as I am working if I do not want to produce output for this particular run. However, sometimes if I need to troubleshoot on a workflow that I haven't worked on for awhile, I can neglect to disable these, which can cause errors. This is usually harmless, but annoying.
Having two more options on Tool Containers could really help to improve this!
Disable When Browse Tools Disabled would be useful for any analysis/debugging steps that I only want to run when I am browsing to find data, but should not run otherwise.
Disable When Output Disabled would be really useful to ensure that these tools are turned off alongside the "Disable all tools that write output" option in Workflow-Configuration-Runtime.
This would save me a lot of unnecessary error messages and moments of panic, and would make these types of workflows easier for other users to debug without extensive notes.
Currently in Alteryx if a user uses a SELECT tool to rename a field name, and then have various different tools connected in a flow to this SELECT tool, the same field name is carried throughout.
However, what if your project kept adapting to different needs and hence the field name in the SELECT tool had to be renamed again for some reason, this would cause all the linked tools in the workflow to break, especially if the previous field name is used in these tools.
It would be great to allow the user to tell Alteryx to change all linked field names in the various linked tools to the new name or keep the old one.
I understand that Alteryx at the moment does not have this feature by default, in the case where the user renames a Field name, Alteryx does not want to automatically update all linked Field Names, especially if the renamed Field Name has already been used somewhere else in the workflow. However Alteryx should provide a warning that the renamed Field Name is a duplicate !
Matlab has a similar case wherein if a user changes the name of one variable, with a simple keyboard shortcut he can rename all other variables just simply.
Hi, i am from ETL back ground and coming from my knowledge i would like to suggest or ask a feature which will helpful in alteryx solution.
"Error Line" : many ETL tools provide an "On Error" line which performs certain actions like "altering user by sending an email", "ignoring and going to next step" etc. It will be great if Alteryx can provide the same feature where we can have an error line (red line) for each tool.
Hope this is not a repeated idea. thank you for all the support and providing a wonderful tool.
This suggestion is particularly relevant for macros and custom tools created with the Python SDK, but I think it can apply to other tools as well.
When searching for tools in Alteryx, I can easily find tools I want fairly quickly. However, I often don't know which tool category it is in, which can sometimes slow me down (it is sometimes faster/easier for me to go to the tool category, rather than search for the tool I want).
Similar to the Select tool's Unknown Field Checkbox, I figured it would be useful for the Data Cleansing tool to have this functionality as well in order to avoid a scenario where after a cross-tab you have a new numeric field, one of which has a Null value, so you can't total up multiple fields because the Null value will prevent the addition from happening. If the Unknown Field box were checked off in the Data Cleansing tool then this problem would be avoided.
Recently in Feb 2016, Australia released the geocoded national address file to the public for no extra cost and will continually update this each quarter.
I think It would be a game changer to build this functionality natively into the alteryx product to enable any alteryx user simple access to it. also I think it would drive a lot of sales for the alteryx product.
There is a need when visualizing in-Database workflows to be able to visualize sorted data. This sorting could be done 1 of 2 ways: In a browse tool, or as a stand-alone Sort tool. Either would address the need. Without such a tool being present, the only way to sort the data is to "Data Stream Out" and then visualize the data in Alteryx. However, this process violates the premise of the usefulness of the in-DB toolkit, which is to keep your data in-DB and process using the DB engine. Streaming out big data in order to add a sort is not efficient.
Granted, the in-DB processing doesn't care whether data is sorted or not. However, when attempting to find extreme values after an aggregation, or when trying to identify something as simple as whether null values are present in a field, then a sort becomes extremely useful, and a necessary tool for human consumption of data (regardless of the database's processing needs).
The idea is simple and widespread in many products industry wide. Basically as you type it should recommend a list of appropriate functions/variables/constants based on what you've typed so far. While tab or enter can be hit to autocomlete.
- Google has this in their search bar along with many other search tools
In order to perform audit-trail logging - it would be valuable to have 2 new capabilities
a) environment variables which show the workflow name; filepath; version; run start date and time; etc. For any worklows we build, we need to have a solid audit trail to be SOX compliant, so having this detail available as a data field to write and manipulate is essential
b) A logging component. What would be great is a component that you can drop on a workflow, not connected to anything, which is able to trap the start; end; runtime; version; etc of a workflow; and commit this to any output data format (CSV or ODBC etc). This logging tool would need to be able to capture the full runtime, so it would need to be the last thing that runs (which means it may need to exist in parallel to the main workflow in some way). This is not currently possible with a complex workflow with outputs, because it's not possible to identify when the entire workflow ended; or the runtime (since output tools don't have an onward connector to pass flow-of-control to catch the final end-time)
Again, both of these are necessary to meet audit requirements for workflows and prodcution-quality ETLs for BI data warehouses.
I would love the R tool editor to work like a standard text field....it might be better explained in this scenario. Pretend the character text is a script youve written with the function being at the top. Let's say you'd like to move the function closer to the script, look at the weird output. This editor pastes text like we are pasting images.
The use case is that I like to break my code into mini functions that I work on in the r console with sample data. Once it works, I post it into alteryx and experiment with it on a small sample, then a larger sample. If I have to have a document for my overall r cost in notepad ++, my function, and the console, it’s a little nusance, especially since I usually have to go back and forth with multiple functions. I am not askin for a full blown editor, I like my notepad ++ for that, just a text input that works conventionally.
I think that it would be nice to be able to append a Time Stamp to the name of a file in the OUTPUT Tool, as a Mainframe Programmer I could append a time stamp to file names this is helpful when doing batch jobs that are scduled on a server.