# Join datasets

The Join step allows you to combine two datasets listed in the dataHub to bring columns from the former into the latter, matching rows based `on` columns correspondance

### Step parameters

* `Select a dataset to join (as a right dataset)` **column(string)\***: Select a dataset to join as the right dataset.
* `Select a join Type` **dropdown(string)\***`:` Choose from "left", "inner", or "left outer" join.
  * `left`: will keep every row of the current dataset and fill unmatched rows with `null` values,
  * `left outer` :
  * `inner`: will only keep rows that match rows of the joined dataset.
* `Join based on columns:`specify 1 or more column couple(s) that will be compared to determine rows correspondance between the 2 datasets. The first element of a couple is for the current dataset column, and the second for the corresponding column in the right dataset to be joined. If you specify more than 1 couple, the matching rows will be those that find a correspondance between the 2 datasets for every column couple specified (logical ‘AND’).

### Example

**Input**

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-909ae975ce9b8b5f0016179e9d3af0541c16800d%2Fcombine_join_1.png?alt=media" alt=""><figcaption><p>Combine - join - dataset_to_join</p></figcaption></figure>

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-859f9caa0c8ab0e74b900f0e1727c1d2ad390e77%2Fcombine_join_right.png?alt=media" alt=""><figcaption><p>Combine - join - dataset_to_join</p></figcaption></figure>

**Configuration**

```json
{
    "right_pipeline": "dataset_to_join",
    "type": "left",
    "on": [
        {
            "id": "emp_id"
        }
    ]
}
```

**Output**

<figure><img src="https://1809014303-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZxYYf1KpgarKMgMsDCrw%2Fuploads%2Fgit-blob-1db065670f9112c9f05b98e1361b8eef9bdb655d%2Fcombine_join_result.png?alt=media" alt=""><figcaption><p>Combine - join output</p></figcaption></figure>
