Union

Introduction

Functions

Union is to integrate two similar data forms into one form.

Application Scenarios

Union is mainly used to integrate data whose structure is almost same.

When you summary students’ grades, you can integrate all classes’ grades data into one form through Union in Data Factory. By doing so, you can further analyze data like grade ranking, grade average, and number of disqualified students.

Preview

The following picture shows data after Union:

Setting Procedure

Creating a Data Stream

Click App Management, go to Data Factory, and click New Data Stream.

Choosing a Data Source

Rename the data streams, add 2 Input nodes, and choose the Student Scores-Class 1 and Student Scores-Class 2 forms as input data source.

Setting a Union

Add data processing nodes Union and connect the 2 data source forms to the Union node separately.

After finishing connection, the system will automatically integrate data whose field names and types are same into one column. Fields with different names need to be integrated manually.

Renaming Fields

You can rename integrated fields after Union. Click the field name, then you can rename it into the field name of another form quickly.

Sorting Fields

You can sort integrated data directly by drag and drop.

Renaming Nodes

In order to better mark calculation rules of every data processing step in data streams, you can rename data streams nodes.

Data Preview

Click Data Preview, you can preview the integrated form.

Outputting Data

If you need to further calculate after Union, you can add other data processing nodes. After finishing processing, you need to connect the node with Output node and Click Save.

Demonstration

You can show data that has been processed in Data Streams in Dashboard.

You can also enable Sync output table data into forms to make a backup. For details, see How to Use an Output Table.

Notes