Data Blending
  • 2 Minutes to read
  • Dark

Data Blending

  • Dark

Article Summary

Data blending allows you to merge two different data sources and add to a single flow.

Create a New Data Flow

  1. Navigate to the Flows page and click on Create Flow in the top right corner.

  2. Click on Connect Your Data and select the first source.

  3. Hover overly the newly added source for the menu to show and click on Combine.
    Data Flows - Click on Combine

  4. Select Blend Sources.
    Data Flows - Celect Data Combination Method

  5. Click on Select Source to choose the sources you wish to blend.

  6. Choose a Join Key that is the same for both sources. Dataddo will blend the datasets based on this particular key.


    Select columns from each source by dragging the fields from the list on the left or right. The columns don't have to be the same for both sources.

    Data blending in app - step 7

  7. Click on the button between the sources to configure the joining type. Left Join is selected by default.

    • Left Join - records from the right source will be joined to the left dataset.
    • Inner Join - returns records which values are only matching in both column sources.
  8. Click on Save Source.

  9. Once the data is configured for blending, add your destination.

  10. Finish your flow's configuration and click on Data Preview to check your data.

    Flow Configuration

    Choose the write mode and rename the flow if needed.
    Keep in mind to set the flow's time with a small delay after the synchronization of your source to allow for the data to load.

  11. Click on Save Flow.

Editing a Flow

If changes that affect the database schema (field name, add/delete column(s), and changing a field data type) are made in the flow, go to the database and delete the previously created table. Afterwards, save the changes and refresh.

Connecting and Configuring a Data Flow

Dataddo will automatically configure BI app destinations. However, for data storages such as warehouses, a manual configuration is needed. For more information on how to connect and configure a data flow to a warehouse, check our detailed guide on creating data flows.


“The column name ‘___’ is specified more than once” Error Message

This problem can be fixed by renaming the affected column in one of the two sources.

Click on the three dots on one of the sources you want to blend and select Edit. Navigate to the Data Types tab, change the name of the affected column to e.g. propertyid_2 and click on Save.

You should now be able to blend your data without one column being defined more than once.

Data blending in app - FAQ change column name

Need assistance?

Feel free to contact us and we will help you with the setup. To speed the process of resolving your issue, make sure you provide us with sufficient information.

Was this article helpful?

What's Next