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
- : LEFT OUTER JOIN
- : FULL OUTER JOIN
Note MySQL data sources do not support FULL OUTER JOIN.
Procedure
- Click the Workspace tab. In the left-side navigation pane, click Datasets.
- On the Datasets page, find the required dataset, and click the icon in the Actions column.
- On the dataset edit page, click the icon.
- Click the icon to join the dataset with a table.
- In the dialog box that appears, select a join field from the Dataset Field drop-down list.
- Select a join type from the Join Type drop-down list.
- Select a dimension table with which you want to join the dataset from the Join Table drop-down list.
- 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.
- Click OK.
- Click the icon marked with 1 to join the table with another table.
- Click the 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.
- Click the icon to preview the dataset after the join operations.
- 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.