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

Product

May ‘19 Release – Join Improvements and Ranking Functions

< Back to Blog
 
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.