Create and Merge Data Sets

When it is necessary to summarize the data of multiple data sets into one data set, the data merge function can be used. The data merge can select the required fields to merge and add filter conditions to choose the needed data.

The data sets participating in the data merge must first enable the acceleration engine; direct connection data sets do not support data merge.

Enable Acceleration Engine

Enable the acceleration engine for the data sets involved in the merge. The steps to enable the acceleration engine are described in Enable Acceleration Engine.

Select Data Merge

Go to the data set page, click to create a new data set, and select Data Merge.

Select the Base Data Set

Go to the data set selection page and choose the base data set.

Select a data set as the base data set for data merging, and click next.

Select the Data Sets to Append

The page will redirect to the data set merging interface, which is divided into three areas:

The left side is a list of data sets, listing all the data sets with enabled acceleration engines that are not data merges in the application; these can be dragged to below the right side base data set.
The upper right side is the merge operation interface, where data sets and fields participating in the merge are dragged into the Append tab, and filter conditions are added in the Filter Conditions tab.
The lower right side displays all the fields of the selected data sets to be merged; fields already participating in the merge appear grey, and those not yet involved are displayed normally.

There are three operations for appending fields:

Select the operation row and click the append identical fields button at the bottom right to append all fields with the same name.
Select an operation area in the operation row and then click on the fields below to complete the append.
Click to select an operation area and then click on the fields below to append fields to the selected position.

For data sets with erroneous operations, you can click the minus icon in front of the data set to cancel the append; for fields with erroneous operations, you can drag them to the correct position or click the minus icon on the field to cancel the append.

Appending fields will exhibit the following behaviors:

Dates and numbers appended to text fields will be converted to text for display.

Text appended to date or number fields will display as a date or number if they can be converted, otherwise will display as null.

Numbers appended to date fields will display as a date if they can be converted, otherwise appending fails with a message that the conversion from integer/number to date is not supported.

Add Filter Conditions

As shown in the image above, you can click Add Data Set Filter Condition in the upper right corner, select a data set, and then add filter conditions.

Filter conditions between data sets are independent, and filter conditions within a data set can be either "and" (all conditions) or "or" (any conditions).

Preview Data

Click Preview Append to display the preview data.

Configure Data Structure

Click next to enter the Data Structure page. You can modify field aliases and select fields to show/hide.

Click save to complete the merging of the data set.