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.
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.
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.
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.
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).
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.
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 really like the ability in 10.0 to turn on and off certain tool categories and specific tools within a category to keep your toolbar clean.
What would really take it to the next level is allowing users to manage them like bookmarks in a broswer - let me create new custom groups and add anything to them, or move tools among groups.
The favorites method lays the foundation for this, but is limited in that everthing is on one group. Using the method I suggest, users could basically have groups of tools tailored to specific analytic tasks.
In a future release, I'd love to see the whole concept of browsing for and installing new macros/apps brought into Designer itself. It's always great finding new macros, but the expereince is inconsistent- sometimes you have to run an installer file, sometimes run a package, sometimes just put the file in a directory and add a 'watched macro' directory to your preferences.
I'd like to see a cleaner expereince where you can choose to 'Add Tools', browse the gallery, check the thing i want, and click the tools group I want to put it under, then have Alteryx take care of the rest. There would also be the need for a 'Manage tools' screen where could could uncheck and remove them later if you no longer need them.
For inspiration, check out the way MS handles 'Adding Apps' via their catalog to build out your Sharepoint 2013+ site
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
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.
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.
Hello! Almost all statistical softwares allow for the analyst to use either a pairwise or a listwise option when applying clustering techinques. This option affects only how the inner distance matrix is built, and after that whichever algorithm you choose is peformed. However in Alteryx [K-Centroids] by default does listwise, classifying only those records where the selected variables have no nulls.
Please consider adding this option!
PS: the difference is pairwise will build the distance between 2 variables depending on those records that have no nulls on both variables, while listwise will run the distance matrix after it has checked for complete non null records in all variables of interest (not one at a time distance calculation).
It would be very helpful to have hidden/interactive labels that can be utilized for an Report Map that only appear when the user is hovering over a specific part of the map. For example they only want to see the sales numbers for California, but do want to change the map. It probably makes the most sense to have this available for the HTML Report Maps. This would allow the report map to not look too crowded with labels, but still have the labels available if the user is interested in a particular part of the map. Is this something that can eventually be added to the report map tool?
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.