Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Compare two streams and update one

  1. #1

    Default Compare two streams and update one

    Hello everyone! I am new here, so take it easy

    Here is my situation... I have two streams with the same structure (columns) but different values, one coming from a database and other coming from a webservice (updated data). I would like to check if there is some difference between its rows, if so, I want to send the updated data (that one coming from the webservice) to a table output, but only the rows with different value.

    Do I made myself clear?

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

    Default

    So sort them on the data keys, and send them to a "Merge Join" step
    That step will identify which rows are new, which ones are changed, and which ones are deleted.

    You could filter out the deleted rows, and send everything else to "Synchronize after merge" which will do the Insert or Update for you.

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.