Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: File Compare Operation

  1. #1

    Default File Compare Operation

    Hi,

    I have two files A and B. A is Old file and B is new file. I want to implement a compare file logic while comparing old file A with new file B. If new row is inserted then it should show 'Inserted', If row updated then it should show 'Updated'.

    Any ideas?

    Thanks,
    VJ

  2. #2
    Join Date
    Sep 2007
    Posts
    834

    Default

    you have to use the Joins --> Merge Rows (diff.) step
    You specify the old stream (file in this case), the new, and the fields that should be used for comparing. A new field (flag) will tell you if the row is identical, or if it was inserted, deleted or updated.

    BTW this step is explained in one of the recipes of Chapter 6 of Pentaho Data Integration 4 Cookbook (coming soon).
    Thanks for helping with the marketing campaign

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.