Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Multiple tables problem

  1. #1

    Default Multiple tables problem

    Hi all,

    I am using kettle for a simple automation. I have two different tables. Suppose 1 table is having columns Id and Name. 2nd table is having columns Id and salary. The output table should have 3 columns i.e Id,name and salary having the values in which the 1st table.id=2ndtable.id. How kettle can resolve this???

    TIA
    Thanks,
    Sri

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    What steps have you tried using?

    Generally, you will get more responses if you tell people what you are coming from, where you are going to, and what things you have tried.

  3. #3
    Join Date
    Mar 2011
    Posts
    257

    Default

    sounds like a regular join to me....
    so grab the join step or stream lookup step or database lookup.
    or if it's the same database just join them...

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.