What's New in Designer
Release Date: September 1, 2020
Find and Replace Window
You can now replace text in Designer via the Find and Replace window. Access this feature in the Designer main menu via Edit > Find or via the Ctrl + F keyboard shortcut. Visit Find and Replace for more information.
Localization and International DateTime Support
- International DateTime support was added to the Report Header and Date Time Now tools, as well as the DateTimeParse and DateTimeFormat functions.
- Calendar display mirrors Alteryx Designer language instead of OS language.
- Korean Code Page 949 was added to the Input Data tool.
The Dynamic Replace tool was converted to AMP. With AMP, you can now use these built-in macro tools: Select Records, Count Records, Weighted Average, Date Time Now, Random % Sample, and Create Samples. Additionally, the 17 Interface tools used in Analytic Apps have been converted to AMP.
We now have 74 fully converted and 14 partially converted tools for you to use with AMP. For more information about tools that have been converted from the original engine to AMP, visit Tool Use with AMP.
- The Word Cloud tool has the option to Generate Phrases. If you select that option, the tool treats two-word phrases as single phrases.
- The Image to Text tool can parse PDFs that contain multiple languages.
- The Image Template tool has an extended markup field to accommodate more info.
The Assisted Modeling tool has a new step. You can select whether you want the tool to walk you through each step in the modeling process or to build the model automatically.
Browse Tool Data Profiling
Several updates and improvements were made to the Browse tool data profiling:
- Data Profiling in the Browse tool is now capped at 300 MB. This allows you to process very large datasets faster. For each record in the incoming dataset, we process the record and add the record size to a counter. Once the counter reaches 300MB, we stop processing records. It is important to note that there is no specific number of records we can process. The limit depends on the dataset since a record size can range from 1 byte to a few thousand bytes. This record size is different from the file size, displayed in the Results grid and Data Profiling Holistic View. The file size is generally different since it has been compressed to optimize spacing. In other words, 300 MB of record size is not the same as 300 MB of file size.
- We added a Distincts count for Float and Double data types.
- We updated the data type icons for all data types in Holistic Data Profiling.
- We now show a sample icon when a field in the dataset shows only a sample of the full dataset.
- You can now filter the Data Profiling Holistic view based on Fields (columns) and Data Types.
You can now specify a port number for Email Events. The port number can still be added to the SMTP URL if needed.
We fixed an issue that prevented users from creating filters in the Insights tool. Previously, the filter panel collapsed before a filter could be edited. This issue has been addressed.
Local Staging for Snowflake Bulk Loader
Previously, the Snowflake bulk loader only supported staging through an Amazon S3 bucket. You can now utilize Local Staging to stage data locally before it is copied to Snowflake. For more information, please visit Snowflake Help.
PostgreSQL Bulk Loader
The PostgreSQL Bulk Loading functionality stages the data locally and performs a bulk copy operation for more performant writing to the database.
Teradata Upgrade to 16.20
Teradata driver version 16.20 is now supported.
XLSX on Linux: Read and XLSX on Linux: Write
Users can now expect that XLSX files used in Input and Output tools will run with the AMP Engine when Use AMP Engine is selected.
One Tool Example for Insights Tool
A new One Tool Example (OTE) for the Insights tool is now available in Designer.
One Model Examples in Designer
One Model Examples, which feature tools from the Alteryx Intelligence Suite, are now built into Designer. Select Help > Sample Workflows > Learn One Model at a Time.
Release Date: June 3, 2020
Alteryx Intelligence Suite
The Alteryx Intelligence Suite is now available as a Designer add-on. Alteryx Intelligence Suite offers Machine Learning and Natural Language Processing (NLP) capabilities on top of the great features that are already available with your Designer license. Visit Alteryx Intelligence Suite to learn more.
Alteryx Multi-threaded Processing (AMP)
Alteryx Multi-threaded Processing (AMP) is a new architecture of Alteryx Engine, designed to work with larger volumes of data at higher velocity. To learn more about the AMP Engine as well as differences between the original engine and AMP, visit these resources:
To run workflows with the AMP engine, navigate to the Workflow - Configuration pane in Designer and select the Runtime tab. Then check the Use AMP Engine box to enable Alteryx Multi-threaded Processing.
AMP Engine supports Standard, Iterative, and Batch Macros. In addition, 50 tools have been converted to run with AMP.
Smarter Data Profiling
Several updates and improvements were made to the Browse tool data profiling:
- The holistic view now shows the top values for each column of data. Use the toggle to switch between the top values view and the data profiling charts.
- For columns that contain only one distinct value across all rows, the Only one value message displays.
- For columns where each value is unique, the All values are unique message displays.
- You can now see value ranges at a glance in the holistic view for numerical and data-time columns.
- You can now see a list of up to 1,000 distinct top values via the more > link in the top values view.
- Two new functions were added to the Data Cleansing tool: Remove Null Rows and Remove Null Columns.
- It's back! Due to popular demand, the Open, Save, Cut, Copy, Paste, Undo, and Redo functions were added to the Designer toolbar.
- We made some updates to ensure a seamless, smooth experience when using Designer in a non-EN language.
- In-product help directs to content in the selected language.
- Search links to results in localized Community pages. Currently, this is supported for FR, DE, JP, ES, and PT languages.
- Canvas annotation font defaults to a supported language font when you switch to a different language.
- We added international support to the DateTime tool. Designer now supports dates and times in multiple languages and locale formats.
- The Text Input tool cell import limit was increased to 10,000.
- We made a few enhancements to the Formula tool:
- You can now delete formulas when they are collapsed in the Configuration window.
- When you double-click a column name inside of an expression, the brackets around the column name are also selected.
- Hover tooltips for functions were updated to improve accuracy and consistency.
- New One Model Examples are available in all supported languages. Download these via the Licensing Portal. Select Alteryx Designer > Alteryx Machine Learning Toolkit and select a download option.
- R was upgraded to 3.6.3 from 3.5.3., discontinuing support for Microsoft R Client and Microsoft Machine Learning Server.
- CEF and Chromium were upgraded:
- CEF was upgraded to 3.3396.1786.gd3e36d0 from 3.3202.1694.gf061c23.
- Chromium was upgraded to 67.0.3396.79 from 62.0.3202.9400.
Release Date: March 5, 2020
Publish to Public Gallery
- Gallery Artisans can now see an additional confirmation dialog when they select Sharing > Place in Public Gallery. This reminds users content is being publicly shared in the Public Gallery.
- Additionally, when users select Save As in Designer, they will now see explicit options for Private Gallery and Public Gallery.
- Simplified Chinese is now available in Designer, making it the 8th supported language.
- You can now toggle to any one of our 8 supported languages within Designer. Access all supported languages and Localization Settings via the globe icon next to Help in the main menu.
- You can now sort your tool palette to follow English Alphabetical order, even if you're using a non-EN user interface. Access this new feature via globe icon > Localization Settings > Tool Palette Order. We do not yet support the sorting of Kanji characters.
Several enhancements related to Excel file input are now available:
- When you select a .xlsx or .xlsm Excel file in the Input Data and the Output Data tools, you can now select a range for cells, rows, or columns.
- The Excel Input screen now has a Refresh button. If you can't input an Excel sheet because the file is open in Excel, you can now close the file and select Refresh from the Excel Input screen without closing and reopening the screen.
- The List of Sheet Names option in the Input Data tool for .xlsx files now returns the sheet names in the order they appear in Excel.
- You can now Preserve Formatting on Overwrite when overwriting a sheet or range via the Output Data tool Options. In order to preserve formatting, you have to:
- Select Overwrite Sheet or Range via Output Options.
- Specify cell ranges in the output file path.
Smarter Data Profiling
Holistic profiling allows you to view profiling for multiple columns at once in a single view in the Browse tool.
- The following keyboard shortcuts are now available in Designer:
- Select the Tool Palette: Ctrl + Shift + T
- Select the Overview panel: Ctrl + Shift + V
- Select the Results panel: Ctrl + Shift + G (results grid)
- Select the Configuration panel: Ctrl + Shift + C
- Select the Canvas: Ctrl + Shift + W
- Select the Interface Designer Window: Ctrl + Shift + D
- New one tool examples are available in In/Out, Preparation, Transform, Interface, Calgary, and Developer tool categories.
- In/Out: Date Time Now
- Preparation: Create Samples, Oversample Field
- Transform: Arrange, Weighted Average
- Interface: Control Parameter, Folder Browse, Macro Input, Macro Output
- Calgary: Calgary Input, Calgary Join, Calgary Cross Count, Calgary Cross Count Append, Calgary Loader
- Developer: API Output, Detour, Detour End, Python, Run Command
- When you select a single tool on your canvas, the F2 key on your keyboard now opens the tool's Annotation configuration window with the cursor placed in the Annotation text field.
- The font size of container names is no longer oversized when printing a workflow.
- Macro Input questions are no longer deleted from the XML when they are cached.
- Comments inside tool containers no longer hide tools.
- The join order (Input_#1, Input_#2, etc.) in the Join Multiple tool is now maintained after saving.
- You can now resize column widths in the tool configuration window. This is particularly helpful when working with long field names in the Join, Append Fields, and Join Multiple tools that previously required you to expand the configuration panel in order to see all columns.
- You can now change the color of the input string number so that it is visible when opting into a darkened canvas in Designer. Go to User Settings > Canvas > Connection Settings > Text Color.
- You can now open multiple copies of the same workflow again by selecting Allow multiple tabs of the same file to be open in User Settings or by selecting the Shift key while opening a file to open more than one of them.
Release Date: December 9, 2019
- The Input Data tool now supports reading Tableau Hyper Data Extract (.hyper) files.
- The Multi-Field Formula tool field selection pane is now re-sizable and can accommodate a large number of fields.
- You can now insert and delete a header from the drop-down menu in the Text Input tool, making copying and pasting easier.
- You can now select all left or right fields in a Join Tool via the context menu.
- The Find tool allows you to search by the Tool ID.
- There are now more options for copying and pasting a tool in a workflow.
- Multi Resolution Raster (MRR) created by Pitney Bowes is the new reader for read file only, supporting a single raster band from a file, with each pixel in the raster band containing a value.
- You can now turn location data into business outcomes with high-quality, detailed base maps from Mapbox. Mapbox macros are now available in the Alteryx Gallery.
- You can now use your dataset to calculate/aggregate (aggregate within the tool) the sum, count, average, minimum, and maximum of your selected value(s) chosen.