Nicci - When you use the Merge/Join block, the values in defined fields in both left and right incoming data sets are compared, and you can keep rows containing only the matches, or the unmatched records from either side, or all the rows in the output. By default, it is keeping all the rows, so the row count will be the larger of the two sides, in this case 3,376.

Try excluding the un-matched records.

There are useful videos explaining most major operations, Merge/Join is here:

http://tc.visokio.com/videos/?name=DataManagerMergeJoin&title=Merge%2Fjoin&lang=gb

I understand and many thanks for the video much much appreciate that effort!
What I don't understand is that In my result i see value from both data source, but in the design it shows as if I am only getting data from on source, why does that happen? So does that means the by default the row count will always be the larger value among the other selection??

Sorry for a big summary, I'm relativerly new to omniscope and don't have much office guidance.

Think I got some answer to why numbers are same from left join watched the video for 2times and its the selection between 1:1 and 1:many join, Am I correct in thinking ??

Hi Nicci,

I don't fully understand what you are doing here, but I'm happy to arrange a screen share if you still need help here. I've send you a private email, so please respond if you would like to proceed.