Page tree

 

Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

Contents:


April 10, 2019

This introduces new selection-specific operations, including replacement of individual cell values, as well as bug fixes.

What's New

Wrangling:

Changes to System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

March 4, 2019

This release of Trifacta® Wrangler introduces key features around job monitoring and column management, including multi-select and copy and paste of columns and column values. A new Job Details page captures more detailed information about job execution and enables more detailed monitoring of in-progress jobs. 

What's New

NOTE: The PNaCl client for Google Chrome has been replaced by the WebAssembly client. This new client is now the default in use by the platform and is deployed to all clients through the browser. Please verify that all users in your environment are on Google Chrome 68+. For more information, see Desktop Requirements.

Wrangling:

  • In data grid, you can select multiple columns before receiving suggestions and performing transformations on them. For more information, see Data Grid Panel.
    • New Selection Details panel enables selection of values and groups of values within a selected column. See Selection Details Panel.
  • Copy and paste columns and column values through the column menus. see Copy and Paste Columns.
  • Support for importing files in Parquet format. See Supported File Formats.

Monitoring:

  • Monitor the status of in-progress jobs through the new Job Details page. See Job Details Page

Wrangle:

  • New functions:

    Function NameDescription
    ARRAYINDEXOF Function

    Computes the index at which a specified element is first found within an array. Indexing is left to right.

    ARRAYRIGHTINDEXOF Function

    Computes the index at which a specified element is first found within an array, when searching right to left. Returned value is based on left-to-right indexing.

    ARRAYSLICE Function

    Returns an array containing a slice of the input array, as determined by starting and ending index parameters.

    ARRAYMERGEELEMENTS Function

    Merges the elements of an array in left to right order into a string. Values are optionally delimited by a provided delimiter.

  • The LISTUNIQUE function is now the UNIQUE Function.
  • All LIST* functions now accept Array type only inputs.

Changes to System Behavior

$filepath disabled

In a prior release, the $filepath reference was enabled in Trifacta Wrangler. Since all file paths are to the local desktop, this reference is considered unreliable. It has been disabled for use in this version and subsequent versions of the product.

NOTE: If your recipes contain references to $filepath in them, they are broken in the new version of the product. Please review your recipes in the Transformer Page to see if specific steps are broken.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-38869

Upload of Parquet files does not support nested values, which appear as null values in the Transformer page.

Workaround: Unnest the values before importing into the platform.


February 5, 2019

What's New

NOTE: The PNaCl client for Google Chrome has been replaced by the WebAssembly client component. This new client is now the default in use by the platform and is deployed to all clients through the browser. For more information, see Desktop Requirements.

 

Wrangling:

Workspace:

  • New functions:

    The following functions can now be applied directly to arrays to derive meaningful statistics about them. 

    FunctionDescription
    ARRAYSORT Function

    Sorts array values in the specified column, array literal, or function that returns an array in ascending or descending order.

    TRANSLITERATE Function

    Transliterates Asian script characters from one script form to another. The string can be specified as a column reference or a string literal.

Changes to System Behavior

None.

Errata

In prior releases, the product and documentation stated that the platform implemented a version of regular expressions based on Javascript syntax. This is incorrect.

The Trifacta platform implements a version of regular expressions based off of RE2 and PCRE regular expressions.

NOTE: This is not a change in behavior. Only the documentation has been changed.

Key Fixes

None.

New Known Issues

None.

January 10, 2019

What's New

Language:

  • New functions to compute statistics on arrays.
  • Track file-based lineage using $filepath and $sourcerownumber references. See Source Metadata References.

Jobs:

  • Filter list of jobs by source of job execution or by date range. See Jobs Page.

Changes to System Behavior

None.

Key Fixes

None.

New Known Issues

None.

December 4, 2018

This release includes one new feature and a number of updates to address issues in the platform.

What's New

NOTE: Beginning in this release, Trifacta® Wrangler utilizes the WebAssembly client extension in Google Chrome. This replaces the PNaCl client extension, which was used in earlier releases. No configuration is required. For more information, see Desktop Requirements.

 

  • Organize your flows into folders. See Flows Page.

Changes to System Behavior

None.

Key Fixes

TicketDescription
TD-36332Data grid can display wrong results if a sample is collected and dataset is unioned.
TD-36192Canceling a step in recipe panel can result in column menus disappearing in the data grid.

New Known Issues

None.

October 24, 2018 Update

This release is primarily focused on fixing issues in the platform.

What's New

None.

Changes to System Behavior

None.

Key Fixes

TicketDescription
TD-35504
Cancel job throws 405 status code error. Clicking Yes repeatedly pops up Cancel Job dialog.

TD-35481

Recipe is malformed after software update.

New Known Issues

None.

October 2, 2018 Update

What's New

Tip: For a general overview of the product and its capabilities, see Product Overview.

Transformer Page:

Jobs:

Language:

  • Rename columns using values across multiple rows. See Rename Columns.

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-34472Splitting a column on multiple pattern yields an error in the Transformer page.
TD-31252Assigning a target schema through the Column Browser does not refresh the page.

New Known Issues

TicketComponentDescription
TD-34840Transformer PagePlatform fails to provide suggestions for transformations when selecting keys from an object with many of them.

August 30, 2018 Update

What's New

Transformations:

Transformation NameDescription
Bin columnPlace numeric values into bins of equal or custom size for the range of values
Scale columnScale a column's values to a fixed range or to zero mean, unit variance distributions.
One-hot encodingEncode values from one column into separate columns containing 0 or 1, depending on the absence or presence of the value in the corresponding row.
Group ByGenerate new columns or replacement tables from aggregate functions applied to grouped values from one or more columns.

Publishing:

  • Add quotes as CSV file publishing options. See Run Job Page.

Changes to System Behavior

None.

Key Bug Fixes

TicketDescription
TD-34407Profile job fails due to Out of Memory error.
TD-34390Profile job fails with bigger than spark.driver.maxResultSize error.
TD-34389Transform job fails when sorting on a Boolean column.
TD-33428

Job execution on recipe with high limit in split transformation due to Java Null Pointer Error during profiling.

NOTE: Avoid creating datasets that are wider than 2500 columns. Performance can degrade significantly on very wide datasets.

TD-33744If you cancel out of a previewed join, the previewed dataset remains in the flow.

 

New Known Issues

None.

July 30, 2018 Update

What's New

Transformer Page:

  • Join tool is now integrated into the context panel in the Transformer page. See Join Panel.
  • Patterns are available for review and selection, prompting suggestions, in the context panel.

Changes to System Behavior

New Functions

Function NameDescription
DOUBLEMETAPHONE FunctionReturns a two-element array of primary and secondary phonetic encodings for an input string, based on the Double Metaphone algorithm.
DOUBLEMETAPHONEEQUALS FunctionCompares two input strings using the Double Metaphone algorithm. An optional threshold parameter can be modified to adjust the tolerance for matching.

 

Key Bug Fixes

None.

New Known Issues

TicketComponentDescription
TD-33744Transformer Page - Tools

If you cancel out of a previewed join, the previewed dataset remains in the flow.

Workaround: Remove the previewed dataset through Flow View.

 

June 26, 2018 Update

What's New

Changes to System Behavior

SOURCEROWNUMBER function generates null values consistently

The SOURCEROWNUMBER function returns the row number of the row as it appears in the original dataset. After some operations, such as unions, joins, and aggregations, this row information is no longer available.

Previously, the results were confusing. When source row information was not available, the function was simply not available for use.

Now, the behavior of the SOURCEROWNUMBER function is more consistent:

  • If the source row information is available, it is returned.
  • If it is not available:
    • The function can still be used.
    • The function returns null values in all cases.

For more information, see SOURCEROWNUMBER Function.

New Functions

Function NameDescription
UNIQUE FunctionGenerates a new column containing an array of the unique values from a source column.

Key Bug Fixes

None.

New Known Issues

None.

May 29, 2018 Update

In this release Trifacta Wrangler has been enhanced with account monitoring capabilities, so you are alerted when you are approaching data usage and job execution limits. As needed, you can remove objects from the platform to reduce your current usage. Read below for details.

What's New

Account Management:

  • Review your storage and download volumes for the current month. See Data Usage Page.

Transformer Page:

  • Improved join inference key model. See Join Panel.

Publishing:

Changes to System Behavior

None.

Key Bug Fixes

TicketDescription
TD-31626Adding join keys does not refresh join preview pane.
TD-31264Patterns not available for Datetime columns

New Known Issues

TicketComponentDescription
TD-31343Connectivity

Upload of XSLX appears to fail.

Tip: XLSX file upload is currently slow. Please be patient with the upload process. This area is targeted for improvements in a future release.

April 2, 2018 Update

Welcome to the inaugural release of the cloud version Trifacta® Wrangler! This release represents the migration of the prior version of Wrangler for the desktop to the cloud, where you can take advantage of more storage and faster processing.

NOTE: As of this release, the desktop version of Trifacta Wrangler is no longer updated. You can continue to use the product for a period of time. However, at some point in the future, this product will be terminated and no longer accessible.

At this time, you should migrate to using the cloud version of Trifacta Wrangler. This new product contains the latest features from Trifacta and will be the supported version going forward.

 

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 7 rates

This page has no comments.