Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Insert if new date

  1. #1
    Join Date
    Aug 2007

    Default Insert if new date

    hello to all,
    i extract some stuff from an excel file and put it in a db if the table is empty.
    if the things are already in the db, there is nothing to do for spoon. and if there are some thanges, there is an update to do.

    i use an excel input, then a db lookup to get the rows to filter... but if i want to filter the date for example, spoon never do what i want...

    sorry for may bad english, do somebody understand what i am telling :-/ ??

    please look at the attaced file and tell me what i do wrong...

    best regards
    Attached Files Attached Files

  2. #2



    Why not using Insert/Update step?
    It will check tuple and :
    - Insert if no data
    - Update if data change (if you want)


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.