Union

The Union function combines data from two or more sources into a single dataset. It works like the SQL UNION operator, where the result sets of multiple SELECT statements are merged.

This is useful when you have similar data in different tables or files and want to combine them for analysis or processing.

Note: The combined columns should have the same structure (i.e., same number of columns and matching data types).

How to use Union?

Step 1: Connect the union to two or more data sources.

Step 2: The user can choose between “True” and “False” for the “Distinct” option.

• True: The user desires all the different elements in the result.
• False: When users are comfortable with repeating elements in the result.

Also, based on the user’s needs, determine whether the user wants to prioritize the top or bottom table.

Step 3: Fetch the columns and add them. Input the details according to the data type.

The user can perform the matching by name or position.

Step 4: Run the graph to get the output.

For example:

• We are using two Excel files: Retail and Sales Order.
• Matching is performed between both files based on their name and positions.
• We opted for distinct values, setting it to “TRUE,” and merged the data of the two files using the Union transformation.

Preview