Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Insert if new date

  1. #1
    Join Date
    Aug 2007
    Posts
    25

    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
    f
    Attached Files Attached Files

  2. #2

    Default

    hello,

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

    Rgds

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.