Skip to main content

What's New in Designer

2024.1

Version: 2024.1.1.17 (Go to Release Notes)

Release Date: May 1, 2024

Python Version Update

We have upgraded the embedded Python version to 3.10.13. Go to Python 3.10 Upgrade FAQ to review up-to-date information and resources.

New Features: Designer

Template Updates

We've made updates to the workflow template experience. You can now add metadata to your templates, including a thumbnail image, owner, and description. You can view templates via a grid view or list view via the Templates window, and you can change the default location where your templates are saved. Go to Templates for more information.

User Settings UI Updates

We've redesigned the Designer User Settings. The redesign simplifies the user experience via a modernized UI and more intuitive tab groupings. Go to User Settings to explore the updates.

Disable Individual Formula Expressions

You can now choose to enable and disable specific expressions in the Formula tool and have more flexibility in the way you build, test, troubleshoot, and execute your workflows. Additionally, you can dynamically interact with the disable expression toggle via the Action tool when you design Analytic Apps. For example, build an app where you use a checkbox to dynamically determine whether a formula expression is executed.

New Formula Functions

We've added several new formula functions:

  • Coalesce

  • DateTimeQuarter

  • EqualStrings

  • FindNth

  • IsLowerCase

  • IsUpperCase

You can find these anywhere functions are available.

AMP Fully-Converted Tools

These tools are now converted for full AMP support:

  • Smooth

  • Generalize

  • Heat Map

  • Find Nearest

  • Trade Area

For a list of tools supported with AMP, go to Tool Use with AMP.

Tool UI Updates

We've refreshed the user interface for the Select tool (including other tools that use the Select functionality). This includes the implementation of Dark Mode for the Select component. Additionally, we've made updates for tool UI consistency to the Sample, Sort, and Unique tools.

Download Tool Updates

We’ve extended the support for DCM tags resolution in the payload for POST requests inside the Download tool. Also, there’s added support for Base64 encoding of header and payload values (or selected parts of it) inside the Download tool.

Official Support for Make Columns Tool

The Make Columns tool has officially graduated to the Transform tool category in Designer (previously Laboratory tool category). We have also added a One Tool Example for Make Columns.

Email Tool Logic when There is an Error in Workflow with AMP

We enhanced the logic of the Email tool with AMP. Now it works the same as with the original Engine, where the Email tool is the final tool to execute (assuming all prior tools have been executed). You can rely on other validations in the workflow to finish before an email is sent. This prevents cases where a run appears to be successful (based on receiving an email) even if it incurred errors that should have prevented the email from being sent.

Email Tool Ignores Malformed Email Address

A single malformed email address in the 'to' email list of the Email tool should not prevent emails from being sent to valid addresses. When there is an invalid email address, it's logged as an error message and the process moves on to the next valid email address.

Expect Equal Tool

Expect Equal is a new AMP-native Developer tool. Use this tool to test if two data streams are identical and see errors if not. Go to Expect Equal for more information.

Marketplace Add-Ons

As an alternative to downloading via Alteryx Marketplace, you can now download and install Alteryx-supported add-ons directly via the Add-Ons menu in Alteryx Designer. You can search the Add-Ons window based on the add-on name and description, view the add-on's version number, and access the Alteryx Marketplace to explore all the offerings.

Beta Release

This feature is in Beta at this time. This means that certain components are not fully functional. Once you install an add-on via Marketplace Add-Ons, the Install button will read Update. Note that the Update button is not functional at this time. We will continue to enhance this feature in future releases.

Dark Mode Updates

Additional Designer components are now Dark Mode compatible, including more tool configuration components. In addition, many macro and Analytic App interface components are now Dark Mode compatible. Go to Dark Mode to learn more.

Beta Release

Dark Mode functionality is still in Beta at this time. This means that 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.

Start Here Updates

We've updated the Start Here experience (when you first open Designer). Start Here content is now hosted online from Community which allows for more frequent updates to communicate new and exciting features.

Updates to Designer Offline Help Files

We've updated the offline help experience in Designer. The offline help files now use the same look and feel as the online help (help.alteryx.com). When you access help in Designer offline, you now land on the offline help home page where you can search for Designer help content.

Read Engine Logs While a Process Runs

You can now view Engine logs while a job is running, which is especially helpful for long-running workflows. Previously, logs were locked for reading, could not be accessed while the workflow was running, and would be deleted if the workflow was canceled (loss of valuable information about the workflow run process). This was particularly challenging in Server environments where long run times can affect the stability of the environment.

With this change, you can now read Engine logs while the workflow is running (on both Designer and Server). Depending on how you view the logs (in which file viewer), you may be prompted to update or reload the page to see updates if additional log information comes through while you have the file open. For more information about Engine logs and their uses, go to the Knowledge Center.

Improved Swap File Management

We’ve improved Swap file management under the default temp directory. Swap files are now written inside a subdirectory of the session temp directory and have been renamed to Swap* (from e2Temp).

New Excel Reader

A new and improved Excel reader is now available. XLSX files now read in faster, with flawless Designer functionality when you select a range on the Excel sheet, and the ranges load consistently when data is sparse.

Reading JSON Data in Structured Form with Input Tool

A new feature has been added to the Input tool for JSON data, called "Read Data in Structured form." This feature is available with AMP only and allows data to be read in a tabular format, where the first-level keys serve as field names, and values within those fields are grouped accordingly. This lets you group values and utilize manipulations typically used for tabular data. For more information, go to Reading JSON.

Parquet Support

The Parquet file format is now natively supported by Alteryx (AMP engine only).

Trino Support

Designer now supports Trino connections. For more information, go to Trino.

Dremio Support

Designer now supports Dremio connections. For more information, go to Dremio.

Databricks Volumes

Designer now supports Databricks Volumes connections. For more information, go to Databricks Volumes.

IAM Authentication Support for AWS Data Sources

Some of your favorite AWS-hosted and served data sources now support AWS IAM for authentication in Designer:

  • Amazon Redshift

  • Amazon Athena

  • S3 staging authentication for Redshift bulk loader.

  • S3 staging authentication for Amazon Athena bulk loader.

  • S3 staging authentication for Databricks bulk loader.

Changing the Default DCM Mode to DCM Only

Important

We’re defaulting the DCM mode to DCM Only. This means that the checkbox to Use DCM on tool configurations might no longer be visible by default. You can still change the DCM Mode in the System Settings or User Settings.

This change doesn’t override your previously configured DCM settings. It only applies to new Designer installs as well as installs where DCM settings have not been previously configured.

Go to DCM - Designer for more information.

DCM Generic External Vault

You can utilize the DCM configuration to fetch secrets used in DCM credentials at runtime from a vault by providing a custom script or executable that would handle authentication and secret retrieval. Forming such a vault is possible through Designer and Server.

Generic External Vault allows you to configure a generic vault that can retrieve secrets from any vault with a programmatic interface using basic authentication.

For more information, go to DCM Generic External Vault.

Snowflake Key-Pair Authentication

You can now use key-file (JWT) authentication for Snowflake in Alteryx Designer with DCM. Select your Snowflake connection and find key-pair authentication from the list of available data sources.

Snowflake DSN-less Connection Proxy Options in DCM

The proxy parameter has been added to the Snowflake DCM schema. You are now able to establish a connection to Snowflake using the DCM connection with Proxy. Make sure not to include proxy credentials in the parameter as the value of this parameter is not encrypted and might be misused for malicious purposes.

Google BigQuery JSON Key-file Authentication

It's now easier than ever to authenticate service accounts with Google BigQuery using DCM. Go to Google BigQuery for more information.

HashiCorp Vault mTLS Authentication

There is a new authentication mTLS method to obtain secrets from the HashiCorp vault.

New Features: Alteryx Intelligence Suite

AIS Release Note Product Versions

Version

Release Date

Release

End of Support

2024.1.0.18459

May 1, 2024

Major

May 1, 2026

Python Version Update

We have upgraded the embedded Python version to 3.10.13. Go to Python 3.10 Upgrade FAQ to review up-to-date information and resources.

Updated Machine Learning Tools

With the upgrade to Python 3.10, some functionality of the Machine Learning tools has changed…

  • Classification and Regression Tools: Removed the Presort parameter from the Advanced Parameters section of the Decision Tree algorithm.

  • Predict Tool: Some models created before AIS 2021.4 might not work with the Predict tool. Additionally, models created with the AutoML tool are no longer supported. Please use the Assisted Modeling tool to build your machine learning model.

Updated spaCy Model for Text Mining Tools

Updated the spaCy language models for the Text Mining tools. This update might change the output for workflows that use these Text Mining tools...

  • Named Entity Recognition Tool

  • Part-of-Speech Tagger Tool

  • Text Preprocessing Tool

Updated Natural Language Tool Kit (NLTK)

Updated the NLTK toolkit for the Sentiment Analysis tool. This update might change the output for workflows that use the Sentiment Analysis tool.