Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Error conversion date and/or time conversion when running transformation

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Jun 2017
    Posts
    25

    Default Error conversion date and/or time conversion when running transformation

    Greetings,

    I got a transformation which will create a text file from a table.
    the query got a where condition between 2 datetime; a datetime from a textfile properties lastmodifiedtime and a datetime using sysdatetime()

    Name:  Capture.jpg
Views: 44
Size:  7.9 KB
    this is the transformation. i get the file properties using get file name and pass the selected value using select value step and get the value to result using copy row to result step. is this step correct to get pass value to query?

    Name:  Capture1.PNG
Views: 42
Size:  15.5 KB
    the query, is the query correct for passing value from the textfile properties?

    attached below is the transformation for review.
    createTextFile.ktr

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

    Default

    You forgot to specify the input step in the Table-Input settings.
    Also, you might want to choose an explicit character encoding in Text-File-Output.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Feb 2017
    Posts
    13

    Default

    Remove copy rows to the result and in table input, you should specify the value as "select values" in "insert data from step" drop down. In the output file its good to specify the format for the timestamp fields.

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.