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 of any type |
| Column containing unique values |
Outputs
Outputs column of values corresponding to the last value within partitioned groups
Example
Last updated