Contents x
    Data Blending
    • 2 Minutes to read
    • Dark
      Light
    Contents

    Data Blending

    • 2 Minutes to read
    • 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?
    What's Next