JOIN.INNER, JOIN.LEFT, JOIN.RIGHT and JOIN.FULL

  • Updated

 

Join two neutral tables to a joined table result. The three join commands can join at a specified column from each table. The result will be all the columns from the left site and new columns from the right site (columns defined in both tables will be taken from the left site). JOIN.RIGHT is introduced in 2023-R2.

Properties

From Name of the left Input Data Source.The source must contain the neutral Table-format.
To Name of the right Input Data Source and the result. The input will be overwritten be the result.
The source must also be the neutral Table-format.

Parameters

@LeftKeyColumn Specifies the column name of the key in the left table. The parameter is optional and if not specified, the first column well be used as the key.
@RightKeyColumn Specifies the column name of the key in the right table. The parameter is optional and if not specified, the first column well be used as the key.

Map

This Command does not use any value mappings.

Guide

Simple joins from to tables. Remarks: the column "Text" exists I both tables and only data from the Left Table will be taken from the "Text" column. The _Value has duplicates for respectively 4 and 2 in the two tables and this will generate two rows in the results. To avoid this, use the SELECT.UNIQUE command to remove duplicates rows.

Left Table

  

 Right Table
_Value Text   _Value Text Color
1 Txt1   1 Txta Blue
2 Txt2   2 Txtb Gray
3 Txt3   2 Txtc Green
4 Txt4   4 Txtd Red
4 Txt5   5 Txte Yellow

 

Inner join result

  

Left join result

  

  Full join result
_Value Text Color   _Value Text Color   _Value Text Color
1 Txt1 Blue   3 Txt3     3 Txt3  
2 Txt2 Gray   1 Txt1 Blue   1 Txt1 Blue
2 Txt2 Green   2 Txt2 Gray   2 Txt2 Gray
4 Txt4 Red   2 Txt2 Green   2 Txt2 Green
4 Txt5 Red   4 Txt4 Red   4 Txt4 Red
        4 Txt5 Red   4 Txt5 Red
                5   Yellow

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.