Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pentaho partial updating columns

  1. #1
    Join Date
    Feb 2017
    Posts
    4

    Default Pentaho partial updating columns

    how to update a single column while other columns are already inserted in a table in pentaho. Using Insert / Update step is not working as it is checking the existing inserted columns which should not be verified in my case

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    You want only null columns to be updated?

    One way to go would be to compare field by field, building an update statement in the process, which can be handed to an Execute-Row-SQL-Script step, then.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Feb 2017
    Posts
    4

    Default

    Thank you, now column is updated by using "Update" step with conditions.

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.