Join Data Sources

The Join Data Source works like a "left join" in an RDBMS, where the configured data source is the left table, and the joined data source is the right table.
The join will produce a complete set of records by matching data from the configured Data Source, with data in the joined Data Source (if available). If there is no matching data, the right columns will be empty (null values).

A joined data source depends on a match between the Local Key (in the configured Data Source column) and the Remote Key (in the joined Data Source column).

In the following example, Data Source A (configured) has the following columns:

Note: A User Name is a unique entity, while a User Display Name may have more than one associated user.

Data Source A

User Name	User Display Name
John	John Doe
Mike	Mike Miller
Lisa	Lisa B

Data Source B (the joined data source) has the following columns:

Data Source B

User Name Joined	Department
John	Engineering
Mike	Product
Other User	Finance

The joined data source below results from joining Data Source A and Data Source B, Local Key = User Name and Remote Key = User Name Joined:

Joined Data Source

User Name	User Display Name	Department
John	John Doe	Engineering
Mike	Mike Miller	Product
Lisa	Lisa B

The Department value for Lisa is null in Data Source B. Other User is not in Data Source A, and is therefore, not in the joined Data Source.