Release Notes for Designer Cloud

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.

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.

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 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.

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

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 the following 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.