Logic specification (Merge Mapper)

Mapper logic

The Mapper logic is a function that can perform various conversion/processing such as arithmetic operation and character replacement.

Usage of Mapper logic

The process of using the Mapper logic is the same as Document Mapper and Variable Mapper.

= Remarks =

For details, refer to Usage of Mapper logic.

Mapper logic specifications

Mapper logic type

The Mapper logic is roughly divided into two types: "Merge" and "Convert".

The type can be determined from the chip at the upper left of the icon.

Logic type	Chip image	Palette tab name
Merge Logic		Merge
Convert logic		Branch Number String Date

Logic type

Chip image

Palette tab name

Merge Logic

Merge

Convert logic

Branch

Number

String

Date

= Remarks =

Refer to Data type of the Convert logic for the Convert logic.

Merge logic

Merge logic type

In Merge Mapper, integration based on various criteria can be done using Merge Mapper logic (hereinafter: Merge logic) that specifies integration criteria.

The following Merge logics are available in HULFT Square.

	APPEND Outputs each input source separately in the specified output schema.	INTEGRATE Integrates all input sources that matches the criteria to the output destination.
AND Only the input source data matching the criteria are the target.	And-Append Merge Only the input sources matching the criteria are the target for output. The result data are output separately.	And-Integrate Merge Only the input sources matching the criteria are the target for output. The result data are combined and output as one.
OR All input source data are the target.	Or-Append Merge All input sources are the target for output. The result data are output separately.	Or-Integrate Merge All input sources are the target for output. Data that meet the criteria are combined and output as one.
LEFT-RIGHT-JOIN The first input source data are the target.	-	Left-Right-Join Merge The first input source data is the target for output. Data that meet the criteria are combined and output as one.

APPEND

Outputs each input source separately in the specified output schema.

INTEGRATE

Integrates all input sources that matches the criteria to the output destination.

AND

Only the input source data matching the criteria are the target.

And-Append Merge

And-Append Merge

Only the input sources matching the criteria are the target for output. The result data are output separately.

And-Integrate Merge

And-Integrate Merge

Only the input sources matching the criteria are the target for output. The result data are combined and output as one.

All input source data are the target.

Or-Append Merge

Or-Append Merge

All input sources are the target for output. The result data are output separately.

Or-Integrate Merge

Or-Integrate Merge

All input sources are the target for output. Data that meet the criteria are combined and output as one.

LEFT-RIGHT-JOIN

The first input source data are the target.

Left-Right-Join Merge

Left-Right-Join Merge

The first input source data is the target for output. Data that meet the criteria are combined and output as one.

= Remarks =

For information regarding the difference in operation of each Merge logic, refer to "Logic sample" of the Merge logic.

When null is input

Null indicating no value existing may be input to the data of connectors such as database.

= Remarks =

For information regarding how to treat null entered in the Convert logic, refer to When null is input.

Specification limits

Note

The Convert logic can't be directly mapped to the output schema.

= Remarks =

For information regarding the common specification limits on Mapper Logic, refer to Common specification limits to Mappers.

Notes

= Remarks =

For information regarding the common notes, refer to Common notes to Mappers.