[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

入力データごとのキー値を比較し、1番目の入力データのキーに2番目以降のキーがすべてマッチした場合、列に追加する形でデータを出力し、1つでもマッチしなかった場合は1番目の入力データのみ出力します。

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,,