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