Basic Functions (Merge Mapper)

For details on Document Mapper and Variable Mapper, refer to “Basic Functions (Document Mapper/Variable Mapper)”.
For details on properties, specification limits, and notes, refer to "Merge Mapper".

Merge Mapper

Merge Mapper is a converter to combine data read from multiple input source components in accordance with the mapping definition and write it to the following components.

How to Use

Merge Mapper can be used in Designer. Follow the instructions below to use it.

Merge Settings

  1. Place a merge logic in the mapping canvas.



  2. Map the loop point of the input source to the first handler of merge logic.



    The specification method for loop points varies depending on the data model of input source schema.
    Refer to “Loop point” for more details.

  3. Map the element for the key for merging the input source to the second handler of merge logic.



  4. Map all the input sources to be merged in the same way.



  5. Map to the loop point of the output destination from merge logic.



  6. Map the elements to be output from input source to output destination.

Temporary Schema

For input/output schema of Document Mapper and output schema of Merge Mapper, when data flow is removed, the schema that has been set will be retained. This is called "Temporary schema".



The component icon name part of temporary schema is displayed as “Temporary schema” to distinguish from normal schemas.

When the Mapper is connected to another component through a data flow, the temporary schema will be restored to normal schema.
With temporary schema, mapping links remain even if its corresponding data flow is removed, and you can edit schema even if the Mapper is not connected to a component.

On the other hand, when the data flow is removed from Mappers without temporary schema (input schema of Variable Mapper and Merge Mapper), the schema will be reset and the mapping links will be removed.

To edit schema before setting data flows, you can set a temporary schema manually.
Select [Set temporary schema] from the right-click menu.

Output Processing Data Log Function

Output processing data log function is the function to output data information processed with Mapper logic to the log.
As this log is output in the order of internal process of Mapper, you can know how the data conversion/processing is done in detail.
With this function, it is possible to create a conversion/processing while checking the operation of actual data, and therefore you can develop a mapping efficiently.

Targets for outputting log and the log levels are as follows.

Target Log level
Input/Output data of Mapper logic DEBUG
Data output into output schema DEBUG

The details of output contents are as follows.

Input/Output data of Mapper logic

Input/Output data of Mapper logic are output in DEBUG log level.
The format varies depending on the number of input handlers.

Mapper logic with no input handler

Format
[<Mapper logic name>] OUT=[<output data>]
Output example
[Single-line String Constant] OUT=[outputData]

Mapper logic with one input handler

Format
[<Mapper logic name>] IN=[<input data>] | OUT=[<output data>]
Output example
[Left String] IN=[SampleData] | OUT=[Sample]

Mapper logic with multiple input handlers

Format
[<Mapper logic name>] IN=[<input data 1>][<input data 2>]... | OUT=[<output data>]
Output example
[Concatenate] IN=[Sample][Data] | OUT=[SampleData]

Data output into output schema

Data output into output schema is output in DEBUG log level.
The format differs depending on whether the data model of output data is table model type or XML type.

Table model type

Format
column[<row number>,<column number>] IN=[<input data>]
Output example
column[2,1] IN=[SampleData]
Row/Column number starts from 1.

XML type

Format
<the path in output schema> IN=[<input data>]
The attribute in output schema is output as “@<attribute name>”.
The prefix of name space in output schema is output as “<prefix>:” before element name and attribute name.
Output example
/root/row/col IN=[SampleData]
/root/row/col/@attr IN=[SampleData]
/root/row/pre:col IN=[SampleData]

Notes

Specification Limits