Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to execute a SQL function on a column before interting

  1. #1
    Join Date
    Apr 2007
    Posts
    6

    Default How to execute a SQL function on a column before interting

    Hello,

    Simple transformation Text file input to Neoview table and I want to apply a function call before insert.
    a.The example is a time stamp field Expiration date, data is 9999-12-31 23:59:59,
    b.The only way is to execute SQL function on the column:
    i.timestamp ‘9999-12-31 23:59:59’ b4 inserting into the HP-Neoview table
    c.Can it done, and how?

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    put an "add constant" step between text input and insert step

    Regards,
    Sven

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.