Hitachi Vantara Pentaho Community Forums
Results 1 to 9 of 9

Thread: Join multiple inputs

  1. #1

    Default Join multiple inputs

    Hi,
    Merge join takes only two inputs. Which step can i use to join multiple inputs???

  2. #2
    Join Date
    Jun 2011
    Posts
    102

    Default

    Hi,
    in PDI 4.2.0 there's a new multi merge join step, you can use that one

  3. #3

    Default

    Thanks a lot!!

  4. #4
    Join Date
    Feb 2011
    Posts
    240

    Default

    Hi,
    I can not find this step. Where is it?

    Thanks

    Mariarita

  5. #5
    Join Date
    Jun 2011
    Posts
    102

    Default

    Currently i'm using PDI 4.1.0, but i think it's under the join folder.

  6. #6
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    It was a late addition to 4.2.0, it's still in the experimental category. Should be working fine though.

  7. #7
    Join Date
    Feb 2011
    Posts
    240

    Default

    I'm using the step "Multiway Merge Join", but there is a ploblem.

    I've two table, "CARTELLA" and "ETA" and I want do the join.

    Then I've this transformation: table input (cartella)
    multiway merge join table output
    table input (eta)

    but when I verify this transformation the error is: This step is not yet verified: not yet implemented.

    Why?

    Thanks
    Mariarita

  8. #8
    Join Date
    Sep 2011
    Posts
    190

    Default

    Aha, now I get it.

    Apparently, the method of VERIFYING the Merge Join step is not yet implemented.
    That's also a warning, not an error.

    That doesn't mean it doesn't run?

    Did you try it? It should run perfectly.

    If you have just two tables, I imagine you can revert back to the regular Merge Join. Make sure both imputs are sorted beforehand.

  9. #9
    Join Date
    Feb 2011
    Posts
    240

    Default

    Ok, thanks very much

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.