Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Replace null timestamp fields

  1. #1
    Join Date
    May 2016

    Default Replace null timestamp fields


    I have a transformation that accepts a parameter of a timestamp with time zone default value of '2999-12-31 00:00:00 UTC'.

    A 'table input' selects data, then there is a 'merge join' step using a left outer-join to gather non-required timestamp data to the stream.

    Before the final 'table output' step I need to replace all null timestamp values with the parameter value that was passed in.

    I cannot seem to find a way to do this. The 'if field is null' step seems like the obvious choice, but will only accept a format mask if I first convert the timestamp field to a date using the 'select values' step. However, once I convert to a date I lose the important time components of the data.

    So how would you do this? Any help would be appreciated.

  2. #2
    Join Date
    Jun 2012


    I feel lucky because I don't have any problem to provide a format for a timestamp field.
    Kettle 7.1 used for testing.
    Attached Files Attached Files
    So long, and thanks for all the fish.

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.