Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Different actions if a value already exist in my database

  1. #1

    Default Different actions if a value already exist in my database

    Hi!

    I have one table let's say (id, name, price).

    I want to check if a particular id (let say 988) is already present in my table or not

    If it is a must do action_1, but if it isn't I must do action_2

    Ok, I try to use "DBLookup" step, but it can't check if my value is in my table (trace empty)

    Any ideas?
    pdi-ce-4.4.0-stable
    jdk1.7.0_09
    Intel Core I3-2330M@2.2Ghz - 8Go ram
    Windows 7 FEP SP1

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Lookup will return a null value, that you can use in a filter expression of a subsequent "Filter Rows" step.
    So long, and thanks for all the fish.

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.