Last modified: March 27, 2020
Release Date: March 5, 2020
- Gallery Artisans will now see an additional confirmation dialog after selecting Sharing > Place in Public Gallery. This serves as another reminder that content is being 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 eight 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 running in a non-EN user interface. Access this new feature via the main menu Globe icon > Localization Settings > Tool Palette Order. We do not yet support the sorting of Kanji characters.
Several enhancements related to Excel file input have been made:
- When you select a .xlsx or .xlsm Excel file in the Input Data and the Output Data tools, you will now be able to select a range for cells, rows, or columns.
- The Excel Input dialog screen now has a Refresh button. If you can't input an Excel sheet because the file is open, you can now close the file in Excel and select Refresh from the input dialog without closing and reopening the dialog 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 must:
- Select Overwrite Sheet or Range via Output Options.
- Specify cell ranges in the output file path.
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
- If you select a single tool on your canvas, the F2 key on your keyboard will now open 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.
- The Macro Input questions are no longer deleted from the XML when they are cached.
- Comments inside tool containers no longer hide tools in 2018.4.
- 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 the configuration panel to be expanded in order to see all the 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.
- Holistic profiling allows you to view profiling for multiple columns at once in a single view via the Browse tool.
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 basemaps 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.