Minimum
Description
Returns the minimum element of the given collection, according to the natural ordering of its elements. All elements in the collection must implement a comparable interface. A new column is created for the results.
String values:
Minimum() is based on taking the first character in the string field values and turning it into a ASCII DEC value. The field value is lower is the output.
Example:
Comparing “134123412341” and “2". Minimum() outputs “134123412341” because “1" is lower than “2”.
Number values:
Minimum() compares number field values (Long and Double) for the lowest number.
Example:
Comparing 134123412341 and 2. Minimum() outputs 2 because 2 is lower than 134123412341.
Date values:
Minimum() compares date field values and outputs the earliest date.
Example:
Comparing: 2022-01-06 02:30:00.000 and 2022-01-05 02:30:00.000. Minimum() outputs 2022-01-05 02:30:00.000 as it is the earliest date.
Use
- Argument:
- Select an argument. (Number, String, Date)
- Add argument field: (Optional to add multiple fields)
- Select a additional arguments. (Number, String, Date)
- Output field name:
- Enter an output field name.
Example
| Argument value one | Argument value 2 | Minimum() returns |
|---|---|---|
| 2 | 8 | 2 |
| abc | ABC | ABC |
| 2022-01-06 02:30:00.000 | 2022-01-05 02:30:00.000 | 2022-01-05 02:30:00.000 |