# Join properties

Available in...

* Cloud API Services Platform
* Cloud Big Data
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Integration
* Cloud Data Management Platform
* Cloud Pipeline Designer Standard Edition
* Data Fabric

Properties to configure in order to combine your records using Join. You can add as many keys as you want in the processor configuration.

ConfigurationConfiguration

| Property | Configuration |
| --- | --- |
| Join type | Select the desired join type in the list:<br><br><ul> <li> <span>Inner join</span>: use this join type to compare                                 two datasets that have matching column values and list all the                                 resulting pairs. Values that do not match each other are being                                 ignored in the result set.</li> <li> <span>Left outer join</span>: use this option to retain                                 all values of the left dataset in the joined output list. Values                                 that do not match any rows in the right dataset will be listed in                                 the result set as NULL.</li> <li> <span>Right outer join</span>: use this option to combine                                 left and right outer joins. Values that do not match any rows in                                 the left dataset will be listed in the result set as NULL.</li> <li> <span>Full outer join</span>: use this option to combine                                 both left and right outer joins. Every value that has no matching                                 value will be listed in the result set as NULL.</li> </ul><br><br>For more information, see [Additional information about join operations](https://help.qlik.com/talend/en-US/pipeline-designer-processors-guide/Cloud/additional-information-about-join-operations). |
| Merge input records | Enable this option in order to even and group the hierarchical structure<br>of both left and right datasets.<br><br>By default, if you do not enable this<br>option, the left and right datasets will be outputted with the same<br>structure they had before the join operation. |
| Conditions | <ul> <li> <span>Left key</span>: Select or enter the path to the                              existing record in the left dataset. Auto-completion is available                              while typing.</li> <li> <span>Right key</span>: Select or enter the path to the                              existing record in the right dataset. Auto-completion is available                              while typing.</li> </ul> |

InfoInfo

| Property | Configuration |
| --- | --- |
| Description (optional) | Enter a description for the processor. |

To rename the processor, click the ![Rename](https://help.qlik.com/talend/en-US/pipeline-designer-processors-guide/Resources/images/icon-blue_pencil.png) Rename icon next to the default name of the processor.