# Join and keep unmatched[¶](https://www.dataiku.com/product/plugins/join-and-keep-unmatched/)

## This plugin provides a recipe to join two datasets and produce three outputs: the inner join, unmatched rows from the first dataset, unmatched rows from the second dataset.⚠️ Starting with DSS version 11.3 this plugin is considered "deprecated", we recommend using the native join unmatched feature instead.[¶](https://www.dataiku.com/product/plugins/join-and-keep-unmatched/)

## Plugin information[¶](https://www.dataiku.com/product/plugins/join-and-keep-unmatched/)

|  |  |

| --- | --- |

| Version | 1.0.1 |

| Author | Dataiku (Kasim Patel) |

| Released | 2019-01-22 |

| Last updated | 2023-02-01 |

| License | MIT License |

| Source code | Github |

| Reporting issues | Github |

**⚠️ Starting with DSS version 11.3 this plugin is considered “deprecated”, we recommend using the native join unmatched feature instead.**

This plugin only works with DSS version 7.0.2+

## Details[¶](https://www.dataiku.com/product/plugins/join-and-keep-unmatched/)

Note that this plugin generates SQL and is thus limited to SQL datasets (filesystem datasets not supported).

### Install In DSS[¶](https://www.dataiku.com/product/plugins/join-and-keep-unmatched/)

To install the plugin, open the  Apps menu, click Plugins and search for Join and keep unmatched.

Alternatively, you can download a zipped version here.
