Combine
Combine two different tables into a unified data set
Last updated
Combine two different tables into a unified data set
Last updated
It's very important to understand how to use the Combine Action if you want to begin working smarter with data. The Combine Action enables you to turn two sets of data into a single unified data set. You do that by selecting the type of Combine you want to use and by pointing to common IDs in each of the two data sets.
The combine function is called a join in SQL and a merge in Python. Watch the video to see a few use cases and read more about combine types below the video.
The inner join combines data sets only when the common ID can be found in both data streams. In the figure, you'll see a visualisation of the inner join. The only record that is present in Table 1 and Table 2 is the record 1. Therefore this is the only one that will be combined in the output table to the right in the visualisation below. Use this type if you only want to output records that are present in both data stream going into the Combine Action.
Left/Right
The left and right type are opposites. In the visualisation below, you'll see a left join. The left join outputs all the records from the left data table (Table 1) independent of whether they can be matched in the right data table (Table 2). The ones that can be matched from the right Table 2 will be present in the output. Below, we can see that record 1 and 2 from Table 2 are both in the output left join table. The yellow columns will be present in the output table due to the fact that record 1 is present in both Table 1 and 2. For record 2, the cells are blank because the record doesn't match with any records in Table 2.
