Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Issue in Merge Join

  1. #1

    Default Issue in Merge Join

    Hi,

    how to merge two streams in kettle. I need to get values from two streams and pass that values to next step. We have tried using Merge Join,but values from both streams are not coming.

    pls help me to solve tis issue.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    My car broke down, please fix it... First reaction of your garage would be "Show me the car!"

    Without a lot more information you're not going to get help.

    Regards,
    Sven

  3. #3

    Default

    hi,

    Actual problem is, I am getting two output values from one table input step and 5 output from one stream look up step. I need to pass these values together to another step, say Java Script.

    tried with merge join step but getting values only from one step, say table input (while using left outer) .

    attaching the sample kettle file for more details.
    pls help
    Attached Files Attached Files

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    You just put stream lookup in your main stream... no need to merge join those... The fields being returned will be added to the original input row.

    And if you do use merge join, you'd better fill in the dialog of the step: you didn't speciy keys e.g.

    Regards,
    Sven

  5. #5

    Default

    i have tried with stream look up. But that also didn't work.

    graphical view of my kettle is attached.

    pls find attachment..


    pls pls help me.
    Attached Files Attached Files

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.