First-Last
The First/Last component allows users to 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.
- Snowflake First Value.
- Snowflake Last Value.
- Redshift First Value and Last Value.
- BigQuery First Value.
- BigQuery Last Value.
Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
---|---|---|---|---|
✅ | ❌ | ✅ | ✅ | ✅ |