Creating a join condition - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

About this task

This step is optional. You can decide to create a business rule without a join condition and use it with only the WHERE clause in the table analysis.

For an example of a table analysis with a simple business rule, see Creating a table analysis with a simple SQL business rule. For an example of a table analysis with a business rule that has a join condition, see Creating a table analysis with an SQL business rule with a join condition.

Procedure

  1. In the SQL business rule editor, click Join Condition to open the corresponding view.
  2. Click the [+] button to add a row in the Join Condition table.
  3. Define the join condition and save it.
  4. Expand the Metadata folder in the DQ Repository tree view, and browse to the columns in the tables on which you want to create the join condition.
    This join condition will define the relationship between a table A and a table B using a comparison operator on a specific column in both tables. In this example, the join condition will compare the "name" value in the Person and Person_Ref tables that have a common column called name.
    Note: You must be careful when defining the join clause. In order to get an easy to understand result, it is advisable to make sure that the joined tables do not have duplicate values. For further information, see Creating a table analysis with an SQL business rule with a join condition.
  5. Drag-and-drop the columns from the DQ Repository tree view to the Join Condition table.
    A dialog box is displayed prompting you to select where to place the column: in TableA or in TableB.
  6. Select a comparison condition operator between the two columns in the tables and save your modifications.
    In the analysis editor, you can now drop this newly created SQL business rule onto a table that has an "age" column. When you run the analysis, the join to the second column is done automatically.
    Warning: The table to which to add the business rule must contain at least one of the columns used in the SQL business rule.