Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Merge Join Problem!!!

  1. #1

    Default Merge Join Problem!!!

    Hello all,

    I am new to this ETL tool... I am working with Kettle - Spoon 3.0.2

    I am trying to merge two data base tables(inner join) using Merge Join tool... And from that merge Join i am directing that to another new database table.

    The problem that I am facing is that the resulting table contains the duplicate entry of the join criteria...

    lets say I have 'eid' on table A and same 'eid' on another table B.... I am joining these tables A and B... The resulting table C will contain duplicate columns 'eid' and 'eid_1'

    I want to avoid this.... That is, i need only one 'eid' column in the resulting table....

    Please help me out.... If there are any methods to do that please let me know....

    Thanks in advance...

    Deepak S

  2. #2

    Default

    Use a Select values step after the Merge join. Select all fields but the eid_1.

  3. #3

    Default

    Yeah seems about right, make sure both your input fields are sorted as well.

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  4. #4

    Default

    Use a Select values step after the Merge join. Select all fields but the eid_1.
    Wow..... that a great piece of help....

    Thanks a lot.... I got what i required....

    Thanks for all those who have replyed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.