Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Insert Date

  1. #1
    Join Date
    Mar 2008

    Default Insert Date

    When I import a file using File Input to insert data in a target table, I would like to also insert the system date for each record to know when my data were inserted. How could I make it with kettle ?

  2. #2


    use the get system info step
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(

  3. #3
    Join Date
    Mar 2008

    Thumbs up

    That's what I've tried. But I put it at the very beginning of my transformation and I couldn't access this information when I tried to make my mapping. I declare another get system info step just before my mapping and now it's OK.
    Thanks a lot

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.