Designer 2023.1 Release Notes
| Release Note Product Versions | |||
|---|---|---|---|
| Version | Release Date | Release | End of Support |
| 2023.1.1.123 | May 17, 2023 | Major | May 17, 2025 |
Alteryx Designer version 2023.1 offers separate GA and FIPS 140-2 capable products. For more information about FIPS, go to the NIST FIPS FAQ page.
The general release version of Alteryx Designer is not FIPS capable. A separate release (and installer) is available under separate license terms for our FIPS 140-2 customers.
Feature and Tool Differences
Please note that specific tools and features might be limited or unavailable in Alteryx Designer-FIPS. Over time, we will continue to evaluate which tools and features to make available again in future Alteryx Designer-FIPS releases.
Warning: Known Issue
Do not install Alteryx Designer FIPS in the same location as your non-FIPS Admin Designer.
By default, the FIPS installer recommends a different install location than the non-FIPS installer, but you can manually change it. If you change the install location, ensure it is NOT the same location as the non-FIPS Designer. If you install Alteryx Designer FIPS to the same location as a non-FIPS Admin Designer, your installation, as well as custom files and data that might be within that folder, will be significantly corrupted.
New Features: Designer
New Tool: Control Containers
The Control Container tool is a brand new tool available via the Developer tool category in Designer. Control Containers allow you to build more dynamic and complex processes with better orchestration, logging, and conditional execution.
Here are just some of the capabilities of Control Containers:
- Manage the sequence in which tools run in your workflow. For example, you can use Control Containers to sequence outputs to different sheets within the same Excel workbook or even output a file in a workflow and use that same file as input later in the same workflow!
- Conditionally execute workflow branches—use a Filter tool to execute a branch of your workflow depending on whether records pass through the True or False outputs.
- Use information about the tools that are run, either as logging information or as data to use in your workflow. For example, you can use Control Containers to create an output log for a workflow. Place all tools inside the container, and then output a file from the container’s Logging Output anchor to display the messages from your workflow execution.
AMP Only
The Control Container tool is only compatible with Alteryx Multi-threaded Processing (AMP).
New Formula Functions
We’ve added several new formula functions:
- AverageNonNull (Math Category)
- Between (Min/Max Category)
- Ceil and Floor functions have a new optional parameter to let you raise/lower numeric values to the nearest specified multiple (Math Category).
- Factorial (Math Category)
- ToRadians and ToDegrees (Conversion Category)
You can use these anywhere functions are available.
Higher Precision DateTime
You can now specify additional precision for your DateTime and Time data types. This allows for higher precision than seconds—for example, milliseconds, microseconds, nanoseconds, etc.
- A new f parameter is now available via the DateTime tool and lets you set precision time.
- A new %1-%18 date-time specifier is available with the DateTimeFormat and DateTimeParse functions.
- Higher precision is available via the DateTimeAdd, DateTimeDiff, DateTimeFormat, DateTimeNow, DateTimeParse, and DateTimeSeconds functions. Go to DateTime Functions for details.
- A new DateTimeNowPrecise function is now available. This function returns your operating system's current date-time with digits of precision that you specify via the parameter.
- You can now also use the Select tool (and other tools with embedded select functionality) to adjust the size of DateTime and Time data to contain your desired precision. This functionality is also available via other tools where you can select field size, like Formula and Generate Rows.
Force SQL WChar Support via Output Data Tool
The Force SQL WChar Support option is now available via the Output Data tool for Oracle OCI connections. This option lets you force all char fields to output to WString to handle multi-byte characters.
Render Tool Data Truncation Fixes
We’ve made an update to help prevent unexpected data truncation in the Render tool. You’ll now encounter an error message when you try to output to PDF when the page size is too small to accommodate the data in your dataset.
Field Name Case Change Updates
To improve the workflow creation process, we've made updates to ensure that changes to the case of a field/column name will propagate to downstream tools without the need for manual reconfiguration. This update doesn’t apply to tools that are macros and doesn’t affect tools that use a pop-out configuration dialog (for example, the Insight and Interactive Chart tools).
Note that this change doesn't affect the Engine, nor does it affect how a workflow executes. Field names have always been case-insensitive from an Engine perspective unless otherwise specified.
Dark Mode BETA
Alteryx Designer now lets you select a Dark Mode option as your Designer theme! Preview Dark Mode via the Customization tab of Designer's User Settings.
BETA Release
The initial release of Dark Mode is a Beta release. Only certain Designer interface components have been converted to Dark Mode. Additionally, you might see certain components (including many tool configurations) that are currently only partially converted to Dark Mode. We will continue to include additional elements for Dark Mode in future releases.
Denodo Support
Alteryx now supports the Denodo platform connection. You can use standard workflow processing and In-Database workflow processing tools to read and write your data. For more information, go to Denodo.
Okta Authentication Support for SAP Hana
The 2023.1 release brings Okta authentication support, single sign-on (SSO), for SAP Hana. You can now authenticate to SAP Hana Cloud with Okta accounts.
AWS Secrets Manager
You can now connect DCM to your AWS Secrets Manager instance and then fetch authentication data from AWS Secrets Manager for your workflow. For information on how to configure AWS Secrets Manager, go to AWS Secrets Manager Configuration.
DCM as Default Option
DCM is now set as Enabled and Default in System Settings and Enabled in User Settings. Also, SDK is set to Allow, and the DCM check box is checked on a tool level.
If you upgrade from versions after 21.4, your DCM settings reflect the setup from your previous installation.
Microsoft Access Support
Alteryx now supports the MS Access 2016 Runtime and the MS Access 365 Runtime for reading ACCDB files.
IAM Role Support for S3 Tools
In the S3 Download and S3 Upload tools, you can now select the Assume Role option as a new authentication method to fully leverage roles in your AWS IAM.
New Features: Intelligence Suite
Installer Updates
As of the 2023.1 release, Alteryx Intelligence Suite uses new installer technology. The updated installer detects your operating system language and installs the product in that language (if applicable).
Text Classification Tool
Use the Text Classification tool to build a custom model that classifies text. Label your text data with categories to train a model and then classify new text with the Predict tool.
Enhance Step in Image Processing Tool
Added an image enhancement step to the Image Processing tool. Enhance increases image resolution of your scanned documents. Use Enhance to improve the results of your computer vision tasks.
Auto Option Added to Alignment Step in Image Processing Tool
Auto to automatically align your scanned documents in your OCR workflows.
Apply Annotations to All Pages
Added an Apply First Page of Annotations in Image Template to All Pages checkbox to the PDF to Text and Image to Text tools. Use this checkbox to apply the first page of annotations from the Image Template tool to all pages in batch processing.
End of Support
End of Extended Support Period for 32-bit Connections
For a period of two years from the date of release of Alteryx version 2021.2 (the "Extended Support Period"), Alteryx was providing customer technical support for 32-bit connections. If you currently use 32-bit connections, you will get an error message and will no longer be able to use those connections. Go to End of Support for 32-Bit Database Connections FAQs for more details.
Fixed and Known Issues
|
Fixed Major Release Version 2023.1 |
|||
|---|---|---|---|
| ID | Description | Version | Issue Status |
| TCPE-387 DE24215 |
The Render tool continues to produce a warning when fonts use the default style. | 2023.1.1.123 | Fixed |
| TCPE-409 GCSE-730 |
Issues with loading DLLs when using Alteryx 2022.1 .NET API. | 2023.1.1.123 | Fixed |
| TCPE-417 GCSE-686 |
Row rule to add a tab, space, or pad left as prefix of a column value doesn’t work when rendering table output to a Word document. | 2023.1.1.123 | Fixed |
| TCPE-423 GCSE-714 |
The Tile tool doesn’t work correctly on the original Engine if the tile method is “Smart Tile” and the tile numeric column value is 0. | 2023.1.1.123 | Fixed |
| TCPE-456 | 404 error and code loss in the Python tool in workflows downloaded from Server. | 2023.1.1.123 | Fixed |
| TCPE-469 GCSE-847 |
Adding a less than (<) symbol in the "Output Message" or the "No Output Files Message" in the Interface Designer Properties window causes an error. | 2023.1.1.123 | Fixed |
| TCPE-484 GCSE-965 |
Python code in Jupyter Notebook still doesn’t save the code after you save the workflow (and apply known workarounds). | 2023.1.1.123 | Fixed |
| TCPE-498 GCSE-966 |
The Data Quality bar in the Results window doesn’t function correctly. | 2023.1.1.123 | Fixed |
| TCPE-515 GCSE-1004 |
The Input Data tool doesn’t rename duplicate fields (that have a number at the end) in a logical fashion. | 2023.1.1.123 | Fixed |
| TCPE-516 GCSE-1010 |
Designer shows a blank screen after you authenticate with Okta set up with AWS Load Balancer. | 2023.1.1.123 | Fixed |
| TCPE-525 GCSE-1030 |
The Insights tool can’t be configured when using the Chinese version of Designer. | 2023.1.1.123 | Fixed |
| TCPE-526 GCSE-1036 |
Can’t find macros that are in a file path with double-byte characters in the path name. | 2023.1.1.123 | Fixed |
| TCPE-527 GCSE-1034 |
After updating to Designer 2022.3 the SQL Editor Query fails with ORA-error on workflows that it previously succeeded on. | 2023.1.1.123 | Fixed |
| TCPE-565 GCSE-1101 |
The Help button on the Analytic App window doesn’t function properly. | 2023.1.1.123 | Fixed |
| TCPE-569 GCSE-1106 |
Link in Interface Designer doesn’t work for file paths. | 2023.1.1.123 | Fixed |
| TCPE-575 GCSE-1086 |
A job won’t run in the scheduler when the Engine is set to “AMP Engine Only” in Designer. | 2023.1.1.123 | Fixed |
| TCPE-583 GCSE-1084 |
Designer crashes when publishing Analytic App to Server. | 2023.1.1.123 | Fixed |
| TCPE-615 GCSE-1181 |
All rows are not being read from Excel file. | 2023.1.1.123 | Fixed |
| TCPE-639 GCSE-1253 |
Google Drive Input tool only returns/writes out a faction of records in Designer 22.3.1. | 2023.1.1.123 | Fixed |
| TDALI-4451 | Remove the Behavior Analysis option from the Summarize tool. | 2023.1.1.123 | Fixed |
| TDCB-1647 DE33959 |
OCI writes garbled characters for Chinese (multi-byte) characters. | 2023.1.1.123 | Fixed |
| TDCB-4188 GCSE-590 |
SpatialObj type is not recognized when doing a UNION with the PostgreSQL database. | 2023.1.1.123 | Fixed |
| TDCB-4221 GCSE-675 |
Connecting to HIVE in the 2022.1 version of both Server and Designer (using MIT authentication) results in an error. The resolution for this defect requires an additional step from the user. Reach out to Customer Support at support@alteryx.com for instructions on how to apply the fix. | 2023.1.1.123 | Fixed |
| TDCB-4233 GCSE-713 |
Designer shows truncated string value for binary column read from a database. | 2023.1.1.123 | Fixed |
| TDCB-4236 | Designer shows truncated string value for binary column read from a database. | 2023.1.1.123 | Fixed |
| TDCB-4359 | XLSX: Corrupt file after overwriting range when original data has gaps. | 2023.1.1.123 | Fixed |
| TDCB-4382 GCSE-1062 |
Excel file breaks after you save a range of cells in a workflow with 2 or more Output Data tools to an Excel file. | 2023.1.1.123 | Fixed |
| TDCE-4 GCSE-535 |
Stored Procedures in a Dynamic Input tool error: “Unable to find Stored Procedure” when the procedure isn’t created in the DBO schema. | 2023.1.1.123 | Fixed |
| TDCE-6 GCSE-766 |
Input Data tool “Out of Memory” error for small XLSX files. | 2023.1.1.123 | Fixed |
| TDCE-26 GCSE-779 |
SQL Server data type money shows as V_String when connected via OLEDB. | 2023.1.1.123 | Fixed |
| TDCE-36 GCSE-808 |
When connecting to IBM DB2 and editing a query that contains WHERE condition with != , the SQL Editor adds a space between the exclamation point and the equals sign causing the query to fail. | 2023.1.1.123 | Fixed |
| TDCE-37 | Syntax error: Expected something like '(' between Left and '.'... with Join In-DB if Table/FieldName SQL Style set as “None”. | 2023.1.1.123 | Fixed |
| TDCE-44 DE30000 |
Snowflake error on Join In-DB tool with the same Connect In-DB tool: “SQL compilation error: duplicate alias “Tool1_7c8a”. | 2023.1.1.123 | Fixed |
| TDCE-48 GCSE-968 |
Error "Get Stored Procedure List Error. ' ' is an unexpected token. The expected token is ',', Line 632 position 28.” when viewing Stored Procedures for SQL Server. | 2023.1.1.123 | Fixed |
| TDCE-49 GCSE-962 |
When attempting to write to MySQL with the output option "Update: Insert if New" you get an error if the table has a composite primary key of multiple fields and none of the data have changed in the row. | 2023.1.1.123 | Fixed |
| TDCE-56 GCSE-456 |
ESRI ArcGIS SHP file doesn’t open correctly in 2021.4.2: lat/lon are reversed in polygons in some SHP files, Browse tool error, Report Map tool error. | 2023.1.1.123 | Fixed |
| TDCE-57 GCSE-984 |
With Oracle OCI connection, receive an error “ORA-06576: not a valid function or procedure name” when executing Store Procedures in the Pre or Post SQL statements in the Input Data tool. | 2023.1.1.123 | Fixed |
| TDCE-59 GCSE-991 |
Amazon S3 Upload problem: S3 download tool results in an error when utilizing the VPC endpoint. | 2023.1.1.123 | Fixed |
| TDCE-67 GCSE-1006 |
When attempting to write to PostgreSQL with the output option "Update: Insert if New" you get an error if the table has a serial field as the primary key. | 2023.1.1.123 | Fixed |
| TDCE-68 GCSE-1002 |
"An Unhandled Exception Occurred" when using OleDB with SQL Server In-DB connections. | 2023.1.1.123 | Fixed |
| TDCE-79 GCSE-1044 |
.hyper files read into Alteryx as the largest size field possible. | 2023.1.1.123 | Fixed |
| TDCE-83 GCSE-1066 |
Input Data tool trailing spaces removed if size is less than 40. NCHAR and CHAR from Oracle are now translated as WString and String. Varchar2, Varchar, and LONG are translated as V_String and V_WString. | 2023.1.1.123 | Fixed |
| TDCE-88 GCSE-1083 |
Changing the table name clears the selected Object ID when outputting to ESRI GeoDatabase. | 2023.1.1.123 | Fixed |
| TDCE-98 GCSE-1112 |
The Output Data tool failed to write a GML file when there was a double-byte character in the path or the filename. | 2023.1.1.123 | Fixed |
| TDES-4595 | Designer canvas context menu’s Choose Tool Version option doesn’t work. | 2023.1.1.123 | Fixed |
| TDSL-4444 GCSE-315 |
Render tool PDF reverses Arabic, Hebrew, and other right-to-left languages. | 2023.1.1.123 | Fixed |
| TDSL-4448 DE19725 |
PNG doesn’t render correctly to PDF from the Render tool. | 2023.1.1.123 | Fixed |
| TDSL-4618 | Dynamic save to PDF stopped working with AMP 2022.3. | 2023.1.1.123 | Fixed |
| TDSL-4627 GCSE-1050 |
In 2022.3, with AMP enabled, the Render tool doesn’t work correctly when you create an Excel file via the Group Data Into Separate Reports option. | 2023.1.1.123 | Fixed |
| TDSL-4633 GENG-2965 |
Both engines fail to convert 2^63 Float value to Integer. | 2023.1.1.123 | Fixed |
| TDSL-4686 GCSE-1046 |
AMP engine bug: Summarize tool with Mode action. | 2023.1.1.123 | Fixed |
| TDSL-4698 GCSE-1071 |
2022.3 Table tool: Column Styling rules aren’t applied to the header. | 2023.1.1.123 | Fixed |
| TDSL-4721 TELC-3231 DE19776 |
AMP Union tool: Error input “#1” was not initialized. | 2023.1.1.123 | Fixed |
| TDSL-4740 GCSE-1177 |
With AMP enabled, when a Batch macro error occurs on one iteration, the macro doesn't finish the rest of the iterations. | 2023.1.1.123 | Fixed |
| TDSL-4743 GENG-3078 |
The Unique tool doesn't give correct data while using AMP engine with larger data sets. | 2023.1.1.123 | Fixed |
| TDYN-447 | If you encounter this error: "Error: Select (8): Internal Error: Attempt to read past the end of a blob.", you can address it in Simba MongoDB ODBC driver. Increase the value for "Advanced option | Binary column size" from default to a higher value, like 262136. | 2023.1.1.123 | Fixed |
| TELC-3108 | AMP Fuzzy Match discrepancy in results as compared to the original Engine. | 2023.1.1.123 | Fixed |
| TELC-3239 GCSE-837 |
AMP creates excessive temp files. | 2023.1.1.123 | Fixed |
| TELC-3262 GCSE-1000 |
The Create Points tool failed with “You have found a bug.” when creating 500k points in the AMP engine. | 2023.1.1.123 | Fixed |
| TELC-3272 GCSE-970 |
Python tool: Alteryx.getWorkflowConstants() fails to return any User-defined constants in the AMP engine. | 2023.1.1.123 | Fixed |
| TELC-3276 GCSE-976 |
Join Multiple and Select tools error with Fixed Decimals of size 258.0 when AMP is enabled. | 2023.1.1.123 | Fixed |
| TELC-3278 GENG-2955 |
AMP Summarize tool: Group By the same field, wrong results. | 2023.1.1.123 | Fixed |
| TELC-3378 GCSE-937 |
Combine Vertical option of Summarize tool corrupts 2 multi-byte characters. | 2023.1.1.123 | Fixed |
| TGAL-7785 | Designer can't connect directly to a remote controller to create or manage schedules (Desktop Automation/Scheduler). | 2023.1.1.123 | Fixed |
| TINST-389 | Non-Admin User Settings don’t migrate with the 22.3 upgrade. | 2023.1.1.123 | Fixed |
| TINST-503 TDES-4841 |
Patch version doesn’t show on the About window in Designer after you install a patch update on full GA version. | 2023.1.1.123 | Fixed |
| TISE-222 TDST-3571 |
The Alignment step in the Image Processing tool crops your images after rotation. | 2023.1.1.123 | Fixed |
| TISE-251 | The PDF to Text tool allows language selection when you select Read Text Content Only. | 2023.1.1.123 | Fixed |
| TSIM-1856 GCSE-646 |
Simba Snowflake ODBC Driver v2.25 results with the error: "CURLerror (curl_easy_perform() failed) code=52 msg = 'Server returned nothing (no headers, no data)". This is resolved with a new driver version. Download and install driver version 2.25.8.1020 or newer from downloads.alteryx.com to resolve the error. | 2023.1.1.123 | Fixed |
|
Known |
|||
|---|---|---|---|
| ID | Description | Version | Issue Status |
| TCPE-633 GCSE-1240 |
The Interactive Chart tool doesn’t display large values correctly. | 2023.1.1.123 | Known |
| TDCB-4640 GDCM-2901 |
OleDB tool setup proceeds even if canceled. | 2023.1.1.123 | Known |
| TDCB-4655 | Access 32bit drivers fail in tool configuration but runtime works (XLSB, ACCDB). | 2023.1.1.123 | Known |
| TDCB-4662 | Active Query Builder doesn't work with Access 2016 and 365 64-bit drivers. | 2023.1.1.123 | Known |
| TDCE-78 GCSE-1045 |
ADLS Input generates a Malformed CSV file error. | 2023.1.1.123 | Known |
| TDCE-82 GCSE-1055 |
ADLS Connector on Gallery fails when the DCM credentials are used (specifically with the "Shared Key" authentication type). | 2023.1.1.123 | Known |
| TDCE-121 GCSE-1173 |
Flow parameters don’t work in the Power Automate tool. | 2023.1.1.123 | Known |
| TISE-437 | The selectable area for the Term Frequency question mark icon in the Text Classification tool might be very small. | 2023.1.1.123 | Known |
|
Control Containers Known Issues |
|||
| TDES-4700 | Insert After and Add Browse After options don't work with Control Containers. | 2023.1.1.123 | Known |
| TDES-4836 | Improve how Auto-Route Bezier and Auto-Route Perpendicular connections between Control Containers (CC) and other tools/CCs are rendered. Note that straight connections aren't affected. | 2023.1.1.123 | Known |
| TDES-4906 | Double-clicking a tool in the tool palette should place the tool to the right of Control Containers. | 2023.1.1.123 | Known |
| TDES-5430 | Action tool connected to a Control Container is missing action types. | 2023.1.1.123 | Known |
| TDES-5637 | Compare Workflows feature doesn't work with Control Containers. | 2023.1.1.123 | Known |
| TDES-5811 | The Anchor drag hitbox for Control Container Control Input anchor is too large when you connect from a tool inside that Control Container. | 2023.1.1.123 | Known |
| TDES-5955 | Inserting Control Containers via Insert in Connection doesn't auto-move tools to make space. | 2023.1.1.123 | Known |
| TDES-6029 | The Cache and Run Workflow feature has unexpected results in workflows that have Control Containers. | 2023.1.1.123 | Known |
|
TELC-3627 |
Analytic App with Control Container and Tree tool generates an error. |
2023.1.1.123 | Known |
|
TELC-3636 |
Tool Container nested inside Control Container (CC) produces an error. As a workaround, use a Control Container instead of Tool Container. |
2023.1.1.123 | Known |
|
TELC-3637 |
If there are 2 Detour tools fully contained within a Control Container (and the connection between them doesn’t pass across the boundary of a CC), the second Detour tool produces an error. It shouldn’t do this as long as the connection doesn’t cross the boundary of a Control Container. |
2023.1.1.123 | Known |