Data Union
  • 1 Minute to read
  • Dark
    Light

Data Union

  • Dark
    Light

Article summary

Data union combines datasets from multiple data sources in a single data flow. It operates similarly to the UNION operator in SQL.

Prerequisites

When creating your sources, make sure they have the exact same schemas, including the same:

  • Number of columns
  • Column names/labels
  • Data types

How to Add More Sources to a Single Data Flow

  1. Navigate to the Flows page and click on Create Flow.
  2. Click on Connect Your Data and select the first source.
  3. Hover over the newly added source for the menu to show and click on Combine.
  4. Select Data Union and add as many sources as needed (only compatible ones will be displayed).
  5. Click on Save Source in the top right corner.
  6. Add your data destination, finish configuring your flow, and click on Save Flow.

Data Flows - Click on Combine

Data Flows - Celect Data Combination Method

Troubleshooting

Maximum Amount of Sources

In Dataddo, it is possible to union up to 100 sources. If you need to combine more sources, it will be necessary to create multiple flows.

Different Data Types

To check the data types of your source, click on the three dots, select Edit and navigate to the Data Types tab. If the data types don’t match (like in this example), you can change the data type of each column.

Source 1Data type
Column AFloat
Column BInteger
Source 2Data type
Column AInteger --> change to Float
Column BInteger

Data Sources - change data type


Was this article helpful?

What's Next