See How Data Engineering Gets Done on Our Do-It-Yourself Data Webcast Series

Start Free

Speed up your data preparation with Trifacta

Free Sign Up
Summer of SQL

A Q&A Series with Joe Hellerstein

See why SQL is Back
 
All Blog Posts

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

11

6

22

6

22

9

4

3

125

4

125

4

157

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.