Designer Experience is hosted on Alteryx Analytics Cloud (AAC). For more information on the underlying platform, go to Release Notes for Alteryx Analytics Cloud Platform.
We've made several visual enhancements to containers:
Containers now have rounded edges.
Added on-hover text to the expand and collapse icons.
Container titles are now left-aligned.
Introduced a setting in the "View" menu that lets you toggle the visibility of Tool IDs and Names on the canvas. This setting is enabled by default, and you can turn it off via View > Tool Names & IDs.
This feature improves user efficiency and clarity by making it easier to identify tools, locate errors, and navigate workflows. It addresses the challenge of distinguishing tools when IDs are difficult to recognize, enhancing the overall user experience.
You can now use the Multi Column Binning tool in Cloud Native mode. This tool allows you to apply consistent binning logic across multiple columns at once, helping streamline data preparation and ensure uniform grouping across datasets.
File-based connectors now support parameterization for output file names:
String Parameterization: Insert dynamic string values into file names.
Timestamp Parameterization: Include job start date/time or relative timestamps, adjusted for time zone.
Runtime Overrides: Update parameter values before you execute workflows.
For details, go to Output Data Tool.
Added tooltips to the Summarize tool to provide clearer guidance on how to configure it, making it easier to use.
These expressions are now available in Cloud Native Mode:
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.
We fixed an issue where copying and pasting a tool on the canvas, the pasted node did not always shift as expected under specific conditions.
If the cursor remained over the original node while pasting, the first paste would shift, but the second paste would be placed directly over the original node. Subsequent pastes resumed shifting behavior.
If the cursor was moved away before pasting, then returned to the original node and pasted again, the new node would overlap before resuming normal shifting behavior.
Copying and pasting tools now consistently shift as expected, preventing overlapping placements and improving workflow efficiency.
Fixed various scenarios where the "Out of Sync" popup appeared incorrectly, even when the workflow was up to date.
These expressions are now available:
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.
The DateTimeNow tool is now available, allowing you to easily retrieve the current date and time.
Fixed an issue where workflows shared with a group of users could not be opened by members of that group.
Users can now view the Total Row Count for the full dataset in addition to the Sample Row Count. This functionality is currently available for workflow inputs and outputs:
Input tool: When uploading a new file or using an existing dataset:
Hovering over the Row Count displays the last calculation date, as dataset sizes may change over time.
Users can manually recalculate the row count to get updated results.
Output tool: When executing a Full Run, the system calculates the Total Row Count for the newly created output dataset.
The Sample/Dataset Row Count will now be displayed in the IRG header with left alignment.
Users can now leverage Databricks as the execution engine to enable a Design-Time Experience with full dataset visibility. In Cloud Native Mode, users can activate Live Query on a workflow for real-time data access.
Fixed an issue that prevented resizing the Cell Viewer window when opening the Results grid in a new window.
Dataset Row Count is not calculated in certain cases: When using a CSV file as input and a Cloud Database as output (or vice versa).
Dataset Row Count is not available mid-workflow in the following scenarios:
On any tool except Input and Output.
When joining datasets.
On tools with multiple output anchors.
Added a new notification message for workflows in Standard Mode. If data loading in the Result Grid exceeds 15 seconds, you receive a clear notification to enhance transparency and user experience.
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.
These tools are now available for Cloud Native workflows:
These expressions are now supported in Cloud Native workflows:
FinanceXNPV
FinanceNominalRate
FinanceNPER
FinanceEffectiveRate
TANH
Fixed an issue where workflows opened from the Designer Cloud Landing Page displayed outdated metadata instead of the newly opened workflow’s metadata.
Added the ability to expand or collapse all expressions in the Formula tool. The tool now retains its expanded or collapsed state when reopening a workflow, ensuring a smoother user experience.
Fixed a scenario where users with only read permissions could execute workflows through Plans.
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.
Enhanced the Formula tool's expression editor to provide a smoother and more intuitive user experience.
Links from the Help menu now open in a new window.
Added support for these cloud data connectors in Standard Mode workflows...
Amazon RDS MySQL
Amazon RDS Postgres
Amazon RDS SQL Server
MongoDB
MongoDB Atlas
MySQL
Postgres
Redshift
Snowflake
SQL Server
Teradata
Previously, Designer Cloud automatically replaced all special characters in column names with underscores. With this update, you now have control over this behavior. You can enable or disable the replacement of special characters and non-English letters in column names through the new option found in Options > Workflow Settings or select the gear icon found on the canvas.
Note that this setting is only available in Cloud Native Mode. Standard Mode workflows don't automatically replace special characters with underscores and don't have this setting.
Fixed an issue where the Result Grid would load indefinitely when uploading CSV files containing special characters. File uploads should now process smoothly.
Fixed a defect where the Select Tool was incorrectly converting String data into the DateTime format. Now, String data will only be converted to DateTime data when it's valid, ensuring data remains in its intended format.
Updated the authorization logic for accessing Designer Cloud. Workflow privileges linked to assigned product roles now govern access to the cloud app. To open the Designer Cloud app, you must have execute privileges for workflows. For reference, these are the workflow privileges granted by each cloud role:
Designer Cloud Consumer:
readandexecute.Designer Cloud Creator:
create,read,update,delete,share, andexecute.
Note that admin roles only have read and delete privileges and can't open the Designer Cloud app.
Added these expressions to the respective Cloud Native Mode tools:
asin(Math)atan(Math)atan2(Math)tan(Math)compareepsilon(Test)
You can now sort columns by Column Name and Type in the Summarize tool.
The Pin Columns option is now available in the Interactive Results Grid (IRG). Use Pin Columns to freeze 1 or more columns when working with large datasets. This feature helps you stay focused on specific columns without modifying the workflow itself, as it is only used for observation purposes.
AAC now captures audit events triggered from the Workflow Service. These events include...
create_workflowimport_workflowdelete_workflowworkflow_run_initiatedexport_workflowupdate_workflowremove_access_workflowshare_access_workflowrename_workflowset_workflow_version_name
Output parameterization is now supported through the run endpoint on the Workflow Service.
Added the More Actions menu to the Select, Append Columns, Join, and Join Multiple tools. Use the More Actions menu to...
Change multiple column data types at once.
Move columns to the top or bottom of the selection table.
Add or remove column prefixes or suffixes.
Clear or revert column changes.
Remove missing columns or cancel the selection of duplicate columns.
Resolved a defect where no data was displayed in the Interactive Results Grid (IRG) when opening an existing workflow or pasting a portion of a workflow into a new Standard or Cloud Native workflow.
Added tooltip hints for truncated cells in Standard Mode workflows.
Fixed an issue where right-clicking on the link between 2 manually connected tools didn't register the click.
Fixed a defect where profiling charts didn't display when horizontally scrolling the grid.
Added the Imputation Tool and Dynamic Replace Tool to the Standard mode tool palette.
Added the Cell Viewer functionality within the result grid for workflows in Standard Mode. Use Cell Viewer to inspect individual cell data directly within your workflow results, providing a more detailed view and improving your data analysis experience.
Fixed an issue where Canvas annotations were missing when adding the Filter tool through the IRG Column Header. Annotations now display correctly, ensuring a smoother workflow design experience.
Fixed an issue in Standard Mode workflows where downstream tools would continue spinning indefinitely when the Input tool lacked a dataset. This issue has been addressed, ensuring that your workflows run as expected, even when datasets are missing.
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.
Fixed an issue in the Interactive Result Grid where cell selection would break after selecting Data Profiling bars.
These expressions are now available in Cloud Native mode...
regex_countmatches(String)mod(Math)average(Math)randint(Math)charfromint(Conversion)smartround(Math)log(Math)stripquotes(String)median(Math)pi(Math)
Added a new type of error for Standard mode workflows—Conversion errors. Conversion errors trigger by incorrect data type conversions or conversions with some exceptions (they don't block the downstream tool execution). Conversion errors are visible in the IRG Message section.
Fixed a visual defect for comments on the Canvas if you open a workflow with the Designer Cloud Consumer role.
Conversion errors for Standard mode now properly display in the IRG Message section.
Disabled the ability to double-click to add a tool onto the canvas when a palette is disabled.
Added the Dynamic Select Tool and JSON Build Tool to the Standard mode tool palette.
Fixed an issue where adding a second input, or removing an input, from the Dynamic Rename tool resulted in an engine error still showing on the screen. Also fixed an issue where the IRG didn't react to adding or deleting the connection.
Added the Designer Cloud Consumer role. With the Designer Cloud Consumer role, users can open, view, and run workflows. When opening workflows, users encounter a non-editable UI, with the tool configuration panel disabled, the tool palette hidden, and no ability to update the Canvas.
Added new icons to denote the tool mode of your workflow. Standard mode workflows have a lighting bolt icon, while Cloud Native mode workflows have a cloud icon.
Fixed the behavior of sharing nested datasets through workflow sharing. Although some datasets couldn't be shared by sharing the workflow, they no longer block the sharing of other datasets with the appropriate permissions.
Improved Data Profiling when in Pushdown mode. Numeric charts now display quartiles based on the data range in the column.
Improved error messaging for the Join tool when missing join columns in the configuration window.
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.
Fixed an issue where Workspace Admins stopped receiving email notifications by sharing workspaces with them.
Introducing a new feature in Designer Cloud, Standard Mode! Standard Mode is now available in Public Preview for all Workspace Admins.
Standard Mode within a Dual Palette Experience: Workspace Admins can now enable Standard Mode within their workspaces. This provides users with a dual tool palette experience.
Administrator Control: All Workspace Admins have access to a new setting within Workspace Settings to turn Standard Mode on or off.
Enhanced User Experience: When a Workspace 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.
For more information, you can view the available Standard Mode Tools and compare Cloud Native Mode Versus Standard Mode in Designer Cloud.
The Join tool can now join columns with the
Datedata type.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-10109 | Fixed an issue where no data appeared in the Results Grid when you connected a Join Multiple tool and then selected the 1st input anchor. |
TBOX-10095 | Fixed an issue where the Data Profiling bar was not highlighted when you selected a Boolean data type column in the Results Grid. |
TBOX-9869 | Fixed an issue where hidden columns were displayed in the Results Grid when switching between Data View and Metadata View. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9864 | Fixed a defect where incorrect data profiling chart values are shown in the Results Grid. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-10038 | Fixed an issue where data displayed incorrectly in the Results Grid if the value contained a dash. |
TBOX-10015 | Fixed an issue where the Copy Column Data functionality in the Results Grid did not copy the column headers. |
TFFY-2012 | Fixed an issue where the default font size for comments was incorrect. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-10025 | Fixed a defect on the Designer Cloud landing page where no workflows displayed when you enabled the workflow sorting functionality. |
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.
This new error messaging only applies to existing errors.
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9992 | Fixed a defect that was causing the suggestion panel to not properly close when selecting all cells in a grid. |
TBOX-9981 | Fixed a defect where the Select All Rows shortcut was incorrectly triggered when another column was selected before. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9957 | Adjusted the wording for filter options inside the Results Grid column headers. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9978 | Fixed the behavior for editing a comment on the canvas so that any change in a comment will trigger an auto-save. |
TBOX-9971 | If Designer Cloud access is revoked while a user is editing a workflow, they are redirected to an Access Denied page. |
Multi-column suggestions are now available in the Results Grid.
For Windows users, select Ctrl and then select a non-adjacent column, or select Shift and then select and drag a range of adjacent columns.
For Mac users, select ⌘ and then select an non-adjacent column, or select Shift and then select and drag a range of adjacent columns.
Suggestions based on the columns you select are shown in the Suggestions Panel.
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9954 | Fixed an issue where the Results Grid crashed when you deleted an unselected Output tool. |
TBOX-9946 | Fixed a visual defect where Data Profiling charts were displayed incorrectly as a range of values instead of exact values when Data Type Inferring was selected or unselected. |
Updated icons for selected anchors on the canvas:
Dynamic Rename tool optional input anchor
Union tool input anchor
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TNAU-1504 | Fixed an issue where the Cross Tab tool gave a null value when trying to sum zero values. |
Updated behavior for Data Profiling charts:
For String and DateTime columns, we added a footer at the bottom of the Data Profiling chart which displays the number of the displayed values versus all the unique values inside the column.
For Numeric columns, Data Profiling bars are now grouped per 25 items in a section instead of displaying a single bar for each unique value in a column.
New math expressions Pow and SQRT are now available.
You can now paste data with new lines in the Text Input tool.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9915 | Fixed a defect that caused Data Profiling charts to display incorrectly for Numeric columns when the Data Type inferring functionality is turned off. |
TBOX-9910 | Fixed a Data Profiling defect where charts were not displayed for some String columns when columns in a grid were enabled or disabled. |
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9905 | Fixed a defect where an Out of Sync popup appeared right after the full run, even though the current workflow had the up-to-date version. |
TNAU-1490 | Lookup table keyboard navigation improvements. |
TNAU-1436 | Text Input tool usability fixes. |
TNAU-1424 | Tile Tool supports manual grouping with float columns. |
TNAU-1420 | Fixed a usability issue for the Cross Tab tool so that New Column Names does not autofill anymore. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9867 | Fixed a defect where a Data Cleansing tool was incorrectly configured when added through the Results Grid header. A cleansing action was applied to all the columns in the dataset instead of one. |
TNAU-1186 | Fixed a usability issue with the dropdown in the Join tool. |
These issues were resolved in the current release:
Item | Description |
|---|---|
TNAU-1368 | Improved UI experience for the Join tool. |
TNAU-1360 | Fixed an issue with the Data Cleansing and Weighted Average tools so the tools are now auto-populated with values. |
Enhanced tool selection behavior on the canvas:
If you select a tool on the canvas, the output anchor for the selected tool opens in the Results Grid.
If you add a tool to the canvas through right-click, Suggestions, or the Results Grid header, the output anchor for the added tool opens in the Results Grid.
If you select a tool with a configuration error, the Messages tab in the Results Grid opens.
Updated styling for selected tools 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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TNAU-1242 | Fixed an issue for the Transpose tool where warning and error icons were displayed incorrectly in the tool configuration window and on the canvas if columns were missing. |
TBOX-9811 | Fixed a defect which allowed the launch of the Resampling process even though no columns were in the dataset. |
TBOX-9837 | Fixed an issue with displaying DateTime columns in incorrect format by disabling the Data Type Inferring checkbox and refreshing the page. |
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.
Workspace Non-Admin users are now able to filter by Owned, Shared, and All workflows.
An additional filter option is available for workspace Admin users. Admin users can now filter through Unowned workflows. Unowned workflows consist of all the workflows available on the workspace where the owner is not a current user.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9765 | Fixed an issue where a double scroll was displayed while editing large annotation text on the canvas. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9761 | Fixed incorrect behavior with workflow movement when you hover over or select a large annotation text on the canvas. |
TDCS-335 | Fixed an issue in Plans where workflows scheduled to run at the same time were run multiple times. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9734 | Fixed issue where the list of workflows on the Open Workflow dialog only displayed on half of the list after you select a workflow. |
TBOX-9752 | Fixed a canvas defect where adding an Input Data tool with the same dataset as other Input Data tools caused the Input Data tools to reload. |
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).
Automated Regex Generation: Automatically generated regular expressions that match the selected pattern.
Regex-Based Suggestions: Parse data that matches the pattern, replace values that match the pattern, or split the column into multiple columns based on the detected pattern. Hover over the suggestions to see a preview of the results of the suggested Regex operation.
If the initial suggestion isn't quite right, you can adjust or modify the Regex operation manually using the Edit Suggestion functionality.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9664 | Fixed an issue with failed Data Profiling charts when enabled on Select, Union, Join, Append Fields tools. |
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.
These issues were resolved in the current release:
Item | Description |
|---|---|
TBOX-9756 | Fixed a defect that prevented scrolling large tool annotations while editing. |
TBOX-9668 | Fixed a defect with an incorrectly displayed placeholder in the Result Grid caused by unchecking and checking all the columns in the dataset through the Select tool. |
TFFY-1706 | Fixed a UI defect related to tool containers. Selection of all the tools on the canvas would display tools that are hidden inside the tool container. |
TFFY-1696 | Fixed a defect where the Run button was disabled for an extended time while adding changes to a workflow and triggering the auto-save functionality. |
TFFY-1556 | Fixed a defect where a canceled full workflow job on the job history page still showed as "In Progress". |
The Dynamic Rename tool is now available in Designer Cloud. Use this tool to rename the columns passing through the data stream.
Implemented a new loading spinner within the Results Grid that shows when you upload data or when data is trying to load in the grid.
These issues were resolved in the current release:
ID | Description |
|---|---|
TBOX-9682 | Fixed a defect where the Results Grid was incorrectly displaying multiple spaces (leading and trailing whitespace) in the grid cells. Now all spaces are displayed in cells the same way that the data is stored in the original dataset. |
TBOX-9660 | Fixed an issue where Data Profiling charts were loading multiple times. |
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.
Updates have been made to Alteryx Engine. You may notice some differences in data processing:
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.
You can now brush over a value in the Results Grid and use the Keep/Delete Rows suggestions. These suggestions use the Filter tool.
Suggestions preview displays a source column for the operation for certain suggestion types:
RegEx Parse
Formula Extract
RegEx Split into Columns
Data Cleansing suggestions are now available for float data type columns within the Results Grid and through data profiling by selecting the data quality bars. Data Cleansing can also now be accessed through the Results Grid header.
Replace suggestions using the Formula tool with brushing functionality are now available.
The preview panel for suggestions now displays a footer that shows the number of rows used to preview the future change.
These issues were resolved in the current release:
ID | Description |
|---|---|
TBOX-9695 | Fixed an issue where Data Profiling charts would remain stuck on loading animations for previously viewed columns when horizontally scrolling through the grid. |
TBOX-9656 | Fixed an issue where long values were not truncated in the Results Grid. |
TBOX-9643 | Fixed an issue where the Data Profiling section was not displaying correctly when enabled on the Text Input tool. |
TKP-519 | Fixed an issue with failed Data Profiling charts by changing some integer data type columns with years data. |
TNAU-1214 | The Find Replace tool now correctly replaces & symbol with 'Match Whole Word' checkbox. |
TNAU-1213 | Fixed the Contains and Create Columns with Replace Data combination for numeric values represented as strings for the Find Replace tool. |
TNAU-1249 | TheFind Replace tool now correctly replaces the same words if they are in different case. |
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:
Brushing - Keep and Delete Rows suggestions: When you highlight a value in the Results Grid, a suggestion appears to either keep or delete the highlighted rows.
Brushing - Replace suggestions: When you highlight a value in the Results Grid, a suggestion appears to replace the highlighted values.
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.
These issues were resolved in the current release:
ID | Description |
|---|---|
TKP-535 | Fixed a defect where a new column was added when a user applies an extract suggestion for a second time. |
TKP-555 | Fixed a defect for Brushing – Extract suggestion where the previous value was still showing in the Text to Extract input while choosing a new column. |
TBOX-9590 | Fixed an issue where the 'No results to display' empty state occasionally displayed in the Results Grid when switching between tools and anchors. |
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.
Updated the default placeholder text in the Messages section when no messages are available for a tool or workflow.
Updated styling and messaging for these empty states:
No data passing through.
No tool connection.
No results to display.
No columns visible.
No columns selected.
These issues were resolved in the current release:
ID | Description |
|---|---|
TBOX-9599 | Fixed a defect for tools with multiple output anchors where accessing the Resampling was unavailable through the Results Grid if Resampling was in progress on one of the anchors. |
TBOX-9597 | Fixed a defect for tools with multiple output anchors where accessing Resampling from the Results Grid was opening the wrong output anchor inside the tool configuration window. |
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.
These issues were resolved in the current release:
ID | Description |
|---|---|
TKP-432 | Fixed a visual defect where the Suggestions panel overlapped the last selected column. |
These issues were resolved in the current release:
ID | Description |
|---|---|
TFFY-1522 | Fixed an issue with auto-save in the case the user closes the tab right before it calls the API. |
Resampling, accessed through the tool configuration window, allows you to collect new sample data and manage different samples used in your workflow. You can resample data on all Designer Cloud tools. For more information on Resampling, see Resampling for Designer Cloud.
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.
These issues were resolved in the current release:
ID | Description |
|---|---|
TKP-490 | Fixed a defect in the Data Profiling chart with incorrect filtering through profiling bars for Numeric columns if the minimum or maximum value in the column is equal to zero. |
TKP-488 | Fixed a defect in the Data Profiling chart with the minimum range value for the selected profiling bar was not highlighting correctly. |
TKP-345 | Renamed filter operators for boolean columns to align names with functionality inside the Filter tool. |
TKP-462 | Fixed a visual defect where an error border did not appear around the Output Column Name input while changing the string length for the Formula tool. |
TKP-441 | Fixed incorrect wording inside the Suggestions Panel when there is no column selected. |
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.
These issues were resolved in the current release:
ID | Description |
|---|---|
TKP-440 | Fixed an issue with broken Suggestions panel preview. |
TBOX-5551 | Fixed an issue with incorrect results displaying in Data Profiling section by enabling it on the Filter tool. |
TBOX-9507 | Fixed UI defect where incorrect Results Grid column header menu or sub-menu displayed by scrolling horizontally. |
TFFY-1516 | Fixed an issue where trying to delete a tool too quickly after Designer Cloud loads caused the application to freeze. |
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:
If any warning message is triggered for a particular tool, this message will be shown on the canvas, similar to how error messages are currently displayed.
A count of workflow and tool messages is displayed inside the Anchor section of the Results Grid.
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.
These issues were resolved in the current release:
ID | Description |
|---|---|
TKP-384 | Fixed incorrect border around the Message tabs in the Results Grid. |
TBOX-9505 | Fixed an issue where the tool configuration window would not render an appropriate error message when dataset permissions were revoked for the selected dataset. |
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.
These issues were resolved in the current release:
ID | Description |
|---|---|
TBOX-9497 | Fixed a visual issue for selecting columns with a long name inside the Result Grid. |
TKP-311 | Fixed an issue where no suggestion previews displayed while hovering over Rename suggestions. |
TFFY-1474 | Fixed an issue where the sample workflows weren't showing accurate errors before you run the workflow. |
TFFY-1319 | Fixed an issue where the Run Job button was still enabled, even if the Output tool wasn't fully configured, which resulted in an error. |
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.
These issues were resolved in the current release:
ID | Description |
|---|---|
TBOX-9439 | Fixed an issue where the Suggestion hover icon was not displaying when unselecting a column in the Results Grid. |
TFFY-1432 | Fixed an issue where the Run button on the Marketing workflow sample was not enabled after configuring all outputs. |
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.
Improved error messaging for the Find Replace tool and the Text to Columns tool.
You can now select a specific engine to run yourDesigner Cloud jobs. To select an engine, select the arrow next to the Run Job button and select your engine from the list.
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.
Use when the source and target both are Snowflake.
Use when the source is a supported file type and the target is Snowflake.
Use when the source is Snowflake and the target is a supported file type.
Enabled additional data cleansing functionality inside the Results Grid to remove unwanted characters through the column header menu. Leading and trailing spaces, letters, numbers, tabs, line breaks, and other data cleansing options available in the Data Cleansing tool are now also supported in the Results Grid.
Enhanced behavior for data profiling charts. Now, if all values inside the column are unique, the data profiling chart won't be rendered. This optimizes the overall profiling performance.
Show All and Hide All column selection has been improved to truncate long column names.
Improved styling for 'No Columns Visible' empty placeholder in Results Grid.
Added a visual improvement to the Result Grid header. Now, switching to the Metadata section also shows you the number of columns in the dataset.
Created a new empty state inside the Results Grid while all columns are hidden in the Results Grid.
Updated UI styling for the Show All and Hide All column selection inside the Results Grid header.
Enhanced behavior for the Suggestions panel with a large list of suggested actions. Now, only the first 4 options will be displayed. To view additional options, select the expand button inside the Suggestion section.
Updated the color scheme inside the Suggestions panel to align it with existing colors used in the Expression Editor.
Updated tooltip wording for the Suggestion header in the Results Grid.
Operators for Filter tool suggestions are now described with words instead of mathematical symbols.
The Filter tool can now support numbers starting with a decimal point.
New 1 in Every N Rows will be Sampled method added to the Sample tool.
These issues were resolved in the current release:
ID | Description |
|---|---|
TKP-316 | Fixed a defect where incorrect styling displayed inside the Suggestion panel while no column was selected in the Results Grid. |
TKP-314 | Fixed an issue with incorrectly displayed action name on the Suggestion panel header. |
TKP-300 | Fixed a defect where Suggestions was turning off while switching between the Data and Metadata view in the Results Grid. |
TKP-295 | Fixed an issue for the Result Grid, with no truncation on UI for the cells which contain a long value. |
TKP-286 | Fixed an issue with randomly displaying loading animation within the Suggestions panel. |
TKP-274 | Fixed an issue where switching between editing suggestions and returning to the list view returned you to the top of the Suggestions list. Now, after editing a suggestion, you are returned to your previous location in the Suggestions list. |
TKP-266 | Fixed a visual defect with incorrect styling for an empty placeholder inside the Suggestion panel while suggestions are turned off. |
TBOX-9398 | Fixed a defect with a disappearing 'empty placeholder' message inside the Result Grid by selecting twice on the output anchors for Join or Filter tools. |
TBOX-9384 | Fixed a visual defect with incorrect column selection inside the Result Grid by removing and adding new columns inside the Select tool. So now, each time you change the number of columns inside the dataset, all the selected columns will be unchecked. |
The new landing page for Designer Cloud includes 2 additional sample workflows and One Tool Examples. It also now includes a link to Alteryx Academy.
Improved wording of tooltip on the Suggestions icon.
Preview your suggestions from the Suggestions panel prior to applying them to the canvas. Hover over the suggestion to see the new preview.
Ability to turn on and off Suggestions added. Once Suggestions are turned off, any column header selection would not lead to opening the Suggestion panel. This setting is enabled/disabled through:
Designer Cloud header inside the View menu.
Suggestion panel header using the 3-dot menu.
Updated the loading animation and experience when loading a dataset through Input Data tool.
Enhanced UX and visual layout for the Summarize tool.
New expressions added: datetimeparse and datetimetrim.
In the expression library, the Contains function supports dynamic target argument.
These issues were addressed in the current release:
ID | Description |
|---|---|
TBOX-9383 | Fixed an issue with incorrect Data Profiling chart scaling for boolean columns. |
TBOX-9309 | Fixed defect with keeping column selection by closing Result Grid in a new browser window. |
TBOX-9104 | Fixed a visual defect with displaying column header borders inside Result Grid. |
TNAU-891 | Filter tool now works with decimal numbers. |
TNAU-882 | Fixed Contains method for Find Replace tool. |
Hover over tools in the tool palette to access new One Tool Examples. Select Example to open a new workflow that you can review configurations and transformations within. You can also save the workflow to edit and run. To hide the tooltip flyouts, turn off this setting in your View options.
Modify the default configuration for these suggestion actions:
Column Rename
Column Drop
Sorting
Filtering
In addition, you can now reselect the column to which the particular suggestion will be applied and apply edits from the Suggestions panel.
Enhanced UX and visual layout for Arrange tool.
Updated tooltip wording for the Join tool.
Enhanced the size of tool containers to make them easier to use and expand.
These issues were addressed in the current release:
ID | Description |
|---|---|
TBOX-9396 | Fixed an issue with Data Profiling crash on DateTime columns if those columns weren't visible in the Sample Results grid. |
Check out new Suggestions for transforming your data directly from the Sample Results window. Access suggestions by simply clicking on the column in the Sample Results window. Within the Suggestions panel, Sort Suggestion allows you to easily sort columns by Ascending or Descending order.
You can now also export sample data from a tool's anchor as a CSV file. Select Export as CSV from the More Actions menu in the Sample Results window.
Updated the Union tool to enhance the usability and clarity of labels in the tool configuration panel.
Added tooltips to the Output Anchor Diagrams in the Join tool configuration window to help explain the differences between the output types.
These issues were addressed in the current release:
ID | Description |
|---|---|
TFFY-1296 | Fixed an issue with the pagination on the landing page. |
TFFY-1298 | Selecting output anchors for tools with multiple outputs would select the wrong anchor by default, rather than the anchor the user selected. |
TFFY-1335 | Fixed an issue where some datasets would not load. |
Export your workflow results to an Excel workbook. For more information, see Output Data tool.
You cannot specify names of individual Excel sheets.
If an workbook of the same name exists in the target location, the file is overwritten.
Import datasets for use in Designer Cloud using the Data tab in Alteryx Analytics Cloud. For more information, see Library for Data.
Updated color and contrast for the Results Grid to enhance accessibility.
You can now delete workflows one at a time directly from the Designer Cloud home page.
Designer Cloud has been updated to use the latest UI library capabilities.
These issues were addressed in the current release:
ID | Description |
|---|---|
TBOX-9350 | Infinity loading in Results Grid by adding tools with sorting functionality (Sort or Sample). |
TBOX-9292 | Data Profiling charts not rendering on columns with a DateTime data type. |
TBOX-9274 | Optimized column selection performance for a grid with enabled Data Profiling to ensure there is no visual lag when selecting a column header. Similar improvements for large datasets will be part of future enhancements. |
TBOX-8599 | Results Grid header overlaps the Expression Editor menu while expanded. |
TBOX-8285 | Tools with a long name will be truncated inside the Results Grid Message section. |
TNAU-407 | Transpose tool (and other tools with checkbox lists for column names) shows errors if some columns are missing from the input. |
When the browser language is set to Japanese, the DateTime output column returns “NULL” values. Designer Cloud currently supports only English. To resolve this issue, ensure your browser language preference is set to English.
After you run a Designer Cloud workflow, navigate to the Platform home page, then to the Job History page to look at specific jobs. Select a job from the list to see the Job Details, which gives you insights about the job execution, any errors, and the details of the run.
There are two limitations for the new Job Details page:
"Dataset deleted" is shown as a workflow name for deleted workflows.
As an admin, you can't see details of jobs run by others.
Annotations for the Basic Filter options in the Filter tool now appear on the canvas underneath the tool.
Second auto completion now works in the Expression Editor in the Formula tool. Previously, if you had entered a value with autocomplete and tried to add a second value, autocomplete would not trigger.
Updated color and styling for the Mini-Map and Comment editing feature.
To reduce performance load, Data Profiling on large datasets is now calculated only for those columns which are visible to the user. For for the rest of the columns, Data Profiling will be executed per column ranges in order to reduce performance load with simultaneously calculated columns.
These issues were addressed in the current release:
ID | Description |
|---|---|
TBOX-9316 | Fixed several scenarios that caused Data Profiling crashes by triggering some actions through the Results Grid column header:
|
TBOX-9303 | Incorrect column name displayed in the Suggestion panel while renaming a column in the Result Grid header. |
TBOX-9277 | Enabled the scroll bar inside the Result Grid Anchors section, which improved the navigation between the anchors for the Join tool when the Result Grid is collapsed. |
TFFY-1215 | Improved navigation between workflows and Input anchors, ensuring that data within the Results Grid loads properly and timely. |
Updated colors and contrast in the tool palette, canvas, and containers enhance the accessibility and usability of Designer Experience.
Improved the experience opening workflows that contain what used to be "unsupported tools", such as containers and comments, or the Input tool when you first connect to data. Previously this was causing a workflow error.
These issues were addressed in the current release:
ID | Description |
|---|---|
TFFY-1215 | Improved navigation between workflows and Input anchors, ensuring that data within the Results Grid loads properly and timely. |
TFFY-1223 | Updated workflow behavior for configured and unconfigured inputs so that you are still able to add tools to inputs with data configured and the workflow will allow you to advance in your journey. Previously the input that was not configured disabled the progression of a workflow. |
TAC-262 | Output validation helps identify data errors that are preventing workflows from running. For example, if the column header in the Input source contains spaces, the validation error in the Output tool will show what needs to be fixed. |
You can now rename workflows in the canvas header.
You now receive a notification after you select Run and a new job is added to the queue.
This is the initial set of release notes for Designer Experience.
Designer Experience brings our familiar Designer Desktop interface to the browser for data profiling, preparation, blending, and analytics. Build intuitive visual workflows or analytics processes, all in the cloud, and easily scale and democratize analytics across your organization. Designer Experience will continuously be up to date with the latest features available, bringing new capabilities to your fingertips, effortlessly.
A new first time experience tour has been added to Designer Experience. This is designed to help new users get up and running in record time. For creators that are familiar with Designer Desktop, skip the tour and get right to work.
Create and review Designer Cloud workflows from the Cloud Portal. See Library for Assets Page.