Page tree

 

Support | BlogContact Us | 844.332.2821

 

Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

Window functions apply to a subset of rows (a window) relative to the current row for computational purposes. These functions can be applied to the following transforms:

Primary Key:

When window functions are used, each row in the windowed output should be identified by a primary key. This primary key, which identifies unique rows, can be specified in one of the following ways:

  • The Order by field indicates unique row identifiers. This field can contain one or more column references.  
  • A combination of Order by andGroup by fields can create a unique identifier for each row.

This primary key requirement applies to window functions used with any supported transform. 

NOTE: Null values are ignored as inputs to these functions.

Topics:

 

Your Rating: Results: PatheticBadOKGoodOutstanding! 4 rates

This page has no comments.