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 10 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. Open Data Preparation menu and click on Numeric Functions
  2. Select Obtain Large or Small Values
  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 11 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