Skip to content

First Last

The First/Last component lets you create groups of data and then return only the first or last rows from the group.

Properties

Name = string

A human-readable name for the component.

Grouping Columns = dual listbox

Defines how the input data is grouped. This works like an SQL "group by" statement. The first or last element of each group will be selected.

Ordering within partitions = column editor

  • Input Column: The input column name for sorting within the grouped data. You can drag to reorder.
  • Ordering: The order of the sorting: Ascending (Asc) or Descending (Desc).

First/Last Columns = column editor

  • Column: The name of the input column to be passed to the output.
  • First/Last: Return the First or Last element of the chosen column in the grouped data.

Ignore Nulls = drop-down

Select whether to ignore null values. The default setting is No.

Strategy

Generates a select statement with a window function in-line using the OVER keyword.

Cloud Data Platform Documentation
Snowflake First value, Last value
Delta Lake on Databricks First value, Last value
Amazon Redshift First and last value
Google BigQuery First value, Last value
Azure Synapse Analytics First value, Last value
Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics
✅ ✅ ✅ ✅ ✅