tail function

The tail function returns the last n letters of the corresponding value in the column.


Parameters

tail(column, nchar)

If you are using continuous attributes, check the Flow Execution Parameters.

Parameter

Description

column

The nominal attribute containing the strings. If it is not nominal, it will be casted to nominal upon function’s computation. The column parameter is mandatory.

nchar

Number of characters we want to select at the end of the string. It can be either a specified value or an integer attribute. The nchar parameter is mandatory.


Example

The following example uses the Bike sales dataset.

Description

Screenshot

In this example, we want to retrieve the tail of the values of the Year attribute.

Select the Year attribute and type the following formula:

tail($"Year",2)

As Year is an integer attribute, the function casted it to nominal.