Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Can I merge uneven columns?

  1. #1
    Join Date
    Oct 2008
    Posts
    28

    Unhappy Can I merge uneven columns?

    If I have 2 database table with a common key, how do I go about joining the 2 table together (un-even fields). What steps do I use?

    Table 1:
    ID, Name, DOB
    123,John Smith, 1/1/70

    Table 2:
    ID, First Name, Last Name, Address
    123,John,Smith,1190 Acadia Lane

    Needed result
    ID, Name, DOB, First Name, Last Name, Address
    123,John Smith, 1/1/70, John, Smith, 1190 Acadia Lane

    Thx for any help

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

    Default

    Join on ID... I don't see the problem. The keys need to be the same, the rest of the columns can be whatever they want to be.

    Regards,
    Sven

  3. #3
    Join Date
    Oct 2008
    Posts
    28

    Default

    Stream Lookup or DB Lookup did the trick, thx

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.