Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Denormaliser step convert string to data faild

  1. #1

    Default Denormaliser step convert string to data faild

    Hi All

    When I test the Denormaliser step, It failed. the reason is convert to convert to value String(8) : couldn't convert string [19690214] to a date using format [yyyy/MM/dd HH:mm:ss.SSS] on offset location 8

    But i set the format is yyyyMMdd. why it does not work.

    I attached the transformation for you reference

    Test ENV

    Windows 7
    Kettle 5.0.1 CE
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2012


    You witness a bug that is fixed in Kettle 5.1
    As a workaround you can denormalize as String and use Select-Values to convert from String to Date.
    So long, and thanks for all the fish.

  3. #3


    Thanks, I know i can use the select - value step to handle it. but i want to know whether It's a bug for the step.

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.