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.

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

Snowflake	Delta Lake on Databricks	Amazon Redshift	Google BigQuery	Azure Synapse Analytics
✅	✅	✅	✅	✅