Obtain Large or Small Values

The Obtain Small or Large Value task has the following two sub-tasks:

1. The small function fetches numeric values based on their position in a list ranked by value. In other words, it can retrieve "nth smallest" values - smallest value, 2nd smallest value, 3rd smallest value, and so on.
2. The large function fetches numeric values based on their position in a list reverse ranked by value. In other words, it can retrieve "nth largest" values - largest value, 2nd largest value, 3rd largest value, and so on.

Quickstart

Let us start with the following sample data:

Student	Science	Civics	Arts	Language
Alice	80	50	60	40
Bob	40	60	80	90

Let us suppose you want to know what were the highest marks achieved by the students in any of the subjects. Complete the following steps to achieve this:

1. Go to Transform > Numeric Functions.
2. Select the Obtain Large or Small Values function.
3. Select all the columns.
4. Change the smallest to largest.
5. Enter the name Highest into the new column name.
6. Click APPLY.

The data appears as shown below:

Student	Science	Civics	Arts	Language	Highest
Alice	80	50	60	40	80
Bob	40	60	80	90	90

Supported Options

The following options are supported.

1. Column List: The list of numeric columns to compare.
2. Control Value: The numeric value used as a threshold. This is enabled when at least one column is enabled.
3. N: the index of value to extract from the list. First, second and so on.
4. Small or Large: The nature of the value to extract from the list.

info

• Number Formatting
• Result Column