# Non-Matched Port in ExtMergeJoin

**URL:** <https://forum.cloverdx.com/t/non-matched-port-in-extmergejoin/673>\
**Category:** CloverDX Platform\
**Created:** [March 9, 2010, 12:00am UTC](https://forum.cloverdx.com/t/non-matched-port-in-extmergejoin/673 "2010-03-09T00:00:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mkutti](https://avatars.discourse-cdn.com/v4/letter/m/a88e4f/32.png) [@mkutti](https://forum.cloverdx.com/u/mkutti)\
**Post date:** [March 9, 2010, 12:00am UTC](https://forum.cloverdx.com/t/non-matched-port-in-extmergejoin/673/1 "2010-03-09T00:00:00Z")

</div>

I could not locate the port for non-matched master data records in ExtMergeJoin and ExtHashJoin. Please help. Thank you.

Chapt 39 States - ApproximativeJoin, ExtHashJoin, and ExtMergeJoin have output ports also for nonmatched master data  
records. ApproximativeJoin have output ports for nonmatched both master and slave data records.

---

<div class="post-metadata">

**Author:** ![twaller](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@twaller](https://forum.cloverdx.com/u/twaller)\
**Post date:** [March 9, 2010, 9:14am UTC](https://forum.cloverdx.com/t/non-matched-port-in-extmergejoin/673/2 "2010-03-09T09:14:18Z")

</div>

Hello,

This is my mistake.

ApproximativeJoin has output port 2 for non-matched master records, output port 3 for non-matched slave records. Ports 0 and 1 for transformed records.  
DBJoin and LookupJoin have output port 1 for non-matched master records. Port 0 is for transformed records.  
ExtHashJoin and ExtMergeJoin have only a single port (port 0) for transformed records.

I created a feature request for non-matched master port for ExtHashJoin and ExtMergeJoin.  
[http://bug.cloveretl.org/view.php?id=3017](http://bug.cloveretl.org/view.php?id=3017)

Best regards,

Tomas Waller