[Merge Mapper]Left-Right-Join Merge

Logic Name

Left-Right-Join Merge

Function

Merges input data in Left-Right-Join format.

Data Types

Location	Type
Logic output	Loop

Refer to "Logic Specifications" for details.

Properties

Category	Property	Description
Comment	Comment	The comment will also be output to the specifications.It does not affect the conversion process.

Function Details

In Left-Right-Join Merge, because merge is executed according to the input data specified first, the first input data serves different rule with the input data after.
The order of input data can be edited from the properties of Merge.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The logic compares the key values of each input data. If the key of the first input data match all the following keys, it outputs data adding to columns. If one of them does not match, output only the first input data.

Property Settings

Property	Setting
None

Input Data

csv_read

1,Sample

2,Test

3,Dummy

csv_read(1)

1,Data

2,Value

4,SomeData

csv_read(2)

1,Red

2,Blue

3,Yellow

Output Data

1,Sample,Data,Red

2,Test,Value,Blue

3,Dummy,,