Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Insert Date

  1. #1
    Join Date
    Mar 2008
    Posts
    12

    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

    Default

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

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net 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(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3
    Join Date
    Mar 2008
    Posts
    12

    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.