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:

Recipe development:

Update Macros:

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:

Photon:

Introducing , an in-memory running environment for running jobs. Embedded in the , is fast and best-suited for small- to medium-sized jobs.

Sampling:

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

November 18, 2020

Release 7.9

What's New

Flow View:

Transform Builder:

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:

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:

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

In this release, experimental versions of the following have been deployed to some users of the product:

  • First-time on-boarding: New and improved product walkthrough!
  • Getting started workflow: Shorter and faster method for getting started wrangling data. Example datasets are available for use!


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.

July 20, 2020

Release 7.5

What's New

New Flow View is now generally available:

Transformer Page:

Language:

Changes in System Behavior

Enhanced PII masking:

Key Fixes

None.

New Known Issues

None.

June 22, 2020

Release 7.4

What's New

Language:

Key Bug Fixes

None.

New Known Issues

None.

June 4, 2020

Release 7.3

What's New

Language:

New rolling window date functions. 

Function NameDescription
ROLLINGMAXDATE Function

ROLLINGMINDATE Function

ROLLINGMODEDATE Function

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-49559Cannot select and apply custom data types through column Type menu.
TD-47473Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted.
TD-34840Platform fails to provide suggestions for transformations when selecting keys from an object with many of them.


New Known Issues

None.

May 18, 2020

Release 7.2

What's New

Introducing new Flow View:

The Flow View page has been redesigned to improve the user experience and overall productivity. 

Language:

Function NameDescription
KTHLARGESTDATE Function

KTHLARGESTUNIQUEDATE Function

KTHLARGESTDATEIF Function

KTHLARGESTUNIQUEDATEIF Function

MINDATEIF Function

MAXDATEIF Function

MODEDATEIF Function

Changes in System Behavior

None.

Key Fixes

TicketDescription
TD-47473Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted.
TD-38480Platform fails to provide suggestions for transformations when selecting keys from an object with many of them.

New Known Issues

None.

April 15, 2020

Release 7.1

What's New

Transformation:

Language:

Some functions now accept Datetime values: Beginning in this release, the following functions now accept Datetime values as inputs. When a Datetime value is input, output values are in unixtime format.

Tip: You can wrap the unixtime format output in the DATEFORMAT function to render the results in the preferred Datetime format. See DATEFORMAT Function.

Date calculation functions:

Function NameDescription
MINDATE Function

MAXDATE Function

MODEDATE Function

Work day functions:

Function NameDescription
NETWORKDAYS Function

NETWORKDAYSINTL Function

WORKDAY Function

WORKDAYINTL Function

Time zone conversion functions:

Function NameDescription
CONVERTFROMUTC Function

CONVERTTOUTC Function

CONVERTTIMEZONE Function

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-47473

Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted.

Workaround: Remove the space in the filename and upload again.


March 17, 2020

Release 7.0

Numerous bug fixes and performance improvements.

What's New

Transformer Page:

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-47473

Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted.

Workaround: Remove the space in the filename and upload again.


February 19, 2020

Release 6.11

This release introduces in-app chat and content suggestions within the application. Give it a try!

What's New

In-app chat: 

Have a question about the product? Use the new in-app chat feature to explore content or ask a question to our support staff. If you need assistance, please reach out!

Language:

Changes in System Behavior

None.

Key Fixes

None.

New Known Issues

None.

January 23, 2020

Release 6.10

This release delivers enhancements to job monitoring, visual profiles that are downloadable in PDF format, and a useful feature to kickoff any support inquiries.

What's New

Troubleshooting:

Job Details:

Documentation:

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

December 17, 2019

Release 6.9

This release introduces new statistical functions, including co-efficient and covariance calculations for enhanced analysis. A redesigned User menu facilitates easier management of user settings.

What's New

Transformer Page:

Workspace:

Language:

Changes in System Behavior

Language:

All MODE functions return the lowest value in a set of values if there is a tie in the evaluation.

In prior releases, these functions returned a null value in the event of a tie for most common value among the evaluated ones.

Key Bug Fixes

None.

New Known Issues

None.

November 13, 2019

Release 6.8

This release features enhancements to the user experience in the workspace, in the form of keyboard shortcuts and user-specific locale settings, and other useful features and improvements. Read on!

What's New

Workspace:

Transformer Page:

Job execution:

Language:

This release introduces the sampling method of calculating statistical functions. The following are now available:

Function NameDescription
STDEVSAMP Function

VARSAMP Function

STDEVSAMPIF Function

VARSAMPIF Function

ROLLINGSTDEVSAMP Function

ROLLINGVARSAMP Function

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-44548RANGE function returns null values if more than 1000 values in output.

New Known Issues

None.

October 9, 2019

Release 6.7

What's New

Browser:

Project Management:

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

September 11, 2019

Release 6.6

This release introduces new functions to the language and improvements in search for transformations.

What's New

Transformer Page:

Language:

Function NameDescription
SINH Function

COSH Function

TANH Function

ASINH Function

ACOSH Function

ATANH Function


Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

August 14, 2019

Release 6.5

This release introduces new functions and fixes a number off issues.

What's New

Language:

Function NameDescription
SIN Function

COS Function

TAN Function

Cotangent FunctionSee TAN Function.
Secant FunctionSee COS Function.
Cosecant FunctionSee SIN Function.
ASIN Function

ACOS Function

ATAN Function

Arccotangent FunctionSee ATAN Function.
Arcsecant FunctionSee ACOS Function.
Arccosecant FunctionSee ASIN Function.

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

July 18, 2019

Release 6.4

This release introduces macros, which enable flexible reuse of common sequences of recipe steps.

What's New

Reuse:

Connectivity:

Transformation:

Wrangle:

Changes in System Behavior

NOTE: The desktop version of Trifacta Wrangler will cease operations on August 31, 2019. If you are still using the product at that time, your data will be lost. Please transition to using the free Cloud version of . Automated migration is not available. To register for a free account, please visit https://cloud.trifacta.com.

NOTE: The Chat with us feature is no longer available. For customers, this feature had to be enabled in the product. For more information, see .


Documentation:

Key Bug Fixes

TicketDescription
TD-40424

UTF-32BE and UTF-32LE are available as supported file encoding options. They do not work.

NOTE: Although these options are available in the application, they have never been supported in the underlying platform. They have been removed from the interface.


New Known Issues

None.

June 17, 2019

Release 6.3

This release features a brand-new way to develop transformations via example. Map source column values to your entered values, and the platform can infer similar pattern-based matches in your column of data. Also, multi-step operations are now available in the Recipe panel. For administrators: you can now review the list of all available schedules in the workspace.  

What's New

Transform:

Language:

Changes to System Behavior

NOTE: The Chat with us feature is no longer available. For more information, see .

Key Bug Fixes

None.

New Known Issues

None.

May 15, 2019

Release 6.2

This release includes new functions and a new method for locating datasets and recipes to join in.

What's New

Transformer Page:

Language:

Connectivity:

Changes to System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

April 10, 2019

Release 6.1

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

Release 6.0

This release of  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 are on Google Chrome 68+. For more information, see Desktop Requirements.

Wrangling:

Monitoring:

:

Changes to System Behavior

$filepath disabled

In a prior release, the $filepath reference was enabled in . 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:

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

Jobs:

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

 

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:

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:

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:

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:

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

Transformer Page:

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 ! 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 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 . This new product contains the latest features from  and will be the supported version going forward.