Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Multiway merge join help me

  1. #1
    Join Date
    Dec 2016
    Posts
    3

    Default Multiway merge join help me

    File A have column: id, no, year, cbc, ua, xray
    File B have column: id, no, year, result_cbc, result_ua, result_xray

    I want join to new file >> id, no, year, cbc, ua, xray, result_cbc, result_ua, result_xray

    I run but it's wrong. New excel file have 7 rows why??? Multiway merge join


    Name:  1.jpg
Views: 273
Size:  28.4 KB
    Name:  2.jpg
Views: 195
Size:  30.1 KB

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

    Default

    Advice: Don't use Multiway-Merge-Join when Merge-Join is able to do the job.

    If you need more help, attach sample data with your transformation, so we can rule out user errors.
    Generally, screenshots are not very helpful if not meticulously prepared.

    BTW: Calculator gave me 42 as a result once and I still wonder why - looks like the same kind of problem.
    So long, and thanks for all the fish.

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.