Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Database Value Lookup with dates

  1. #1

    Post Database Value Lookup with dates

    Dear Kettle experts,

    I'm using a "Database Value Lookup" in one of my transformations. The keys for looking up the value are one ID (numeric) and two dates like:
    start_date <= date
    end_date >= date

    Unfortunately, I don't get back any values. Does someone know, how the lookup step is comparing date values (as dates or as strings)?


  2. #2


    Problem solved, there was an issue with the test data.

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.