Start Wrangling

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

May ‘19 Release – Join Improvements and Ranking Functions

May 15, 2019

Trifacta’s May ‘19 Wrangler and Wrangler Pro release brings additional improvements to the Join interface, as well as the addition of the RANK and DENSERANK functions. Both of these improvements come from feedback from our customers and community and we are excited to make them available first to our Wrangler and Wrangler Pro products.

What’s new:

  • Join Improvements
  • RANK and DENSERANK functions

Join Improvements

With the new release of Trifacta, you are now able to select the dataset or recipe to join from a view of the Flow. This makes organization in more complicated flows much easier.

RANK and DENSERANK

Rank and DENSERANK now allow you to rank numeric columns in a single step. RANK Computes the rank of a numeric column. Tie values are assigned the same rank, and the next ranking is incremented by the number of tie values. DENSERANK operates the same when ranking values, however, the next ranking value after a tie is incremented by one.

Examples:

          Value                 RANK            DENSERANK 

3

1 1

6

2 2

6

2 2

9

4

3

12 5

4

12 5

4

15 7

5

To try out the new Join improvements, ranking functions and all of the other great features available in our free Wrangler edition, sign up here.

 

Related Posts

Google Launches Public Beta of Cloud Dataprep, Built in Collaboration With Trifacta

Google recently announced that Google Cloud Dataprep—the new managed data wrangling service developed in... more

  |  September 21, 2017

Data Preparation with Trifacta for
Amazon SageMaker

In a recent blog covering the usage of Amazon SageMaker’s unique modeling algorithms such as DeepAR to... more

  |  October 15, 2018

A Preview of GA Features for Google Cloud Dataprep by Trifacta

Following the exciting news from Google Next 2018 about the upcoming general availability of Google Cloud... more

  |  August 1, 2018