Functions.Last Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Overloads
| Last(Column, Boolean) |
Returns the last value of a column in a group. |
| Last(String, Boolean) |
Returns the last value of a column in a group. |
Last(Column, Boolean)
Returns the last value of a column in a group.
public static Microsoft.Spark.Sql.Column Last (Microsoft.Spark.Sql.Column column, bool ignoreNulls = false);static member Last : Microsoft.Spark.Sql.Column * bool -> Microsoft.Spark.Sql.ColumnPublic Shared Function Last (column As Column, Optional ignoreNulls As Boolean = false) As ColumnParameters
- column
- Column
Column to apply
- ignoreNulls
- Boolean
To ignore null or not
Returns
Column object
Remarks
The function by default returns the last values it sees. It will return the last non-null value it sees when ignoreNulls is set to true. If all values are null, then null is returned.
Applies to
Last(String, Boolean)
Returns the last value of a column in a group.
public static Microsoft.Spark.Sql.Column Last (string columnName, bool ignoreNulls = false);static member Last : string * bool -> Microsoft.Spark.Sql.ColumnPublic Shared Function Last (columnName As String, Optional ignoreNulls As Boolean = false) As ColumnParameters
- columnName
- String
Column name
- ignoreNulls
- Boolean
To ignore null or not
Returns
Column object
Remarks
The function by default returns the last values it sees. It will return the last non-null value it sees when ignoreNulls is set to true. If all values are null, then null is returned.