Data Blending
  • 2 Minutes to read
  • Dark
    Light

Data Blending

  • Dark
    Light

Article summary

Data blending integrates data from two data sources based on common identifiers or keys. This approach combines complementary data from different sources to form a single view, similar to the JOIN operator in SQL.

Create a New Data Flow with Blending

  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 over the newly added source for the menu to show and click on Combine.
  4. Select Blend Sources.
  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.
  7. Click on the button between the sources to configure the joining type. Left Join is selected by default.
    1. Left Join: Records from the right source will be joined to the left dataset.
    2. Inner Join: Returns records which values are only matching in both column sources.
  8. Click on Save Source.
  9. Add your data destination, finish configuring your flow, and click on Save Flow.

Data Flows - Click on Combine

Data Flows - Celect Data Combination Method

DATADDO TIP

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

Data blending in app - step 7

Editing a Flow

If changes affecting the database schema are made in the flow (e.g. change in field names, number of columns, data types), go to the database and delete the previously created table. Then, save the changes and refresh.


Troubleshooting

Issue with Repeated Column Names

ERROR MESSAGE
The column name ‘___’ is specified more than once

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

  1. On the Sources page, click on one of the sources you wish to blend
  2. Navigate to the Schema tab, change the name of the affected column to e.g. propertyid_2 and click on Save.

Your data sources can be blended as no column is defined twice anymore.

Data blending in app - FAQ change column name

Duplicated Field

When using data blending, combining columns from two different data sources may result in a duplicated field (such as ID). This can result in a broken flow. Rename one of the two affected columns like in the previous troubleshooting guide.


Was this article helpful?