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.
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.
Comparing “134123412341” and “2". Minimum() outputs “134123412341” because “1" is lower than “2”.
Minimum() compares number field values (Long and Double) for the lowest number.
Comparing 134123412341 and 2. Minimum() outputs 2 because 2 is lower than 134123412341.
Minimum() compares date field values and outputs the earliest date.
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.
- 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.
|Argument value one||Argument value 2||Minimum() returns|
|2022-01-06 02:30:00.000||2022-01-05 02:30:00.000||2022-01-05 02:30:00.000|