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

FromName of the left Input Data Source.The source must contain the neutral Table-format.
ToName 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

@LeftKeyColumnSpecifies 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.
@RightKeyColumnSpecifies 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

_ValueText _ValueTextColor
1Txt1 1TxtaBlue
2Txt2 2TxtbGray
3Txt3 2TxtcGreen
4Txt4 4TxtdRed
4Txt5 5TxteYellow

 

Inner join result

 

Left join result

 

  Full join result

_ValueTextColor _ValueTextColor _ValueTextColor
1Txt1Blue 3Txt3  3Txt3 
2Txt2Gray 1Txt1Blue 1Txt1Blue
2Txt2Green 2Txt2Gray 2Txt2Gray
4Txt4Red 2Txt2Green 2Txt2Green
4Txt5Red 4Txt4Red 4Txt4Red
    4Txt5Red 4Txt5Red
        5 Yellow

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.