Page tree

Trifacta Dataprep



Contents:

If you licensed Dataprep by Trifacta before Oct. 14, 2020, you are using the Dataprep by Trifacta Legacy product edition. On October 14, 2022, this product edition will be decommissioned by Google and will be no longer available for use. Current customers of this product edition are encouraged to transition to one of the product editions hosted by Trifacta. See Product Editions.

   

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.

 

This page has no comments.