Skip to main content
Union

Walk you through the basics of the union function

Updated over a week ago

What is the Union Function?

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


When to Use the Union Function?

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

When you summarise 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.


What Does It Look Like?

The following picture shows data after Union:


How to Set up?

Step 1 Creating a Data Stream

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

Step 2 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 sources.

Step 3 Setting a Union

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

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

Step 4 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.

Step 5 Sorting Fields

You can sort integrated data directly by drag and drop.

Step 6 Renaming Nodes

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

Step 7 Data Preview

Click Data Preview, you can preview the integrated form.

Step 8 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 to the 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.


More to Know

  • One Union node needs at least 2 and at most 10 data source forms to finish integration.

  • You can add multi Union nodes if data source forms are more than 10.

  • Union is vertical integration, which means you can only integrate fields of the same type. Different types of fields can not be integrated.


I have finished reading. 🏆

👉I can't wait to Try for myself.

👉I need more HELP in Discord Forum.

Did this answer your question?