This topic describes how to join a dataset with a table. If you have multiple tables from the same data source, you can join them by using a snowflake or star schema. Assume that you join Table A with Table B and then join Table B with Table C. Quick BI adds join fields involved in the join operations to the dimension and measure lists of Table A.

Prerequisites

A dataset is created. For more information, see Create a dataset.

Background information

  • If your dataset is not processed in a data warehouse, you must join the dataset with tables.
  • If your dataset meets your business requirements, you can directly perform secondary data processing.

Usage notes

Note
  • You cannot join tables from different data sources in Quick BI Basic or Quick BI Pro.
  • You can join tables from different data sources in Quick BI Enterprise Standard. Make sure that the data sources are MaxCompute, MySQL, and Oracle databases.
  • You can join a dataset with a table in a database, but cannot join it with another dataset.
Quick BI supports the following join types:
  • INNER JOIN: INNER JOIN
  • LEFT OUTER JOIN: LEFT OUTER JOIN
  • FULL OUTER JOIN: FULL OUTER JOIN
    Note MySQL data sources do not support FULL OUTER JOIN.

Procedure

  1. Click the Workspace tab. In the left-side navigation pane, click Datasets.
  2. On the Datasets page, find the required dataset, and click the Edit icon icon in the Actions column.Edit icon
  3. On the dataset edit page, click the Join icon icon.
  4. Click the Add icon icon to join the dataset with a table.
    1. In the dialog box that appears, select a join field from the Dataset Field drop-down list.
    2. Select a join type from the Join Type drop-down list.
    3. Select a dimension table with which you want to join the dataset from the Join Table drop-down list.
    4. Select a field from the Join Field drop-down list. The field is from the dimension table and is used to join the dimension table with the dataset.
    5. Click OK.
      • Click the Add icon icon marked with 1 to join the table with another table.
      • Click the Add icon icon marked with 2 to join the dataset with another table.
      Note If you join tables one by one, a maximum of five join levels is supported.
  5. Click the Preview icon icon to preview the dataset after the join operations.
  6. Click Save to save the dataset.
    Note Before you save the dataset, you can click Set Filter to filter the data in the dataset. This speeds up data searches.