Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Merge Row (diff) problems

  1. #1
    Join Date
    Jan 2014
    Posts
    6

    Default Merge Row (diff) problems

    I have 2 files. one has 2 columns, the other has 4 since it has additional data. The merge row diff is complaining about the extra rows. I know if they have the same it works fine, but for this ETL I need additional fields in one that is not available in other. Any ideas would be very much appreciated. Using a older 4.1 Spoon due to that is what the vendor gives me.

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

    Default

    Merge Row is for taking two of the same set of data and comparing them, based on their keys.

    So you need to make your data look the same.
    Use an add constants step to add null columns of the same type that file2 has to file1's data. Then you can do a diff on the keys.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

Tags for this Thread

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.