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.

Table of Contents

Quick Start

Let us start with the following sample data:

Table 25 Marks → View 1

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:

Table 26 Marks → View 1

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.

See also

Number Formatting

The numeric formatter documentation

Result Column

The result column documentation