• DataSpider Servista Help
• DataSpider Servista Concept
  • DataSpider Servista
  • Composition of DataSpider Servista
  • DataSpider Filesystem directory structure
• Service Guide
  • Service Basics
    • Basic elements of service
    • User Management
    • Tutorial
  • Service Development
    • Preparation
    • Team development
    • Mass Data Correspondence
    • Development support functions
    • Other auxiliary components
    • Utilizing Global Schema
    • Loop log setting
    • Testing Script
    • Access Log
    • Selecting Service Execution Tool
    • Generating a Specification
    • Output Version Comparison Report
    • Detailed Topics
      • Keyboard Shortcuts
      • Script variables
      • Log Level
      • Exit status
      • Types
      • Parallel Stream Processing
      • Smart Compiler
      • Multi-thread Processing
      • Team Development
      • Testing Framework
  • Service Operation
    • Before operating the services
    • Server migration
    • Monitoring
    • In the event of failure
    • Maintenance
    • Logging Guide
    • Detailed Topics
      • Property Reference
      • HTTPS setting
      • Import of certificate
      • Generating SSH private key and public key
      • Message Code
        • Message Code List
        • FILE
        • IO
        • NETWORK
        • DB
        • TRANSACTION
        • DATA
        • SECURITY
        • MEMORY
        • EXTERNAL
        • SCRIPT
        • PSP
        • MAPPER
        • MERGE
        • USER
        • OTHER
      • Others
  • Troubleshooting
• Operation Tools
  • Trigger
    • Trigger
    • Schedule trigger
    • File trigger
    • HTTP trigger
    • DB trigger
    • FTP trigger
    • Web services trigger
    • Amazon Kinesis trigger
    • SAP Trigger
    • SAP BC Trigger
    • HULFT Script trigger
  • ScriptRunner
  • ScriptRunner for Amazon SQS
  • ScriptRunnerProxy
  • CLI Console
• Development Tools
  • DataSpider Studio
  • DataSpider Studio for Web
  • New project/Open project
  • My Projects
  • My Triggers
  • My Logs
  • My Services
  • Designer
  • Explorer
  • Control Panel
    • ScriptRunner for Amazon SQS Settings
    • DataSpider Log Settings
    • Application Log Output Settings
    • DataSpiderServer Settings
    • Task Manager
    • FTP Server Settings
    • Mount Settings
    • Version Information
    • Environment Variables Management
    • User Accounts
    • Holiday Settings
    • Global Resource Settings
    • Global Schema Settings
    • Repository DB Management
• Architecture
  • DataSpiderServer Architecture
  • XML Framework
  • DataSpider filesystem
    • Thunderbus Connector Settings
  • Data Types
  • Transaction
  • Global Resources
  • Global Schema
• Adapter
  • Basic
    • Processing
      • Assign Variables
      • Launch External Application
      • Call Script
      • Wait
      • Garbage Collection
      • Raise Exception
      • Output Log
      • Validate with XML Schema
      • Validate with DTD
      • Output Table Model Data Log
      • Output XML Data Log
      • Data Check
      • Get Data Check Error Details
    • Flow
      • Loop
      • Conditional Loop
      • Loop by Number of Data
      • Conditional Branch
      • Monitor Exception
      • Thread
      • Transaction
      • end
      • break
      • continue
    • Assertion
      • Compare Table Model
      • Compare XML File
      • Compare XML Data
      • Compare File
      • Compare Variables
      • Assertion Exception
      • Message Code
    • Others
      • Group
      • Memo
  • Conversion
    • Basic
      • Mapping
      • Join
      • Aggregate
      • Sort
      • Merge
      • Message Code
    • Character
      • Convert CP932 to SJIS
      • Convert SJIS to CP932
      • Remove Invalid XML Characters
      • Message Code
    • Table
      • Switch Row/Column
      • Message Code
    • XSLT
      • Convert XSLT Structure
      • Message Code
  • Database
    • Access
      • Operation Environment
      • Environment Settings
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Access 2013 Adapter Limitations
        • Access 2010 Adapter Limitations
    • DB2
      • Operation Environment
      • Library Installation
      • Global Resource Properties (DB2)
      • Global Resource Properties (DB2 for i)
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Write by Loader
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • DB2 V11.1 Adapter Limitations
        • DB2 V10.5 Adapter Limitations
        • DB2 V10.1 Adapter Limitations
        • DB2 V9.7 Adapter Limitations
        • DB2 V9.5 Adapter Limitations
        • DB2 V9.1 Adapter Limitations
        • DB2 for i 7.3 Adapter Limitations
        • DB2 for i 7.2 Adapter Limitations
        • DB2 for i 7.1 Adapter Limitations
    • MySQL
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • MySQL 8.0 Adapter Limitations
        • MySQL 5.7 Adapter Limitations
        • MySQL 5.6 Adapter Limitations
        • MySQL 5.5 Adapter Limitations
        • MySQL 5.1 Adapter Limitations
        • MySQL 5.0 Adapter Limitations
    • Oracle
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Global Resource Properties (OCI)
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Write by Loader
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Oracle 18c Adapter Limitations
        • Oracle 12cR2 Adapter Limitations
        • Oracle 12c Adapter Limitations
        • Oracle 11gR2 Adapter Limitations
        • Oracle 11g Adapter Limitations
        • Oracle 10gR2 Adapter Limitations
        • Oracle 10g Adapter Limitations
        • Oracle 9.2.0 Adapter Limitations
        • Oracle 9.0.1 Adapter Limitations
        • Oracle OCI Adapter Limitations
    • PostgreSQL
      • Operation Environment
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • PostgreSQL 11 Adapter Limitations
        • PostgreSQL 10 Adapter Limitations
        • PostgreSQL 9.6 Adapter Limitations
        • PostgreSQL 9.5 Adapter Limitations
        • PostgreSQL 9.4 Adapter Limitations
        • PostgreSQL 9.3 Adapter Limitations
        • PostgreSQL 9.2 Adapter Limitations
        • PostgreSQL 9.1 Adapter Limitations
        • PostgreSQL 9.0 Adapter Limitations
        • PostgreSQL 8.4 Adapter Limitations
        • PostgreSQL 8.3 Adapter Limitations
        • PostgreSQL 8.2 Adapter Limitations
    • SQL Server
      • Operation Environment
      • Environment Settings
      • Library Installation
      • Global Resource Properties (JDBC)
      • Global Resource Properties (ODBC)
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Write by Loader
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • SQL Server 2017 JDBC Adapter Limitations
        • SQL Server 2016 JDBC Adapter Limitations
        • SQL Server 2014 JDBC Adapter Limitations
        • SQL Server 2012 JDBC Adapter Limitations
        • SQL Server 2008 R2 JDBC Adapter Limitations
        • SQL Server 2008 JDBC Adapter Limitations
        • SQL Server 2008 ODBC Adapter Limitations
        • SQL Server 2005 JDBC Adapter Limitations
        • SQL Server 2005 ODBC Adapter Limitations
    • JDBC
      • Library Installation
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
    • ODBC
      • Environment Settings
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
    • MongoDB
      • Environment Settings
      • Global Resource Properties
      • Read Document
      • Write Document
      • Delete Document
      • Message Code
      • Limitations
    • Thunderbus
      • Operation Environment
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Table Browser
      • Select SQL Wizard
      • Message Code
      • Limitations
  • File
    • CSV
      • Read CSV File
      • Write CSV File
      • Message Code
    • Excel
      • Definition of Terms
      • Operation Environment
      • Read from Sheet
      • Read from Named Range
      • Read Specified Cell
      • Get Sheet Names
      • Write
      • Write Specified Cell
      • Protect Workbook and Sheet
      • Show/Hide Sheets/Rows/Columns
      • Rename Sheet
      • Copy Sheet
      • Delete Sheet
      • Excel Read Wizard
      • Excel Write Wizard
      • Excel Adapter Library
      • Message Code
    • PDF
      • Convert To Image
      • Message Code
    • HTML
      • Generate HTML File
      • Generate HTML Data
      • HTML Builder
      • Usage of Input Data
      • Usage of Variables
      • Edit Schema
      • Message Code
    • XML
      • Read XML File
      • Write XML File
      • Message Code
    • Fixed-Length
      • Read Fixed-Length File
      • Write Fixed-Length File
      • Fixed-Length Wizard
      • Fixed-Length Write Wizard
      • Message Code
    • Variable-Length
      • Read Variable-Length File
      • Write Variable-Length File
      • Variable-Length Wizard
      • Variable-Length Write Wizard
      • Message Code
    • File Operation
      • Create File
      • Create Directory
      • Copy
      • Delete File/Directory
      • Move
      • Get List of File Names
      • Check File/Directory Exists
      • Compress ZIP
      • Extract ZIP
      • Message Code
    • Filesystem
      • Read Filesystem
      • Write Filesystem
      • Message Code
  • Application
    • DataSpider BPM
      • Operation Environment
      • Global Resource Properties
      • Start Process
      • Search Tasks
      • Reallocate Tasks
      • Find Users
      • Add/Update Users
      • Delete Users
      • Find Organizations
      • Add/Update Organizations
      • Delete Organizations
      • Add/Update/Delete Members
      • Leader/Member Setting
      • Message Code
    • Dr.Sum
      • Operation Environment
      • Global Resource Properties
      • Read Table/View
      • Execute Datalizer
      • Write(VTB)
      • Write(BulkInsert)
      • Write(DataLoader)
      • Write(Update/Insert)
      • Execute Select SQL
      • Execute Update SQL
      • Truncate
      • Table Information
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Dr.Sum 5.1 Adapter Limitations
        • Dr.Sum 5.0 Adapter Limitations
        • Dr.Sum EA 4.2 Adapter Limitations
        • Dr.Sum EA 4.1 Adapter Limitations
        • Dr.Sum EA 4.0 Adapter Limitations
        • Dr.Sum EA 3.0 Adapter Limitations
    • Dynamics 365 for Customer Engagement
      • Operation Environment
      • Global Resource Properties
      • Read Entity
      • Write Entity
      • Delete Entity
      • Schema
      • Message Code
      • Limitations
        • Dynamics 365 for Customer Engagement Adapter Limitations
    • IBM Domino
      • Operation Environment
      • Environment Settings
      • Library Installation
      • Global Resource Properties
      • Read View
      • Read Notes Formula
      • Read Full-Text Search
      • Write Form
      • Message Code
    • IBM Notes
      • Operation Environment
      • Environment Settings
      • Global Resource Properties
      • Read View
      • Read Notes Formula
      • Read Full-Text Search
      • Write Form
      • Message Code
    • SAP
      • Operation Environment
      • EICS Business Method Settings(Inbound)
      • EICS Event Settings(Outbound)
      • Execute Business Method
      • Input Outbound
      • Output Outbound
      • Message Code
    • SAP BC
      • Operation Environment
      • Global Resource Properties
      • Execute Inbound
      • Message Code
      • SAP BC Adapter Tutorial
        • Inbound Processing Tutorial
        • Outbound Processing Tutorial
    • SAP Table Query
      • Operation Environment
      • Data Acquisition
      • Message Code
    • Tableau
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Output Hyper File
      • Publish Data Source
      • Set Data Source Permissions
      • Delete Data Source
      • Message Code
    • Universal Connect/X
      • Operation Environment
      • Library Install
      • Global Resource Properties
      • Output Forms
      • Output Report (From File)
      • Output API Function Definition (CSV)
      • Output Header Items (CSV)
      • Message Code
    • Report Director Enterprise
      • Operation Environment
      • Environment Settings
      • Global Resource Properties
      • Get Document Information
      • Get Server Printer Information
      • Print Execution
      • Message Code
      • Report Director Enterprise adapter restriction
  • Network
    • FTP
      • Operation Environment
      • Global Resource Properties
      • Get List and Data
      • Read List
      • Update
      • Delete
      • Rename
      • Message Code
    • JMS
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Receive Message
      • Send Message
      • Schema
      • Message Code
    • REST
      • Operation Environment
      • Global Resource Properties
      • Execute GET
      • Execute POST
      • Execute PUT
      • Execute DELETE
      • Message Code
    • Web
      • Operation Environment
      • Global Resource Properties
      • Crawl(Data Output/Parameter)
      • Crawl(Data Output/File)
      • Crawl(File/Parameter)
      • Crawl(File/File)
      • Message Code
    • Web Services
      • Operation Environment
      • Global Resource Properties
      • Execute Web Service
      • Message Code
    • Mail
      • Operation Environment
      • Global Resource Properties
      • Receive E-mail (POP3)
      • Receive E-mail (IMAP4)
      • Send Multiple E-mails
      • Send One E-mail
      • Message Code
  • Directory Services
    • Active Directory
      • Operation Environment
      • Environment Settings
      • Global Resource Properties
      • Search User
      • Search Group
      • Search User Member
      • Search Group Member
      • Search Group including the User
      • Search Group including the Group
      • Add a User
      • Add a Group
      • Add/Update Multiple Users
      • Add/Update Multiple Groups
      • Register/Update/Delete Group Member
      • Delete User
      • Delete Group
      • Enable/Disable Account
      • Move User
      • Move Group
      • Search Item Settings Wizard
      • Reference
      • Message Code
  • Cloud
    • Amazon Aurora for MySQL
      • Operation Environment
      • Amazon Aurora for MySQL Adapter Library
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Amazon Aurora for MySQL 5.7 Adapter Limitations
        • Amazon Aurora for MySQL 5.6 Adapter Limitations
    • Amazon DynamoDB
      • Operation Environment
      • IAM Permissions
      • Global Resource Properties
      • Get Item (Scan)
      • Get Item (Query)
      • Add/Replace Item
      • Delete Item
      • Message Code
      • Amazon DynamoDB Adapter Restriction
    • Amazon EC2
      • Operation Environment
      • IAM Permissions
      • Global Resource Properties
      • Start Instances
      • Stop Instances
      • Describe Instances
      • Message Code
    • Amazon RDS for MySQL
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Amazon RDS for MySQL 8.0 Adapter Limitations
        • Amazon RDS for MySQL 5.7 Adapter Limitations
        • Amazon RDS for MySQL 5.6 Adapter Limitations
        • Amazon RDS for MySQL 5.1 Adapter Limitations
    • Amazon RDS for Oracle
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Write by Loader
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Amazon RDS for Oracle 12cR2 Adapter Limitations
        • Amazon RDS for Oracle 12c Adapter Limitations
        • Amazon RDS for Oracle 11gR2 Adapter Limitations
    • Amazon RDS for PostgreSQL
      • Operation Environment
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Amazon RDS for PostgreSQL 11 Adapter Limitations
        • Amazon RDS for PostgreSQL 10 Adapter Limitations
        • Amazon RDS for PostgreSQL 9.5 Adapter Limitations
        • Amazon RDS for PostgreSQL 9.4 Adapter Limitations
        • Amazon RDS for PostgreSQL 9.3 Adapter Limitations
    • Amazon RDS for SQL Server
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Message Code
      • Limitations
        • Amazon RDS for SQL Server 2017 Adapter Limitations
        • Amazon RDS for SQL Server 2016 Adapter Limitations
        • Amazon RDS for SQL Server 2014 Adapter Limitations
        • Amazon RDS for SQL Server 2012 Adapter Limitations
    • Amazon Redshift
      • Operation Environment
      • Library Installation
      • IAM Permissions
      • Global Resource Properties
      • Execute COPY Command
      • Message Code
    • Amazon S3
      • Operation Environment
      • IAM Permissions
      • Global Resource Properties
      • Get Bucket List
      • Get File/Folder List
      • Read File/Folder
      • Write File/Folder
      • Copy File/Folder
      • Delete File/Folder
      • Read File/Folder(Data)
      • Write File/Folder(Data)
      • Message Code
    • Amazon SimpleDB
      • Operation Environment
      • IAM Permissions
      • Global Resource Properties
      • Read Item
      • Execute Query
      • Put Item
      • Delete Item
      • Create Domain
      • Delete Domain
      • Message Code
    • Amazon SQS
      • Operation Environment
      • IAM Permissions
      • Global Resource Properties
      • Receive Message
      • Send Message
      • Delete Message
      • Message Code
    • Azure SQL Database
      • Operation Environment
      • Library Installation
      • Global Resource Properties
      • Read Table
      • Execute Select SQL
      • Write Table
      • Execute Update SQL
      • Execute Stored Procedure
      • Table Browser
      • Select SQL Wizard
      • Update SQL Wizard
      • Limitations
      • Message Code
    • Azure BLOB Storage
      • Operation Environment
      • Global Resource Properties
      • Get Container List
      • Read File/Directory
      • Write File/Directory
      • Delete File/Directory/Container
      • Message Code
    • Azure Cosmos DB
      • Operation Environment
      • Global Resource Properties
      • Read Document
      • Read Document by SQL
      • Write Document
      • Delete Document
      • Message Code
      • Limitations
    • Azure HDInsight
      • Operation Environment
      • Create Cluster
      • Delete Cluster
      • Execute Hive Job
      • Message Code
    • Azure Machine Learning
      • Operation Environment
      • Global Resource Properties
      • Execute Job
      • Message Code
    • Azure Queue Storage
      • Operation Environment
      • Global Resource Properties
      • Receive Message
      • Send Message
      • Delete Message
      • Message Code
    • Cloudn
      • Operation Environment
      • Global Resource Properties
      • Start virtual server
      • Stop virtual server
      • Get virtual server information
      • Message Code
    • Gmail
      • Operation Environment
      • Global Resource Properties
      • Receive E-mail (POP3)
      • Receive E-mail (IMAP4)
      • Send Multiple E-mails
      • Send One E-mail
      • Message Code
    • Google Drive
      • Operation Environment
      • Global Resource Properties
      • Get File/Folder List
      • Read File/Folder
      • Write File/Folder
      • Delete File/Folder
      • Message Code
    • Google Sheets
      • Operation Environment
      • Global Resource Properties
      • Read Sheet
      • Retrieve Sheets
      • Writing
      • Message Code
    • kintone
      • Operation Environment
      • Global Resource Properties
      • Get Record
      • Add Record
      • Update Record
      • Delete Record
      • Read Table
      • Write Table
      • Delete Table Data
      • Call API
      • Schema
      • Message Code
    • Nifty Cloud
      • Operation Environment
      • Global Resource Properties
      • Start server
      • Stop server
      • Get server information
      • Message Code
    • Nifty Cloud Storage
      • Operation Environment
      • Global Resource Properties
      • Get Bucket List
      • Get File/Folder List
      • Read File/Folder
      • Write File/Folder
      • Delete File/Folder
      • Message Code
    • Tegaki
      • Operation Environment
      • Global Resource Properties
      • Read Characters
      • Message Code
    • Log Manager for Salesforce
      • Operation Environment
      • Global Resource Property
      • Write Job Data
      • Message Code
    • Salesforce
      • Operation Environment
      • About Connect with OAuth
      • Global Resource Property
      • Read Data(Query)
      • Read Data(Replication)
      • Read Data(Retrieve by ID)
      • Read Data(Parent-Child Relation)
      • Read Data(Child-Parent Relation)
      • Read Data(execute SOQL)
      • Write Data(Insert)
      • Write Data(Update)
      • Write Data(Delete)
      • Write Data(Upsert)
      • Reset Password
      • Set Password
      • Empty Recycle Bin
      • Undelete(Recycle Bin)
      • Send Single Mail
      • Send Multiple Mails
      • Login(by Session ID)
      • Generate Multi Data File
      • Write Multi Data
      • Create Search Parameter
      • Get Server Info
      • Get User Info
      • Message Code
    • Salesforce Bulk
      • Operation Environment
      • About Connect with OAuth
      • Global Resource Property
      • Bulk Write Data(Insert)
      • Bulk Write Data(Update)
      • Bulk Write Data(Delete)
      • Bulk Write Data(Upsert)
      • Bulk Get Data(Query)
      • Create Job
      • Update Job
      • Create Batch
      • Get Batch Result
      • Get Job and Batch Information
      • Login(by Session ID)
      • Message Code
    • Salesforce Metadata
      • Operation Environment
      • About Connect with OAuth
      • Global Resource Property
      • Read (PicklistValue)
      • Insert(PicklistValue)
      • Update(PicklistValue)
      • Update(PickListControllingFieldValue)
      • Delete(PicklistValue)
      • Sort(PicklistValue)
      • Update(PicklistValueTranslation)
      • Read(RecordTypePicklistValue)
      • Update(RecordTypePicklistValue)
      • GetReslut(AsyncResult)
      • Read(CustomLabel)
      • Message Code
  • Big data
    • Hadoop HDFS
      • Operation Environment
      • Global Resource Properties
      • Read CSV Data
      • Write CSV Data
      • Read XML Data
      • Write XML Data
      • File Download
      • File Upload
      • Delete File/Directory
      • Get File/Directory List
      • Message Code
  • HULFT
    • Request Issuance
      • Operation Environment
      • Global Resource Properties
      • Send File
      • Send Request
      • Message Code
    • History
      • Supported Platform
      • Read History Information
      • Message Code
  • Auth
    • OAuth 2.0
      • Global Resource Properties (OAuth 2.0)
      • Global Resource Properties (OpenID Connect 1.0)
• Mapper
  • Document Mapper
    • Basic Functions
      • How to Use
      • Mapper Editor
      • Temporary Schema
      • Loop
      • How to Use Variables
      • Output Processing Data Log Function
      • Edit Schema
      • Mapper Logic
    • Other Function
      • Null Option
      • Custom Logic
      • Layer Function
      • Real-time Preview Function
      • I/O Item Search
    • Mapper Logic Guide
      • Mapper Logic List
      • Loop
        • Iterate specified node
        • Sort by Key
        • Sort by Two Keys
        • Grouping
        • If Loop
      • Branch
        • If
        • Switch
      • Condition
        • And
        • Or
        • Not
        • Boolean Constant
        • To Boolean
        • Check Null
        • Equal
        • Not Equal
        • Less Than
        • Not More Than
        • More Than
        • Not Less Than
        • Identical
        • Different
        • Start with
        • End with
        • Contain
        • Match to Regular Expression
        • Equal Date/Time
        • Before
        • After
        • Date/Time Exists
      • Number
        • Numeric Constant
        • To Number
        • Input Node Number
        • Output Node Number
        • Add
        • Subtract
        • Multiply
        • Divide
        • Modulo
        • Ceiling
        • Floor
        • Rounding
        • Absolute Value
        • Square Root Value
        • The Larger
        • The Smaller
        • Sign
        • String Length
        • Number of Bytes
        • Sum
        • Average
        • Number of Node
        • Maximum Node
        • Minimum Node
        • Get Year
        • Get Month
        • Get Day
        • Get Hour
        • Get Minute
        • Get Second
        • Get Day of the Week
        • Get Number of Days
        • Calculate Period by Year
        • Calculate Period by Month
        • Calculate Period by Day
        • Calculate Period by Hour
        • Calculate Period by Minute
        • Calculate Period by Second
        • Replace Null/Empty String
        • Convert Chinese Numeral to Numeric
        • Calculate Age
      • String
        • Single-line String Constant
        • Multi-line String Constant
        • Unique string
        • Execution ID
        • Execution Environment ID
        • Execution User
        • Execution Project Name
        • Execution Script Name
        • Execution Type
        • Execution Trigger Name
        • Execution Trigger Type
        • System Property
        • Get Value by XPath
        • To String
        • Concatenate
        • Left String
        • Right String
        • Middle String (property)
        • Middle String (input handler)
        • Repeat String (input handler)
        • String After Specified Position
        • After Specified Character
        • Before Specified Character
        • Left String (bytes)
        • Retrieve data by executing SQL
        • Replace Each String
        • Replace by CSV Table
        • Replace by DB Table
        • Replace by Regular Expression
        • Lowercase
        • Uppercase
        • Replace Each Character
        • Replace Null
        • Replace Null/Empty String
        • Convert Numeral System
        • Trim Both Sides
        • Trim Left
        • Trim Right
        • Format Number
        • Date/Time Formatting
        • Encrypt
        • Decrypt
        • Hiragana to Katakana
        • Katakana to Hiragana
        • Hiragana to Roman Alphabet
        • Em-size to Normal-width
        • Normal-width to Em-size
        • Convert to Chinese Numeral
        • Convert to Japanese Calendar
      • Date
        • Current Date/Time
        • Date/Time Constant
        • Parse Date/Time
        • Set Year
        • Set Month
        • Set Day
        • Set Hour
        • Set Minute
        • Set Second
        • Calculate Year
        • Calculate Month
        • Calculate Day
        • Calculate Hour
        • Calculate Minute
        • Calculate Second
        • Parse Japanese Calendar
      • Excel
        • Generate Excel Format
      • Other
        • Null Value
        • Replace Empty String
        • Copy Input Element
  • Variable Mapper
    • Basic Functions
      • How to Use
      • Mapper Editor
      • Temporary Schema
      • Loop
      • How to Use Variables
      • Output Processing Data Log Function
      • Edit Schema
      • Mapper Logic
    • Other Function
      • Null Option
      • Custom Logic
      • Layer Function
      • Real-time Preview Function
      • I/O Item Search
    • Mapper Logic Guide
      • Mapper Logic List
      • Branch
        • If
        • Switch
      • Condition
        • And
        • Or
        • Not
        • Boolean Constant
        • To Boolean
        • Check Null
        • Equal
        • Not Equal
        • Less Than
        • Not More Than
        • More Than
        • Not Less Than
        • Identical
        • Different
        • Start with
        • End with
        • Contain
        • Match to Regular Expression
        • Equal Date/Time
        • Before
        • After
        • Date/Time Exists
      • Number
        • Numeric Constant
        • To Number
        • Add
        • Subtract
        • Multiply
        • Divide
        • Modulo
        • Ceiling
        • Floor
        • Rounding
        • Absolute Value
        • Square Root Value
        • The Larger
        • The Smaller
        • Sign
        • String Length
        • Number of Bytes
        • Get Year
        • Get Month
        • Get Day
        • Get Hour
        • Get Minute
        • Get Second
        • Get Day of the Week
        • Get Number of Days
        • Calculate Period by Year
        • Calculate Period by Month
        • Calculate Period by Day
        • Calculate Period by Hour
        • Calculate Period by Minute
        • Calculate Period by Second
        • Replace Null/Empty String
        • Convert Chinese Numeral to Numeric
        • Calculate Age
      • String
        • Single-line String Constant
        • Multi-line String Constant
        • Unique string
        • Execution ID
        • Execution Environment ID
        • Execution User
        • Execution Project Name
        • Execution Script Name
        • Execution Type
        • Execution Trigger Name
        • Execution Trigger Type
        • System Property
        • Get Cell Value
        • Get Value by XPath
        • To String
        • Concatenate
        • Left String
        • Right String
        • Middle String (property)
        • Middle String (input handler)
        • Repeat String (input handler)
        • String After Specified Position
        • After Specified Character
        • Before Specified Character
        • Left String (bytes)
        • Retrieve data by executing SQL
        • Replace Each String
        • Replace by CSV Table
        • Replace by DB Table
        • Replace by Regular Expression
        • Lowercase
        • Uppercase
        • Replace Each Character
        • Replace Null
        • Replace Null/Empty String
        • Convert Numeral System
        • Trim Both Sides
        • Trim Left
        • Trim Right
        • Format Number
        • Date/Time Formatting
        • Encrypt
        • Decrypt
        • Hiragana to Katakana
        • Katakana to Hiragana
        • Hiragana to Roman Alphabet
        • Em-size to Normal-width
        • Normal-width to Em-size
        • Convert to Chinese Numeral
        • Convert to Japanese Calendar
      • Date
        • Current Date/Time
        • Date/Time Constant
        • Parse Date/Time
        • Set Year
        • Set Month
        • Set Day
        • Set Hour
        • Set Minute
        • Set Second
        • Calculate Year
        • Calculate Month
        • Calculate Day
        • Calculate Hour
        • Calculate Minute
        • Calculate Second
        • Parse Japanese Calendar
      • Excel
        • Generate Excel Format
      • Other
        • Null Value
        • Replace Empty String
  • Merge Mapper
    • Basic Functions
      • How to Use
      • Mapper Editor
      • Merge Settings
      • Temporary Schema
      • Output Processing Data Log Function
      • Edit Schema
      • Mapper Logic
    • Other Function
      • Null Option
      • Layer Function
      • Real-time Preview Function
      • I/O Item Search
    • Mapper Logic Guide
      • Mapper Logic List
      • Merge
        • Or-Append Merge
        • Or-Integrate Merge
        • And-Append Merge
        • And-Integrate Merge
        • Left-Right-Join Merge
      • Branch
        • If
        • Switch
      • Number
        • Numeric Constant
        • To Number
        • Add
        • Subtract
        • Multiply
        • Divide
        • Modulo
        • Ceiling
        • Floor
        • Rounding
        • Absolute Value
        • Square Root Value
        • The Larger
        • The Smaller
        • Sign
        • String Length
        • Number of Bytes
        • Get Year
        • Get Month
        • Get Day
        • Get Hour
        • Get Minute
        • Get Second
        • Get Day of the Week
        • Get Number of Days
        • Calculate Period by Year
        • Calculate Period by Month
        • Calculate Period by Day
        • Calculate Period by Hour
        • Calculate Period by Minute
        • Calculate Period by Second
        • Replace Null/Empty String
        • Convert Chinese Numeral to Numeric
        • Calculate Age
      • String
        • Single-line String Constant
        • Multi-line String Constant
        • Unique string
        • Execution ID
        • Execution Environment ID
        • Execution User
        • Execution Project Name
        • Execution Script Name
        • Execution Type
        • Execution Trigger Name
        • Execution Trigger Type
        • System Property
        • To String
        • Concatenate
        • Left String
        • Right String
        • Middle String (property)
        • Middle String (input handler)
        • Repeat String (input handler)
        • String After Specified Position
        • After Specified Character
        • Before Specified Character
        • Left String (bytes)
        • Retrieve data by executing SQL
        • Replace Each String
        • Replace by CSV Table
        • Replace by DB Table
        • Replace by Regular Expression
        • Lowercase
        • Uppercase
        • Replace Each Character
        • Replace Null
        • Replace Null/Empty String
        • Convert Numeral System
        • Trim Both Sides
        • Trim Left
        • Trim Right
        • Format Number
        • Date/Time Formatting
        • Encrypt
        • Decrypt
        • Hiragana to Katakana
        • Katakana to Hiragana
        • Hiragana to Roman Alphabet
        • Em-size to Normal-width
        • Normal-width to Em-size
        • Convert to Chinese Numeral
        • Convert to Japanese Calendar
      • Date
        • Current Date/Time
        • Date/Time Constant
        • Parse Date/Time
        • Set Year
        • Set Month
        • Set Day
        • Set Hour
        • Set Minute
        • Set Second
        • Calculate Year
        • Calculate Month
        • Calculate Day
        • Calculate Hour
        • Calculate Minute
        • Calculate Second
        • Parse Japanese Calendar
      • Other
        • Replace Empty String
        • Output by XPath Expression