Mapper Logic

Mapper Logic (hereinafter: the logic) is a function that can perform various conversion/processing such as arithmetic operation and character replacement.

Usage of Mapper Logic
Mapper Logic Specifications
Specification Limits
Notes

Usage of Mapper Logic

Using logic
To connect mapping link
Logic Settings
To move logic
Right-click menu

Using logic

When using logic, drag and drop logic icon from the Tool Palette to the Mapping Canvas.

Example: The process of adding number "1.05" to the input data and inputting the result is as follows.

To connect mapping link

The method to connect links to input handler of logic differs depending on the type of input handlers.
The output of logic is connected by link with other logic or element of output schema.

Link to the input handler

If logic has no input handler
Mapping link cannot be connected.

Case of 1 input handler
It can be connected to the element of input schema or other logic.
- Element of input schema
- Other logic
Case of 2 input handlers
It can be connected to the combination of elements of input schema and other logic.
- Combination of elements of input schema
- Element of input schema and other logic

Refer to the help of each logic for the function of each logic and information of input handlers.

Logic Settings

Properties of each logic can be set from Property setting dialog or Property inspector.

To move logic

Logic placed in mapping canvas can be moved by drag-and-drop of icon.
Mapping links are also moved when logic is mapped.

Right-click menu

Logic placed in mapping canvas can be processed as follows with the right-click menu.

The same process can be executed with menu of the Designer.

Explanation of item

Item name	Description	Remarks
Cut	Cuts the logic icon.
Copy	Copies the logic icon.
Delete	Deletes the logic icon.
Alignment	Arrange the placement of the logic icons. Align left Align right Align top Align bottom Align horizontally Align vertically	Can only be executed when multiple icons are selected. [Align horizontally] and [Align vertically] can only be executed when 3 or more icons are selected.
Paste	Pastes the cut/copied logic icon.
Properties	Open the Properties setting dialog of the logic.	Can only be executed when one single icon is selected.
Help	Open the help of logic.

Logic Type

Logic are roughly divided into two types: "Loop" and "Convert".
Type can be determined from the chip at the upper left of the icon.

Logic Type	Chip Image	Palette tab name
Loop logic		Loop
Convert logic		Branch Condition Numeric String Date Excel

Typically, each data divided with Loop logic are processed with Convert logic then output in order.

The type of each input/output handler of Convert logic is determined.
The type of input handler means the type of data converted during the input, while the type of output handler means the type of result data after the conversion/processing.

Typically, when the type of input data is different from that of input handler, the input data type is automatically cast to the type of input handler.
When cast(conversion) of type fails, run-time error occurs.

To avoid script stopping as the result of run-time error, check the data beforehand or enclose the Mapper components with Monitor Exception.

Type of Convert Logic

Logic palette is classified by type, and the type can be determined with the chip at the lower right of the icon.

Logic Type	Internal Data Type	Chip Image
Boolean	boolean	Condition
Numeric	BigDecimal	Numeric
String	String	String
Date	Date	Date

Internal data type of Numeric logic

Numeric type handled with Mapper is processed in BigDecimal type, which can accurately represent the data including decimal point.
When numeric operation is executed to string type, the string is converted to BigDecimal type.
In case of rounding off numbers after the decimal point, use string logic "Number Formatting".

Format when each type is converted to String

Format of data types of logic or script variable mapped to strings are as follows.

Type	Format of string
Date type	"yyyy-MM-dd'T'HH:mm:ss.SSSZZ"
Binary type	BASE64 Encoding
Numeric type / integer type / decimal type	Real number style
Boolean type	"True" or "false"

About the format of date, refer to "Format of date/time formatting".

When null is input

Null indicating no value existing may be input to adapter like database.
Null input to convert logic is processed as follows.

Logic with null option: null is processed based on the specified option.

Logic without null option: outputs null and continues with the process.

When null is output to adapters that cannot express null, null is converted to appropriate representation.
If the input schema is table model type and the output schema is XML, the null value of the input data which is mapped to the output data is treated as null even in the middle of the Mapper logic.

Refer to "Null option" for logic with null option.

Specification Limits

Common to all mappers

You are not allowed to Paste logic icons to different Mapper editors.

The following characters cannot be used in input fields of Mapper logic (except for [Comment] field)
- "<" "&"
When the characters above are used in input fields of Mapper logic, error occurs in execution.
In that case, open Mapper editor and save the script.

Fields in which regular expression pattern can be input(such as "Regular expression replacement","Match to regular expression" logic), characters can be represented in Unicode notation.
- "<" → "\u003C"
- "&" → "\u0026"

Notes

Common to all mappers

The precision(precision after the decimal point) used by default in arithmetic operation logic is as follows.
- Use the higher precision of the input handlers for Add/Subtract/Modulo logic.
  Example: 189000+1.05=189001.05
- Use the sum of the precision of the input handlers for Multiply logic.
  Example: 189000.05*1.05=198450.0525
- Use the precision of the first input handler for Divide logic.
  Example: 189000.5÷0.05=3780010.0

In the following logic converting date, the when non-existing data/time is input or resulted from the operation, it is automatically corrected to the present date/time(for example: 2005/04/31 → 2005/05/01).