Page tree


Contents:

NOTE:  Designer Cloud Powered by Trifacta Educational is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

   

Contents:


September 26, 2022

Release 9.5

What's New

The name of this product edition has changed. Trifacta Wrangler is now known as Designer Cloud Powered by Trifacta Educational

Check out the updated resources in the left nav bar and on the Home page! 

Schema refresh supports Excel, PDF, and Google Sheets:

You can now refresh the schemas from Excel, PDF or Google Sheets datasources converted during ingest. Schema refresh enables you to identify changes to the columns in your dataset. 

Changes in System Behavior

New pricing and packaging model

Release 9.5 introduces a new model for what is packaged in Enterprise, Professional, and Starter product editions and pricing for each edition. 

  • Existing customers on the old model may continue to use their current set of features until their subscription expires.
    • These customers cannot downgrade to another old-model product edition. 
  • When their subscription expires:
    • They can renew their subscription using a product edition under the new model. 
    • They cannot renew using any product edition under the old model.

NOTE: The new pricing and packaging model introduces some changes to the features that are available for each product edition. For example, API access has changed. Additional information is below.

For more information on differences between product editions in the new model, please visit Pricing and Packaging.

For additional questions, please contact  Alteryx Support.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

August 2, 2022

Release 9.4

What's New

None.

Changes in System Behavior

None.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

May 3, 2022

Release 9.3

What's New

Expandable left nav bar:

The new left navigation bar can be expanded to display full-text options for each menu item. Collapse it to reclaim the screen area. Available options remain consistent. See Home Page.

Changes in System Behavior

Generate an initial sample:

When generating an initial sample from a set of files in a directory, the maximum number of files that can be read is now limited to 10.

  • Previously, the  Designer Cloud application  read files until either 10MB of data or all matching files had been scanned.
  • This change is to limit the number of files that must be read for various operations in the Transformer page. It only applies to generating the initial sample type. Other sampling types, such as random sample, can scan the full set of files.

As needed, an administrator can change this maximum limit.

Transformer page:

Improved performance of the Transformer page through asynchronous loading of initial samples.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

April 4, 2022

Release 9.2

What's New

Lock/unlock column data type:

You can now lock or unlock a column's data type. When the data type is locked, the  Designer Cloud application  no longer attempts to infer the column's data type when subsequent recipe steps are applied. 

Tip: You can unlock the individual 's column data type through column menu. To the left of the column name, you can click the icon and select Automatically update to change the column's data type. For more information, see Column Menus.

Tip: As an early step in your recipe, you can use the Advanced column selector in the Change column data type transformation to specify locking of the data types for all columns.

For more information, see Change Column Data Type.

Changes in System Behavior

Set column data type transformation locks the column's type by default:

Starting in this release, the column data type is locked by default when you change the column data type.

NOTE: This change in behavior does not affect recipe steps that were defined before this release. Column data types continue to be re-inferred after those recipe steps. For those steps, you can edit them and mark them as locking the data type, if preferred.

If required, you can unlock the column's data type. For more information, see Change Column Data Type.

Deprecated

None.

Key Bug Fixes

TicketDescription
TD-66185Flatten transformation cannot handle multi-character delimiters.

New Known Issues

None.

March 10, 2022

Release 9.1

What's New

Sample Job IDs:

When a sample is collected, a job ID is generated and displayed in the  Designer Cloud application . These job IDs enable you to identify the sample jobs.

Changes in System Behavior

None.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

January 31, 2022

Release 9.0

No updates.

January 10, 2022

Release 8.11

What's New

Performance:

  • Improved performance during design time through intelligent caching of recipe steps. 
    This feature has been disabled. This feature is currently disabled due to technical issues. When this message is gone, it will be available in the product.
    For updates on system status, please visit https://status.trifacta.com/.

Changes in System Behavior

Data type mismatches can now be written out in CSV format

Beginning in this release, for CSV outputs mismatched values are written as regular values by default. In prior releases, mismatched values were written as null values in CSV outputs.

See Improvements to the Type System.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

November 22, 2021

Release 8.10

What's New

Session Management:

You can view the current and recent sessions for your account in the  Designer Cloud application . As needed, you can revoke any unfamiliar devices or sessions. For more information, see Sessions Page.

Changes in System Behavior

Ingestion:

Maximum permitted record length has been increased from 1 MB to 20 MB. For more information, see Working with JSON v2.

Split transformation:

When splitting a column based on positions, the positions no longer need to be listed in numeric order. See Changes to the Language.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

October 26, 2021

Release 8.9

What's New

Sampling:

  • Adjust the size of samples loaded in the browser for your current recipe to improve performance and address low-memory conditions. See Change Recipe Sample Size.

Changes in System Behavior

None.

Deprecated

None.

Key Bug Fixes

TicketDescription
TD-65502Datasets from parameters are improperly being permitted to be referenced in recipes and returns an error during job execution.

New Known Issues

None.

September 27, 2021

Release 8.8

What's New

Flow View:

  • Updated context panel for output objects. For more information, see View for Outputs.

Changes in System Behavior

Import:

Improvements have been made in how double quotes are handled in CSV files during import to align  Designer Cloud Powered by Trifacta Educational with other systems that support CSV import. 

  • Example values in source CSV file:

    """My product""",In stock,"16,000",0.05

    Note that the value 16,000 must be double-quoted, since the value contains a comma, which is the field delimiter.

  • Previously, this value appeared in the Transformer page in columns as the following:

    c1c2c3c4
    """My product"""
    In stock
    "16,000"
    0.05
  • As of this version, the  Designer Cloud application  handles the values in a better manner when displaying them in the Transformer page:

    c1c2c3c4
    "My product"
    In stock
    16,000
    0.05
    • c1: Escaped values (tripe double-quotes) in the source no longer render in the application as triple double-quotes and are represented as quoted values.

    • c3: Note that the double quotes in c3 have been stripped. Leading and trailing quotes are trimmed if the quotes are balanced within a cell.

      NOTE: This change in behavior applies only to newly created imported datasets sourced from a CSV file. Existing imported datasets should not be affected. However, if a newly imported dataset is transformed by a previously existing recipe that compensated for the extra quotes in the Transformer page, the effects on output data could be unpredictable. These recipes and their steps should be reviewed.

      This change does apply to any newly imported dataset sourced from CSV and may cause the data to change. For example, if you export an older flow and import into a new workspace or project, this change in parsing behavior applies to the datasets that are newly created in the new environment. Recipes may require review upon import.

  • When results are generated in CSV, output files should continue to reflect the formatting of the source data before import. See above.

    Tip: You can also choose the Include quotes option when creating a CSV output.

    • When profiling is enabled, values that appear in CSV as "" are now marked as missing.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-63974

In imported datasets sourced from CSV files, double quotes that are escaped with a backslash ( \"backslash-escaped value\") can cause remainder of row to be compressed into a single cell.


September 1, 2021

Release 8.7

What's New

Browsers:

  • Update to supported browsers:
    • Mozilla Firefox is generally supported.
    • Microsoft Edge is now supported.

      NOTE: This feature is in Beta release.
    • New versions of supported browsers are now supported.
    • For more information, see Browser Requirements.

Recipe panel:

Changes in System Behavior

None.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-63517

Unpivoting a String column preserves null values in Spark but converts them to empty strings in Photon. Running jobs on the different running environments generates different results.

Workaround:  After the unpivot step, you can add an Edit with formula step. Set the columns to all of the columns in the unpivot and add the following formula, which converts all missing values to null values:

IF(ISMISSING($col),NULL(),$col)

August 2, 2021

Release 8.6

What's New

Performance:

  • Conversion jobs are now processed asynchronously. 

  • Better management of file locking and concurrency during job execution. 

Better Handling of JSON files

The  Designer Cloud application  now supports the regularly formatted JSON files during import. You can now import flat JSON records contained in a single array object. With this, each array is treated as a single line and imported as a new row. For more information, see Working with JSON v2.

Changes in System Behavior 

None.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

June 28, 2021

Release 8.5

What's New

Flow View:

Job execution:

You can choose to ignore the recipe errors before job execution and then review any errors in the recipe through the Job Details page.

Language:

  • NUMVALUE function can be used to convert a String value formatted as a number into an Integer or Decimal value.
  • NUMFORMAT function now supports configurable grouping and decimal separators for localizing numeric values.
  • For more information, see Changes to the Language.

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

May 24, 2021

Release 8.4

What's New

Template Gallery:

  • Check out the new gallery of flow templates, which can be imported into your workspace. These templates are pre-configured to solve the most compelling loading and transformation use cases in the product. For more information, see www.trifacta.com/templates.
    • For more information on importing flows into your workspace, see Import Flow.

Language:

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-60881Incorrect file path and missing file extension in the application for parameterized outputs
TD-60382

Date format M/d/yy is handled differently by PARSEDATE function on Trifacta Photon and Spark.

New Known Issues

None.

May 5, 2021

Release 8.3 - push 2

What's New

None.

Changes in System Behavior

Improved method of JSON import

Beginning in this release, the  Designer Cloud application  now uses the conversion service to ingest JSON files during import. This improved method of ingestion can save significant time wrangling JSON into records.

NOTE: The new method of JSON import is enabled by default.

For more information, see Working with JSON v2.

Flows that use imported datasets created using the old method continue to work without modification.

Key Bug Fixes

None.

New Known Issues

None.

April 26, 2021

Release 8.3

What's New

Single login for multiple workspaces: Login through https://cloud.trifacta.com and then choose the workspace to which to connect. If you are a member of multiple workspaces, you can switch between workspaces through the User menu. For more information, see Home Page.


Job results:

You can now preview job results and download them from the Overview tab of the Job details page. For more information, see Job Details Page.

Tip: You can also preview job results in Flow View. See View for Outputs.

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-60701Most non-ASCII characters incorrectly represented in visual profile downloaded in PDF format
TD-59854Datetime column from Parquet file incorrectly inferred to the wrong data type on import.

New Known Issues

None.

March 22, 2021

Release 8.2

What's New

Preferences:

  • Re-organized user account, preferences, and storage settings to streamline the setup process. See Preferences Page.

Spark Execution Properties Settings:

Advanced Spark parameters have been newly added to the Spark running environment. Use these parameters to override the global Spark settings for individual jobs. For more information, see Spark Execution Properties Settings.

Improve Accessibility of Job Results:

The Jobs tabs have been enhanced to display the list of latest and the previous jobs that have been executed for the selected output.

For more information, see View for Outputs.

Sample Jobs Page:

You can monitor the status of all sample jobs that you have generated. Project administrators can access all sample jobs in the workspace. For more information, see Sample Jobs Page.

Changes in System Behavior

None.

Key Fixes

TicketDescription
TD-59236Use of percent sign (%) in file names causes Transformer page to crash during preview.
TD-59218BOM characters at the beginning of a file causing multiple headers to appear in Transformer Page.
TD-58932Cannot read file paths with colons from EMR Spark jobs
TD-58802Running job on Photon using zipped CSV that was uploaded yields garbage characters in output.
TD-58694Very large number of files generated during Spark job execution

New Known Issues

TicketDescription
TD-60701Most non-ASCII characters incorrectly represented in visual profile downloaded in PDF format.

March 9, 2021

Release 8.1, push 2

What's New

Macro updates:

You can replace an existing macro definition with a macro that you have exported to your local desktop.

NOTE: Before you replace the existing macro, you must export a macro to your local desktop. For more information, see Export Macro.

For more information, see Macros Page.

Changes in System Behavior

None.

Key Fixes

None.

New Known Issues

None.


February 26, 2021

Release 8.1

What's New

Specify column headers during import

You can specify the column headers for your dataset during import. For more information, see  Import Data Page .

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-56170The Test Connection button for some relational connection types does not perform a test authentication of user credentials.
TD-54440

Header sizes at intermediate nodes for JDBC queries cannot be larger than 16K.

Previously, the column names for JDBC data sources were passed as part of a header in a GET request. For very wide datasets, these GET requests often exceeded 16K in size, which represented a security risk.

New Known Issues

None.

January 26, 2021

Release 8.0

What's New

Import:

  • Improved method for conversion and ingestion of XLS/XSLX files. For more information, see Import Excel Data.

Recipe development:

  • The Flag for Review feature enables you to set review checkpoints in your recipes. You can flag recipe steps for review by other collaborators for review and approval. For more information, see Flag for Review.

Update Macros:

  • Replace / overwrite an existing macro's steps and inputs with a newly created macro.
  • Map new macro parameters to the existing parameters before replacing.
  • Edit macro input names and default values as needed. 

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

December 21, 2020

Release 7.10

What's New

Tip: Check out the new in-app tours, which walk you through the steps of wrangling your datasets into clean, actionable data.

Import:

  • The maximum permitted size of a file uploaded through  Designer Cloud application  has been increased from 100 MB to 1 GB.

Photon:

Introducing Trifacta Photon, an in-memory running environment for running jobs. Embedded in the Designer Cloud Powered by Trifacta Educational, Trifacta Photon is fast and best-suited for small- to medium-sized jobs.

  • When you choose to run a job, you can now choose to run a job on Trifacta Photon.
  • Designer Cloud Powered by Trifacta Educational specifies the most appropriate running environment as the default selection based on the size of your job.
  • For more information, see Run Job Page.

Sampling:

  • Trifacta Photon also enables quick scan sampling. A quick scan sample generates an appropriate selection of rows from the dataset from which to perform the sample. These samples are faster to generate. For more information, see Overview of Sampling.
  • For more information on generating samples, see Samples Panel.

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

November 18, 2020

Release 7.9

What's New

Flow View:

  • Export your flows to back up your flow logic. For more information, see Export Flow.
    • As needed, you can import flows back into the product. See Import Flow.

Transform Builder:

  • An All option has been added for selecting columns in the Transform Builder.  For more information, see Changes to the Language page.

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-55125Cannot copy flow.

New Known Issues

None.

October 19, 2020

Release 7.8

What's New

Flow View:

  • The viewport position and zoom level are now preserved when returning to a given flow.

Language:

  • Rename columns now supports  uppercase or lowercase characters or shorten column names to a specified character length from the left or right. For more information, see  Changes to the Language .

Changes in System Behavior

Enhanced  Flow and Flow View menu options :

The context menu options for Flow View and Flow have been renamed and reorganized for a better user experience.

Key Bug Fixes

None.

New Known Issues

None.

September 21, 2020

Release 7.7

What's New

Flow View:

  • Automatically organize the nodes of your flow with a single click. See Flow View Page.

Changes in System Behavior

Deprecated Parameter History Panel Feature 

As a part of collaborative suggestions enhancement, the support for Parameter History panel is deprecated from the software. For more information on collaborative suggestions feature, see Overview of Predictive Transformation.

Classic Flow View no longer available

In Release 7.6, an improved version of Flow View was released. At the time of release, users could switch back to using the classic version. 

Beginning in this release, the classic version of Flow View is no longer available. 

Tip: The objects in your flows that were created in classic Flow View may be misaligned in the new version of Flow View. You can use auto-arrange to re-align your flow objects.

For more information, see Flow View Page.

Key Bug Fixes

None.

New Known Issues

None.

August 19, 2020

Release 7.6

What's New

Experimental feature: Got feedback? We'd love to hear it. Please contact Alteryx Support.


Job Execution:

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-48915Inserting special characters in an output filename results in a validation error in the the application and job failures.

New Known Issues

None.

This page has no comments.