Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Insert/Update

  1. #1
    Join Date
    Mar 2012
    Posts
    4

    Default Insert/Update

    hi i have a table for which i am using table input and to get output i am using insert/update but the problem is it will only inert or update and if any modifications are happened from table input like any data deleted the same actions wont be performed in insert/update as it will only insert or update. I tried merge rows diff but it will take two table.

    Can anyone suggest how to proceed.

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    Use 2 input streams, one with the new table input and another with the file that must be inserte/update/delete.
    Use a "Merge rows (diff)" step to join thaso two steps
    Filter the result with flagfield = deleted
    When true sent to a delete step
    When false sent to update/inserte step

  3. #3
    Join Date
    Mar 2012
    Posts
    4

    Default

    i am not getting which to pass as the 2 stream for merge rows diff. please suggest me

  4. #4
    Join Date
    Nov 2009
    Posts
    688

    Default

    I inserted a little sample. I hope that wil help you

    Greetz
    Attached Files Attached Files

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.