Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: how to join 2 rows?

  1. #1
    Join Date
    Oct 2012
    Posts
    116

    Default how to join 2 rows?

    Hi.
    I have got 2 Access files.
    File A contains one table:
    Name Surname Age Sex
    Peter XXX YYY ZZZ

    File B contains one table:
    Height Weight Eye color Hair color
    AAA CCC DDD FFF

    I need to join these 2 tables into the one table.
    Name Surname Age Sex Height Weight Eye color Hair COlor
    Peter XXX YYY ZZZ AAA CCC DDD FFF


    How to do it?
    Thanks a lot

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Find the join criterion, sort the rows, do a Merge Join.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Oct 2012
    Posts
    116

    Default

    There is a problem that there is no key. If I use merge join and full outer it looks like:
    Name Surname Age Sex Height Weight Eye color Hair COlor
    Peter XXX YYY ZZZ
    AAA CCC DDD FFF


    I just need to put one table after the last columns of the second table regardless what is in these tables.

  4. #4
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    So your key is the rownumber - use an Add Sequence step to provide it.
    So long, and thanks for all the fish.

  5. #5
    Join Date
    Oct 2012
    Posts
    116

    Default

    Thank you very much. It works great

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.