<< Click to Display Table of Contents >> Current:  Common Analysis Scenarios  How to Create Composed Data Set

When the data required by the company is stored in different tables, you can associate different tables by Composed Data Set.

 

1.Enter Composed Data Set

In the Create Data Set interface, click [Composed Data Sets].

 

2.Edit Data

From the left data set list, drag and drop the required data tables, such as “Coffee Sales Data of China Market” and “Coffee Orders Data of China Market” to the editing area in the middle of the interface.

 

3.Set Join Type

1)By default, the two tables will be combined as join. Click on the connector  between the two tables, open the Operation Type window, select the join type or union you want, and set the join column.

➢Note:

Join: Combine records in left and right tables that meet join conditions.

Left join: The records in the left table are all displayed. The right table only shows the records that meet the join condition, and the insufficient data will be blank.

Right join: The records in the right table are all displayed. The left table only shows the records that meet the join conditions, and the insufficient data will be blank.

Full join: The records of the left and right tables are all displayed..The insufficient data of records not matched will be blank.

Union: The data of two tables (including duplicate data rows) are stitched together. The left table data is on top, the right table data is down, and the combined table column name is the left table column name.

 

2)The two tables are successfully connected. Click [Refresh Metadata], and all the data in the joint table will be displayed in the metadata area.

 

4.Save

Click the [Save] button on the menu bar, the composed data set will be saved for subsequent use in Create Dashboard.