Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Trifacta Ranked #1 in Data Preparation Market Study

Dresner Advisory Services study reviews and ranks 24 vendors

Get the Report
Schedule a Demo

December ’19 Wrangler Release – Rapid Target Fuzzy Match, UI Improvements, Downloadable Profiles

December 18, 2019

The December ‘19 Wrangler release brings several new and exciting features to Trifacta’s free product. These features include:

  • Improved Fuzzy Matching on Rapid Target
  • Improved Date Time Interface
  • Downloadable Profiles
  • New Statistical Functions

Let’s take a look at each of these new features. 

Improved Fuzzy Matching on Rapid Target

Rapid Target allows you to insert a table or dataset as a target schema for your work. Say for instance you have a dashboard that has a specific order of columns, set of column names, and number of columns that you have to match in order to make use of that dashboard with different or new data. Rapid Target allows you to insert a dataset used for that dashboard, and helps guide you in transforming your data to that schema. With the December ‘19 release of Trifacta, we have added new fuzzy matching algorithms that improves this functionality to auto-align columns to the target columns they need to match.

Improved Date/Time Interface

We have streamlined various menus in Trifacta over the last year, most notably is the date/time data type menu. The old interface has been replaced by a navigable, searchable menu. This new menu makes it far easier to find the exact date/time format you are looking for. 

Downloadable Profiles

Lastly, we now have downloadable profiles from the job results. This has been a much requested feature from our community. Now, after completing a job, you can download a .json of the profile results, and use that for tracking purposes.

You can even wrangle these in Trifacta 🙂

New Statistical Functions

There are several new statistical functions in the December release of Wrangler, including:

 

Function Name Description
CORREL Function Computes the correlation coefficient between two columns. Source values can be of Integer or Decimal type.
COVAR Function Computes the covariance between two columns using the population method. Source values can be of Integer or Decimal type.
COVARSAMP Function Computes the covariance between two columns using the sample method. Source values can be of Integer or Decimal type.
PERCENTILE Function Computes a specified percentile across all row values in a column or group. Input column can be of Integer or Decimal.
QUARTILE Function Computes a specified quartile across all row values in a column or group. Input column can be of Integer or Decimal.

 

These functions can be used as single and multi-row formulas, group bys, pivots, window functions and more. 

That’s it for the December ‘19 release of Trifacta Wrangler. If you are interested in trying these new features for yourself, sign up for free today!

Related Posts

See What’s New in Wrangler Pro & Enterprise

This past Friday we cut a new release for Wrangler Pro & Enterprise customers so I wanted to walk through... more

  |  April 9, 2018

How Data Engineers Have Helped Data Prep Grow Up

In recent years, a new term in data has cropped up more and more frequently: DataOps. As an adaptation of the... more

  |  November 14, 2018

May ‘19 Release – Join Improvements and Ranking Functions

Trifacta’s May ‘19 Wrangler and Wrangler Pro release brings additional improvements to the Join... more

  |  May 15, 2019