Less Than

Logic Name

Less Than

Function

Determines whether the upper input number is less than the input number below.

Data Types

Location Type
The first input handler Numeric
The second input handler Numeric
Logic output Boolean
lightbulbRefer to "Logic Specifications" for details.

Properties

Category Property Description
Null processing Null option Specify how to handle the input if it contains null.
Comment Comment The comment will also be output to the specifications.It does not affect the conversion process.

Null option

Option Description
Return false when unable to determine/calculate/process Continues with the process when unable to determine/calculate/process without throwing exception.
Convert null into 0 Converts null to 0 and continue with the process.
Throw exception when unable to determine/calculate/process Throws exception (CalculationException) when unable to determine/calculate/process.
Output null if any input is null Outputs null if the value of any input handler is null.
lightbulbRefer to "Logic Specifications" for details.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

Return "true" if the value of "column [1]" is less than the value of "column [2]". Otherwise return "false".
Property Settings
Property Setting
Null option Return false when unable to determine/calculate/process
Input Data
99,100
100,100
101,100
Result Data
true
false
false