Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Update to Null

  1. #1

    Default Update to Null

    Hi,

    I tried searching for this in the forum without success.

    Based on certain conditions, I need to "unset" (update to null) a flag in a table. This flag field is of type date. If a date is present, it means the record has been processed, if it's null, means it's not. On some cases I need to unset this back to null, but I don't know how to do this with the Update step.

    I could of course do it with an Execute SQL statement but I guess this will be way slower than a plain Update. I'm using PDI v3.2 at the moment.

    Any ideas?

    Thanks,

    --
    Julio.

  2. #2
    Join Date
    Nov 2008
    Posts
    143

    Default

    Have you tried Null if...?

  3. #3

    Default

    Thanks for the tip, I'll try that.

Tags for this Thread

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.