Release Notes for Designer Cloud

Between: Tests if x is between min and max values, inclusive of min and max values.

AverageNonNull: Returns the average of a list of numbers. Null values are excluded.

ToRadians: Converts a numeric degree value (x) to radians.

ToDegrees: Converts a numeric radian value (x) to degrees.

CEIL: Returns the smallest integer greater than or equal to x.

Floor: Returns the largest integer less than or equal to x.

GetLeft: Returns the left part of String until the first instance of the specified 1 or more Delimiters. The delimiter must be static (string literal).

GetRight: Returns the right part of String after the first instance of the specified 1 or more Delimiters. The delimiter must be static (string literal).

GetPart: Uses the specified 1 or more Delimiters to divide String into substrings, and returns the substring specified in Index. The delimiter must be static (string literal).

DateTimeQuarter: Returns the numeric value for the quarter of the year in which a date-time value falls. Use optional numeric parameter to indicate the start month for Q1 (1-12).

FindNth: Finds the Instance (nth occurrence) of Target in Initial String and returns the 0-indexed position of Instance. The Target and Instance must be static values.

EqualStrings: Compares 2 strings to determine if they are an exact match. Returns True if all characters in both strings are identical, and False if 1 or more characters are not identical.

IsLowercase: Returns True if String has at least one lowercase letter and no uppercase letters, ignoring non-alphabetic characters.

IsUppercase: Returns True if String has at least one uppercase letter and no lowercase letters, ignoring non-alphabetic characters.

Bound (Min/Max): Retrieves the minimum or maximum value.

FinancePMT (Finance): Calculates the payment for a loan based on constant payments and interest rates.

StrSpn (String): Returns the length of the initial segment of a string that consists only of specified characters.

StrCSpn (String): Returns the length of the initial segment of a string that consists of none of the specified characters.

FinanceCAGR (Finance): Computes the Compound Annual Growth Rate (CAGR).

FinancePV (Finance): Determines the present value of an investment based on a discount rate and future cash flows.

Input tool: When uploading a new file or using an existing dataset:

Output tool: When executing a Full Run, the system calculates the Total Row Count for the newly created output dataset.

Updated the visual layout with new styling.

Introduced a navigation panel on the right side of the page for quick access to cloud product materials.

Enhanced the Cell Viewer to update content with a single selection of any record in the grid.

Enabled column metadata display when you select a column with Cell Viewer enabled.

You can now resize the Cell Viewer window.

Create Samples Tool

Oversample Column Tool

Imputation Tool

FinanceXNPV

FinanceNominalRate

FinanceNPER

FinanceEffectiveRate

TANH

On November 21st, all workspaces (excluding those with Private Data Processing enabled) will have access to the dual palette experience. Alteryx has enabled the dual palette for all applicable users and admins.

Once the dual palette is live, users will still see their previously created workflows in the library. These workflows were created in Cloud Native Mode. With the dual palette, you can now choose between Cloud Native Mode and Standard Mode for new workflows.

Learn more about what each mode does and when to use each.

Added the Column Info Tool to the Standard tool palette.

Added the Auto Column Tool to the Standard tool palette.

You can now disable individual formula expressions in the Formula tool.

Added a Group By option to the Row ID tool to make grouping data easier.

Added the Product, Count Distinct, and Count Distinct Non Null actions to the Summarize tool.

Added the Unnest JSON Column and Flatten Array options to the JSON Parse tool to handle JSON data more effectively.

Fixed an issue that caused an Out of Sync dialog to appear during the Full Run initiation of workflows. This fix ensures smoother and uninterrupted workflow execution.

Amazon RDS MySQL

Amazon RDS Postgres

Amazon RDS SQL Server

MongoDB

MongoDB Atlas

MySQL

Postgres

Redshift

Snowflake

SQL Server

Teradata

Designer Cloud Consumer: read and execute.

Designer Cloud Creator: create, read, update, delete, share, and execute.

asin (Math)

atan (Math)

atan2 (Math)

tan (Math)

compareepsilon (Test)

create_workflow

import_workflow

delete_workflow

workflow_run_initiated

export_workflow

update_workflow

remove_access_workflow

share_access_workflow

rename_workflow

set_workflow_version_name

Improved error messaging for failed workflow runs when you lack the necessary permissions for connections or datasets within the workflow.

Enhanced the performance of the Multi-Column Formula tool in Cloud Native mode.

Created a new endpoint for wf-svc v1. This enables the restoration of a specific workflow version as the latest one.

regex_countmatches (String)

mod (Math)

average (Math)

randint (Math)

charfromint (Conversion)

smartround (Math)

log (Math)

stripquotes (String)

median (Math)

pi (Math)

If a workflow name is truncated on the landing page, you can now hover over the name to view the full length.

Added a tooltip to optional tool anchors to let you know that you don't need to connect them to run the workflow.

You can now revert any changes you've made in the Select tool configuration window.

Standard Mode within a Dual Palette Experience: Arbeitsbereich-AdministratorWorkspace Admins can now enable Standard Mode within their workspaces. This provides users with a dual tool palette experience.

Administrator Control: All Arbeitsbereich-AdministratorWorkspace Admins have access to a new setting within Workspace Settings to turn Standard Mode on or off.

Enhanced User Experience: When a Arbeitsbereich-AdministratorWorkspace Admin activates Standard Mode in your workspace, you gain access to both Standard Mode and Cloud Native Mode tools across a dual palette. Within your workflow, you can switch between the familiar Cloud Native tools and the new Standard Mode tools. This offers greater flexibility and more options for building your workflows.

The Join tool can now join columns with the Date data type.

Created a new workflow service API, which will provide the list of all versions created for a specific workflow.

Created a new workflow service endpoint to provide the list of supported tools in Designer Cloud. You can also retrieve the list of tools currently under development or tools applicable for a specific mode - Standard or Cloud Native - by specifying in the request.

You can now save a version of your workflow in Designer Cloud. To save a version of your workflow, go to File > Save Version.

The Join Multiple tool is now available in Designer Cloud. Use Join Multiple to combine 2 or more inputs based on a commonality between the input tables. By default, the tool outputs a full outer join.

Adjusted the behavior for the Row ID button in the Results Grid. Selecting Row ID now selects all cells instead of removing the previous selection, even if other elements were selected in the Results Grid.

Enhanced error messaging for full run errors. Instead of a generic error message, a popup displays and shows a more specific message description from the Job History page.

If a cell in the grid contains several lines, like a code block, the cell is now highlighted in the Results Grid to notify you that only part of the cell is visible. To see the full value of the cell, double click on the cell in the Results Grid to open the cell viewer.

The Tool ID is now displayed with a number sign (#) instead of with parenthesis.

When someone updates the name of a shared workflow you are actively editing, you receive a notification that alerts you to the name change after your workflow has been saved.

You can now copy data from a selected column in the Results Grid. To copy the data from a selected column, select the three dot icon in the Results Grid header, then select Copy. You can copy the column data with headers or without headers.

A new Select All keyboard shortcut has been added that you can use to select all the sample data in the Results Grid. You can also select all the data in the Results Grid by selecting the Row ID header.

To copy all the data in the Results Grid, select the three dot icon in the Results Grid header, select Copy, then select Copy All Cells with Headers or Copy All Cells without Headers. Once the data has been copied, a popup will display showing the number of copied rows.

Updated the styling for the Result Grid right-click menu options.

Multi-column suggestions are now available in the Results Grid.

Added ability to right-click and create new workflows in a new tab or window on the landing page.

Improved navigation when dragging tools on the edges of the canvas.

Added a Duplicate button in the information banner when an example workflow is modified so you can easily duplicate your workflow.

Updated icons for selected anchors on the canvas:

Added the ability to select multiple tools on the canvas, right-click, and add them all to a new container.

Added the ability to keep or delete selected rows in a grid for downstream processing through a new suggestion.

Updated behavior for Data Profiling charts:

New math expressions Pow and SQRT are now available.

You can now paste data with new lines in the Text Input tool.

You can now schedule a workflow within Designer Cloud. Select File > Schedule to access the scheduling options for your workflow.

Updated the color for the Results Grid header so it aligns with the background color for the rest of the grid.

Enabled the ability to search specific workflows by name on the Designer Cloud landing page.

Enhanced error rendering for the Formula tool.

Enhanced tool selection behavior on the canvas:

Enabled new types of suggestions for Date and DateTime columns: DateTimeDiff and DateTimeAdd. These selections allow you to add or substract from each value in a column within some specific date range (day, month, year, min, seconds).

If you try to update a workflow with revoked access, you are redirected to the Designer Cloud landing page and any changes made are not saved.

If you try to run a workflow with revoked access, you are redirected to the Designer Cloud landing page.

If you try to run a workflow that was deleted by another user, a notification appears that notifies you that the workflow was deleted.

New Running Total tool is now available in Designer Cloud. Use Running Total to calculate a cumulative sum per row in a dataset.

Improved error message appearance on the canvas for the Join tool if you remove the join columns from the tool configuration.

Improved error message appearance for the Find Replace tool so the Lookup Table and Column to Search are now highlighted if they are empty in the tool configuration window.

Enhanced the behavior for the Workflow Out of Sync dialog, which is displayed your workflow was updated by someone else before you. Select Refresh to reload your workflow instead of the whole browser page.

Enabled the ability to filter workflows on the Designer Cloud landing page for Admin and Non-Admin users.

Text to Columns suggestions allow you to quickly and efficiently split data in the Results Grid into separate rows or columns. When you brush over a single character in a value in the Results Grid, you are given suggestions for ways to split this value into multiple rows and columns using the brushed character as a delimiter.

Selected anchors have a new color so they are easier to see.

IRR and XIRR finance expressions are available in the Summarize tool.

Updated color of selected anchors.

A Workflow Out of Sync dialog now appears if you try to navigate away from your workflow without auto-save. Interacting with the dialog will not affect your workflow.

If you try to go to a Designer Cloud page that doesn't exist, you are redirected to the landing page.

The mini-map has been turned off by default to allow you to have more space within the canvas.

Enabled the ability to collapse the Results Grid to make more space for the canvas and tool configuration windows. Changes made to the Results Grid height are saved for the next time you open your workflow.

Updated the filter style for the messages displayed in the Result Grid.

Enabled ability to view last 5 jobs runs inside Output tool. Additionally, below the job list is displayed a link on the Jobs History page.

Enabled the ability to collapse Result Grid so there is more space for the canvas and tool configuration window. If you change the size of the Results Grid, your changes are saved for the next time you open your workflow.

Regex selections are now available in Designer Cloud. "Brush" or select a portion of data that matches a certain pattern you are interested in, like a specific string format within a field. Based on your selection, new suggestions that utilize the RegEx tool are shown (specifically parse, replace, and split functionality).

You can now share Designer Cloud workflows between different users of the same workspace.  Workflows can be shared from the Platform Library page under the 3 dot menu. If several users modify the same workflow at the same time, a notification is displayed for the person who has an outdated workflow version.  Workspace Admin users are also now able to filter all or only owned workflows on the Designer Cloud landing page.

The Multi-Column Formula tool is now available in Designer Cloud. Use this tool to create or update multiple columns using a single expression.

The Dynamic Rename tool is now available in Designer Cloud. Use this tool to rename the columns passing through the data stream.

Improved error messaging when data can't be loaded in the Results Grid.

Added the Columns to Group By option to the Random % Sample tool.

Fixed an issue for the Round function within the Formula tool.

The Sort tool preserves the original order of data in the unsorted columns.

The last valid year is “9999”.

Grouped tools may have a different order.

Alteryx Engine uses a different Regex Library. The handling some of regex expressions can vary.

When selecting unique rows based on a column, Alteryx Engine might select a different row. The output order from the Unique tool might also be different. For example, in a table of addresses, if you select unique rows based on zip code, the updated Alteryx Engine might select a different address with that zip code.

New keyboard navigation added to switch between tool anchors. Use the Tab key to focus on a tool, then select and hold Ctrl+Alt and use the Up and Down arrow keys to select the tool anchor. See Keyboard Shortcuts in Designer Cloud for a list of all keyboard shortcuts.

The Random % Sample tool is now available in Designer Cloud. Use Random % Sample to return an expected number of rows that result in a random sample of the incoming data stream.

Improved the Brushing - Extract suggestion so when extracting values from Int data type columns, the new column will be also added with an Int data type.

New Brushing suggestions added:

When you run a workflow in Designer Cloud, you have an option to select the engine it runs on. We now keep that engine selection per workflow, per user, so it doesn't need to be selected each time.

You can now navigate to a URL with a workflow ID in it even if your session is not active. If you have access to the workflow, after authentication, you are redirected to the workflow.

New Brushing suggestions allow you to highlight values in the Results Grid with your cursor and view suggested transformations. To view Brushing suggestions, select and drag your cursor over a value in the Results Grid. The suggestions panel with automatically open with relevant suggestions for your selected data.

Updated Results Grid empty states.

Enabled the ability to start Resampling directly through the Result Grid.

Aligned the names of filter operators between the Filter tool and Results Grid column header and Suggestions panel.

Trigger suggestions by selecting a single bar in the data profiling chart or a single portion of the data quality bars (Ok, Not Ok, Null, Empty). Designer Cloud automatically triggers intelligent suggestions, accelerating data preparation and transforming your raw data into actionable insights faster than ever before.

You can now Split into Rows based on a delimiter from the Results Grid column header.

The Rand() function is now available in the expression library.

New Round() function suggestion for float columns. You can now select the column header to trigger a rounding suggestion in the Suggestions Panel. This suggestion uses the Formula tool and gives you the opportunity to quickly choose a rounding preferences without having to write a formula.

New Length() function suggestion for String columns. This suggestion allows you to calculate the number of symbols inside each column cell.

Restricted ability to use negative values for Number of Columns for the Split into Column action.

Minor UX improvements for Clean Up Data action.

Enhanced error validation for Split into Columns action in the Results Grid header. The validation error is now rendered by selecting 'Empty' for the input and then selecting Apply.

Updated the Alteryx Help link in the Help menu.

Added Databricks as an engine option. Note that this engine is only available if your configuration is setup correctly in the management console.

Enhanced filtering added to the Results Grid header. Additional filter operators are now supported: 'Is Empty', 'Is Not Empty', 'Contains', and 'Does Not Contain'.

Enhanced Messages functionality:

Enabled the ability to trigger the 'Split to Column' action directly from the column header menu.

Enabled the ability to filter data through the Data Quality Bar. Now, selecting a Data Quality Bar state adds a Filter tool to the canvas with the selected configuration.

Opening the Results Grid in Firefox browser is now supported.

Optimized suggestions performance for large data sets.

Updated engine selection API to make it more efficient.

Updated wording on tooltips for leading and trailing whitespaces.

Within the Data Profiling feature, you can now select the Data Quality bar to highlight selected values in the Results Grid.

Expanded categories within the Suggestions Panel remain expanded after editing and returning to the Suggestions Panel.

Enhanced error messaging for these tools: DateTime tool, Sample tool, Cross Tab tool, and RegEx tool.

New 'Empty' state added to the Data Quality bar. The 'Empty' state represents the number of cells with no value inside for string columns. The calculation of Data Profiling charts for strings columns has also been adjusted. Now, the percentage of column values calculated is based on the number of empty and null cells.

If the dataset contains cells with leading or trailing whitespaces, those cells are called out in the Results Grid, allowing for easier identification of those values.

New ‘Not Ok’ state added to the Data Quality bar, which represents the number of invalid cells in the column.

New Data Cleansing suggestions added to the Suggestions Panel. Clean data and remove leading or trailing whitespaces or remove unwanted characters by applying the recommended suggestions. Proposed options will vary based on the column data type.

Added new expressions: Regex_Replace and ReverseString.

Opening the Results Grid in a new window now works on Firefox browser.

Updated Messages section. Now, the total number of messages for the workflow is displayed in the Messages window. The number of tool specific messages is shown after you select the tool.

Photon: Suggested for jobs up to 1 GB of data. Best for smaller jobs.

Spark: Best for larger jobs. The job runs on a distributed engine.

Snowflake: This engine is suggested in only a few cases.