Data School

Presenting The Data School, our online resource for people who work with data

Learn More
 
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.