Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Merge Rows (diff) question

  1. #1
    Join Date
    Oct 2014
    Posts
    7

    Default Merge Rows (diff) question

    Merge Rows (diff) works great for finding new and deleted rows, but I'm having trouble with the changed rows. My tables have 12 fields that I compare on. If a specific field is changed, I need to insert a new record and update the old one with a new timestamp. If the change was to anything except the one field, I just update the row. What is the best way to figure out which field was changed so I can send it to the proper steps to update/Insert correctly?

  2. #2

    Default

    In your data one field should be unique so that you can check that field with old one if this thing happened again then nothing will change if something change with same field then automatically updated with that field .All these facility is available in insert and update component.

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.