Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Database Lookup - Implied Conditionals?

  1. #1
    Join Date
    Aug 2010
    Posts
    8

    Question Database Lookup - Implied Conditionals?

    Hello All,
    In Database Lookup step, where I can add keys to lookup I see:
    Table Field , Comparator , Field 1 , Field 2

    What is there both Field1 and Field2? Is there an implied conditional there if I fill in both?

    Also, what happens when I add multiple rows, is that too an implied conditional?

    Thanks!
    -Brett

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi Brett,

    the BETWEEN comparator requires 2 fields... For the other comparators the second field is not used.
    Multiple conditions are implicitly ANDed as far as I know, so all must be true for the lookup to succeed

    Cheers

    Slawo

Tags for this Thread

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.