Mapper Logic Guide

Merge

Basic

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Or-Append Merge Or-Append Merge

check

Or-Integrate Merge Or-Integrate Merge

check

And-Append Merge And-Append Merge

check

And-Integrate Merge And-Integrate Merge

check

Left-Right-Join Merge Left-Right-Join Merge

check

Loop

Basic

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Iterate specified node Iterate specified node

check check

Sort by Key Sort by Key

check

Sort by Two Keys Sort by Two Keys

check

Grouping Grouping

check

Conditional loop

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

If Loop If Loop

check check

Branch

Basic

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

If If

check check check check

Switch Switch

check check check check

Condition

Boolean

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

And And

check check check

Or Or

check check check

Not Not

check check check

Boolean Constant Boolean Constant

check check check

To Boolean To Boolean

check check check

Check Null Check Null

check check check

Number

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Equal Equal

check check check

Not Equal Not Equal

check check check

Less Than Less Than

check check check

Not More Than Not More Than

check check check

More Than More Than

check check check

Not Less Than Not Less Than

check check check

String

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Identical Identical

check check check

Different Different

check check check

Start with Start with

check check check

End with End with

check check check

Contain Contain

check check check

Match to Regular Expression Match to Regular Expression

check check check

Date

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Equal Date/Time Equal Date/Time

check check check

Before Before

check check check

After After

check check check

Date/Time Exists Date/Time Exists

check check check

Number

Basic

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Numeric Constant Numeric Constant

check check check check

To Number To Number

check check check check

Input Node Number Input Node Number

check check

Output Node Number Output Node Number

check check

Calculation

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Add Add

check check check check

Subtract Subtract

check check check check

Multiply Multiply

check check check check

Divide Divide

check check check check

Modulo Modulo

check check check check

Function

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Ceiling Ceiling

check check check check

Floor Floor

check check check check

Rounding Rounding

check check check check

Absolute Value Absolute Value

check check check check

Square Root Value Square Root Value

check check check check

The Larger The Larger

check check check check

The Smaller The Smaller

check check check check

Sign Sign

check check check check

String Length String Length

check check check check

Number of Bytes Number of Bytes

check check check check

Set

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Sum Sum

check

Average Average

check

Number of Node Number of Node

check

Maximum Node Maximum Node

check

Minimum Node Minimum Node

check

Date

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Get Year Get Year

check check check check

Get Month Get Month

check check check check

Get Day Get Day

check check check check

Get Hour Get Hour

check check check check

Get Minute Get Minute

check check check check

Get Second Get Second

check check check check

Get Day of the Week Get Day of the Week

check check check check

Get Number of Days Get Number of Days

check check check check

Period

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Calculate Period by Year Calculate Period by Year

check check check check

Calculate Period by Month Calculate Period by Month

check check check check

Calculate Period by Day Calculate Period by Day

check check check check

Calculate Period by Hour Calculate Period by Hour

check check check check

Calculate Period by Minute Calculate Period by Minute

check check check check

Calculate Period by Second Calculate Period by Second

check check check check

Conversion

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Replace Null/Empty String Replace Null/Empty String

check check check check

Japan

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Convert Chinese Numeral to Numeric Convert Chinese Numeral to Numeric

check check check check

Calculate Age Calculate Age

check check check check

String

Basic

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Single-line String Constant Single-line String Constant

check check check check

Multi-line String Constant Multi-line String Constant

check check check check

Unique string Unique string

check check check check

Execution ID Execution ID

check check check check

Execution Environment ID Execution Environment ID

check check check check

Execution User Execution User

check check check check

Execution Project Name Execution Project Name

check check check check

Execution Script Name Execution Script Name

check check check check

Execution Type Execution Profile

check check check check

Execution Job Name Execution Job Name

check check check check

Execution Job Type Execution Job Type

check check check check

System Property System Property

check check check check

Get Cell Value Get Cell Value

check

Get Value by XPath Get Value by XPath

check check check

To String To String

check check check check

Calculation

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Concatenate Concatenate

check check check check

Function

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Left String Left String check check check check
Right String Right String check check check check
Middle String (property) Middle String (property) check check check check
Middle String (input handler) Middle String (input handler) check check check check
Repeat String (input handler) Repeat String (input handler) check check check check
String After Specified Position String After Specified Position check check check check
After Specified Character After Specified Character check check check check
Before Specified Character Before Specified Character check check check check
Left String (bytes) Left String (bytes) check check check check
Retrieve data by executing SQL Retrieve data by executing SQL check check check check

Conversion

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Replace Each String Replace Each String

check check check check

Replace by CSV Table Replace by CSV Table

check check check check

Replace by DB Table Replace by DB Table

check check check check

Replace by Regular Expression Replace by Regular Expression

check check check check

Lowercase Lowercase

check check check check

Uppercase Uppercase

check check check check

Replace Each Character Replace Each Character

check check check check

Replace Null Replace Null

check check check check

Replace Null/Empty String Replace Null/Empty String

check check check check

Convert Numeral System Convert Numeral System

check check check check

Trim

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Trim Both Sides Trim Both Sides

check check check check

Trim Left Trim Left

check check check check

Trim Right Trim Right

check check check check

Number

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Format Number Format Number

check check check check

Date

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Date/Time Formatting Date/Time Formatting

check check check check

Security

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Encrypt Encrypt

check check check check

Decrypt Decrypt

check check check check

Japan

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Hiragana to Katakana Hiragana to Katakana

check check check check

Katakana to Hiragana Katakana to Hiragana

check check check check

Hiragana to Roman Alphabet Hiragana to Roman Alphabet

check check check check

Double-byte to Single-byte Double-byte to Single-byte

check check check check

Single-byte to Double-byte Single-byte to Double-byte

check check check check

Convert to Chinese Numeral Convert to Chinese Numeral

check check check check

Convert to Japanese Calendar Convert to Japanese Calendar

check check check check

Date

Basic

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Current Date/Time Current Date/Time

check check check check

Date/Time Constant Date/Time Constant

check check check check

Parse Date/Time Parse Date/Time

check check check check

Set

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Set Year Set Year

check check check check

Set Month Set Month

check check check check

Set Day Set Day

check check check check

Set Hour Set Hour

check check check check

Set Minute Set Minute

check check check check

Set Second Set Second

check check check check

Calculation

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Calculate Year Calculate Year

check check check check

Calculate Month Calculate Month

check check check check

Calculate Day Calculate Day

check check check check

Calculate Hour Calculate Hour

check check check check

Calculate Minute Calculate Minute

check check check check

Calculate Second Calculate Second

check check check check

Japan

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Parse Japanese Calendar Parse Japanese Calendar

check check check check

Excel

Basic

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Generate Excel Format Generate Excel Format

check check check

Other

Basic

Logic name

Document Mapper

Variable Mapper

Merge Mapper

PSP

Null Value Null Value check check check
Replace Empty String Replace Empty String check check check check
Copy Input Element Copy Input Element check
Output by XPath Expression Output by XPath Expression check