The Blended Connectors feature in Dataslayer allows users to merge data from multiple sources with different structures. These are the join configuration options available in the Blended Connectors and how to use them effectively.
This section is accessible via a button located between two tables in a Blended Connector, designed to configure the type of join you need.
Join Operator
The join operator determines how rows from all the tables on the left side are merged with the table on the right side. Dataslayer offers five types of join operators:
- Left Outer Join: Includes all records from the table on the left and the matched records from the table on the right. If there is no match, the result is an empty string or 0 on the right side.
- Right Outer Join: Includes all records from the table on the right and the matched records from the table on the left. If there is no match, the result is an empty string or 0 on the left side.
- Inner Join: Includes only records that have matches in both tables. This is the default join type selected, ensuring that only the intersecting data from both tables are merged.
- Full Outer Join: Includes all records when there is a match in one of the tables. This means all records from both the left and the right tables are included, with an empty string or 0 in places where the join condition is not met.
- Cross Join: Includes all combinations of rows from the left table with all rows from the right table. This join type does not require a join condition.
Join Condition
The join condition specifies the criteria used to match rows between the two tables, typically using one or more columns that the tables have in common. Here is how you can set it up:
- Add Field (Table 1): Select the parameter from the first table that you want to use for the join condition.
- Add Field (Table 2): Select the corresponding parameter from the second table to complete the join condition.
If necessary, you can add more fields to refine the join condition further:
Once you have configured the join operator and conditions according to your needs, click the Save button to apply the settings.
As always, please contact us via our live chat on our website or via email if you still have doubts or questions. We are happy to help!