Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Merge joins

  1. #1
    Join Date
    Jul 2009
    Posts
    7

    Exclamation Merge joins

    Which component can be used to join more than two tables and redirect the output to table output?


    Thanks in advance
    Anitha

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

    Default

    Anitha, to join tables you should use SQL.
    You can join 2 streams of data with the "Merge join" steps. If you need to join more streams... use more "Merge join" steps or use the "Join rows" step.

  3. #3
    Join Date
    Jul 2009
    Posts
    7

    Default

    Hi,

    Thanks for your suggestion. You mean to use the entire sql query in a execute sql component?

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

    Default

    Put the SQL in the "Table Input" step, yes.

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.