A JOIN operation is used to join different tables. If the data that you want to analyze is stored in different tables, you can join the tables to build a model for data analysis.

Prerequisites

A dataset is created. For more information, see Create and manage datasets.

Background information

Quick BI supports the Left Outer Join, Inner Join, and Full Outer Join operations. The following figure shows how to perform the preceding JOIN operations to join a student table and a student score table. JOIN operations
Note The preceding figure shows only the principles of the JOIN operations. When you join tables, the original columns of the tables that you join are retained.

Limits

  • You can join tables from different data sources only in Quick BI Enterprise Standard.
  • When you join tables from different data sources, make sure that the data sources are MaxCompute, MySQL, and Oracle databases.
  • MySQL data sources do not support the Full Outer Join operation.

Procedure

  1. On the dataset edit page, perform the steps that are shown in the following figure to drag tables to the canvas.
    Configure a dataset
  2. In the Add Association Relationship panel, perform the steps that are shown in the following figure to join tables.
    Add Association Relationship
    Note
    • The following types of JOIN operations are supported: Left Outer Join (Left Outer Join), Inner Join (Inner Join), and Full Outer Join (Full Outer Join).
    • MySQL does not support the Full Outer Join (Full Outer Join) operation.
    • When you configure join types, make sure that the fields you want to associate exist in the tables you want to join.

After the configuration is complete, you can click the join icon, such as Join icon, on the canvas to view the join result.

If you no longer need a table in the join, move the pointer over the table and click the Delete icon (Delete icon).
Note You can delete only the table of the lowest level in a model.