Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Insert/Update step: list of updated and inserted rows

  1. #1
    Join Date
    Mar 2012

    Default Insert/Update step: list of updated and inserted rows

    I am using the Insert/Update step and I was wondering if there was any way to determine which of the lookup keys had been either inserted or updated in order to enable further processing based on this information.
    I know I get the counts from the debug log but that isn't sufficient for my purpose.

  2. #2
    Join Date
    Apr 2012


    I would like to have similar output from the Insert / Update step.

    I am trying to further process the rows whose look up values matched AND update fields updated.

    For example: If JobId = JobIdRisingTide AND JobStatusId <> JobStatus, then the Table field: JobStatusId will be updated with the Stream field. I would like to capture either of the two look up values from the output of the step. Not sure if this is possible though.

    Any advice would be greatly appreciated.


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 - 2017 Pentaho Corporation. All Rights Reserved.