LASTBY

Finds the last element within a column, partitioned by the unique values of a separate column

LASTBY(column, partition column)

Returns the last element within a column when grouped by unique values within a partition column

Arguments

Argument

Description

column

Column of any type

partition column

Column containing unique values

Outputs

Outputs column of values corresponding to the last value within partitioned groups

Example

Last updated