Official |[Mapper]Left-Right-Join Merge

Logic name

Left-Right-Join Merge (Merge Mapper)

Function

This logic merges the input data in Left-Right-Join format.

Data types

Location	Type
Logic output	Loop

= Hint =

For details, refer to Logic specifications.

Properties

Category	Property	Description
Comment	Comment	You can write a description of the logic. It doesn't affect the conversion process.

Function details

In Left-Right-Join Merge, because merge is executed based on the unit of input data specified first, the first unit of input data serves a different role than all the following units.

The order of input data can be edited from the properties of Merge Mapper.

Logic sample

Mapping definition

Logic settings and processing result

The logic compares the key values of each unit of input data. If the key of the first unit of input data matches all the following keys, it outputs data by adding the data to columns. If one of them doesn't match, it outputs only the first unit of 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,,

= Hint =

For a list of logics, refer to Mapper Logic Guide.