Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Join tables

  1. #1
    Join Date
    Feb 2011
    Posts
    240

    Default Join tables

    Hi,

    I've some tables (ie 4 tables) and I want to perform the join between these tables.
    I'm using PDI 4.2.0. What step can I use?

    Thanks
    Mariarita

  2. #2
    Join Date
    Sep 2011
    Posts
    190

    Default

    Depends a bit on what you're trying to achieve.

    Steps that are called 'Join' are a good candidate, wouldn't you say? Merge Join for example. Or Stream Lookup?

  3. #3
    Join Date
    Feb 2011
    Posts
    240

    Default

    I've used Merge Join but I've an error: This step has not yet checked: not yet implemented.

  4. #4
    Join Date
    Sep 2011
    Posts
    190

    Default

    Strange, I just gave Merge Join a try and it works in my environment. I have PDI 4.1.0 in Windows...

    Any other takers...?

  5. #5

    Default

    Merge join step is usually the way forward. Like mbvt said, it depends on what you are trying to achieve.
    Sort your stream first prior to joining.
    Start simple. Merge join 2 tables first. Do a preview or check its output (in excel). If it is as you expect, then continue with the remaining two.

    Regards.

  6. #6
    Join Date
    Feb 2011
    Posts
    240

    Default

    Then I've two table input: "cartella" and "eta".
    I want do a join, then I use the step "Merge Join": First step: cartella
    Second step:eta
    Join type: inner
    First step Key: CARTELLA
    Second step key: N_CARTELLA

    In Sql of table input I've added "ORDER BY CARTELLA"
    Finally I've the table output.
    What is the error?

    Thanks
    Mariarita

  7. #7
    Join Date
    Feb 2009
    Posts
    321

    Default

    sorry, but perhaps could you use "database lookup" and enable the option "change number of copy to start".
    In this way, my work runs in only 11 sec (before: 87 sec, "using stream lookups")

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.