Types of Mapper logic

Mapper logic is a function that can perform basic arithmetic, character substitution, and other various conversion and processing operations on values.

The types of Mapper logic are Loop, Condition, Number, Date, String, and Array.

= Remarks =
  • Mapper icon

    When you place a Mapper logic on the mapping canvas of the Mapper editor, a connecting line appears to the left of the icon. This line is called an "input handler."

    Example:

    Sample Mapper icon

    The upper connecting line is the "first input handler," and the lower connecting line is the "second input handler."

    You can define the input data by connecting input schema elements, variables, or other Mapper logic to this connecting line.

    For some logics, you can increase the number of connecting lines when you change the properties.

     

    For details about how to use Mapper logic, refer to How to use Mapper logic.

Loop

Conditional loop

Icon

Logic Name

Function

If Loop

 If Loop

This logic loops and outputs the items that match the conditions.

Condition

Boolean

Icon

Logic Name

Function

And operation

 And operation

This logic returns the logical conjunction (AND condition) of two input booleans.

Or operation

 Or operation

This logic returns the logical disjunction (OR condition) between two input booleans.

Not operation

 Not operation

This logic returns the negation (NOT condition) between two input booleans.

Boolean Constant

 Boolean constant

This logic outputs the boolean constant.

Check null

 Check null

This logic determines whether the input value is null.

Number

Icon

Logic Name

Function

Equal

 Equal

This logic determines whether two input numbers are equal.

Not equal

 Not equal

This logic determines whether two input numbers differ.

Less than

 Less than

This logic determines whether the input value of the first input handler is smaller than the input value of the second input handler.

Less than or equal

 Less than or equal

This logic determines whether the input value of the first input handler is equal to or lower than the input value of the second input handler.

Greater than

 Greater than

This logic determines whether the input value of the first input handler is larger than the input value of the second input handler.

Greater than or equal

 Greater than or equal

This logic determines whether the input value of the first input handler is equal to or higher than the input value of the second input handler.

String

Icon

Logic Name

Function

Equal

 Equal

This logic determines whether two input strings are equal.

Not equal

 Not equal

This logic determines whether two input strings differ.

Start with

 Start with

This logic determines whether the input string starts with the specified string.

End with

 End with

This logic determines whether the input string ends with the specified string.

Contain

 Contain

This logic determines whether the input string contains the specified string.

Match to regular expression

 Match to regular expression

This logic determines whether the input string matches the specified regular expression.

Number

Basic

Icon

Logic Name

Function

Numeric constant (integer)

 Numeric constant (integer)

This logic outputs the numeric constant (integer).

Numeric constant (floating point)

 Numeric constant (floating point)

This logic outputs the numeric constant (floating point).

To Integer

 To Integer

This logic converts the input values into integers.

Convert to floating point

 Convert to floating point

This logic converts the input values into floating point values.

Increment

 Increment

This logic outputs the value incremented from 0.

Calculation

Icon

Logic Name

Function

Add

 Add

This logic adds the input value of the second input handler to the input value of the first input handler and returns the result.

Subtract

 Subtract

This logic subtracts the input value of the second input handler from the input value of the first input handler and returns the result.

Multiply

 Multiply

This logic multiplies the input value of the first input handler by the input value of the second input handler and returns the result.

Divide

 Divide

This logic divides the input value of the first input handler by the input value of the second input handler and returns the result.

Remainder

 Remainder

This logic divides the input value of the first input handler by the input value of the second input handler and returns the remainder.

Function

Icon

Logic Name

Function

Ceiling

 Ceiling

This logic rounds up the input numerical value to the nearest integer.

Floor

 Floor

This logic rounds down to the nearest integer of the input numerical value. If the input numerical value is a negative value, the output numerical value is the largest value less than or equal to the input numerical value.

Floor (precision)

 Floor (precision)

This logic rounds the input numeric value down according to the specified precision. If the input numerical value is a negative value, the output numerical value is the largest value less than or equal to the specified number of digits.

Fraction processing

 Fraction processing

This logic rounds down to the fractional point of the input value. If the input numerical value is a negative value, this logic rounds down to the nearest integer.

Rounding

 Rounding

This logic rounds the input numeric value.

Rounding (precision)

 Rounding (precision)

This logic rounds the input numeric value according to the specified precision.

Absolute value

 Absolute value

This logic returns the absolute value of the input numerical value.

Power

 Power

This logic raises the input numerical value to the power of the specified value.

Bit length

 Bit length

This logic returns the bit length of the input character string.

String length

 String length

This logic returns number of characters of the input character string.

Date

Icon

Logic Name

Function

Get year

 Get year

This logic gets the year from the input date and time.

Get month

 Get month

This logic gets the month from the input date and time.

Get day

 Get day

This logic gets the day from the input date and time.

Get hour

 Get hour

This logic gets the hour from the input date and time.

Get minute

 Get minute

This logic gets the minutes from the input date and time.

Get second

 Get second

This logic gets the seconds from the input date and time.

Get day of the week

 Get day of the week

This logic gets the day of the week from the input date and time.

Set

Icon

Logic Name

Function

Average

 Average

This logic outputs the average of the array.

Date

Basic

Icon

Logic Name

Function

UNIX time

 UNIX time

This logic outputs the Unix time.

Current date/time (UTC)

 Current date/time (UTC)

This logic gets the current date and time based on Universal Time Coordinated (UTC).

Current date/time (time zone)

 Current date/time (OS time zone)

This logic gets the current date and time based on the time zone of the OS running Runtime.

Calculation

Icon

Logic Name

Function

Parse of date/time(Standard format)

 Parse of date/time(Standard format)

This logic outputs the input string as date and time according to the selected layout.

Parse of date/time(Custom)

 Parse of date/time(Custom)

This logic outputs the input string as date and time according to the specified layout.

Increases or decreases hour

 Increases or decreases hour

This logic increases or decreases the hour of the input date and time and returns the date and time value.

Increases or decreases minute

 Increases or decreases minute

This logic increases or decreases the minutes of the input date and time and returns the date and time value.

Increases or decreases second

 Increases or decreases second

This logic increases or decreases the seconds of the input date and time and returns the date and time value.

String

Basic

Icon

Logic Name

Function

String constant

 String constant

This logic outputs a single-line string constant.

Convert to string

 Convert to string

This logic converts the input values to character strings.

Calculation

Icon

Logic Name

Function

Concatenate

 Concatenate

This logic joins multiple input strings.

Zero padding

 Zero padding

This logic pads the input value with zeros up to the specified number of digits and outputs the result as a string.

Left String

 Left String

This logic returns the specified number of bytes of string from the left of the input string.

Right String

 Right String

This logic returns the specified number of bytes of string from the right of the input string.

Middle String

 Middle String

This logic returns the specified number of bytes of string from the specified start location of the input string.

Date

Icon

Logic Name

Function

Date/Time formatting(Standard format)

 Date/Time formatting(Standard format)

This logic formats the date and time to the selected format.

Date/Time formatting(Custom)

 Date/Time formatting(Custom)

This logic formats the date and time to the specified format.

Array

Basic

Icon

Logic Name

Function

Add

 Add

This logic adds all the specified elements to the array.

Add (maximum size adjustment)

 Add (maximum size adjustment)

This logic adds all the specified elements to the array. Values are deleted starting from the oldest value if the maximum size is exceeded.