Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: query result search with input data

  1. #1
    Join Date
    Sep 2015

    Default query result search with input data

    My friends

    I'm trying to do a search on a result of a query. this search is a input from an excel file and just had one row with a lot of numbers.
    so what I need is ask on this search if A = B bring me all the data from the query but if A <> B bring me just the A value. I try with stream look up but only gives me de identicall and unique value. my query bring a lot of "one to any (1-n) information. i attach what i have I hope you can help me.Name:  shet.jpg
Views: 33
Size:  10.9 KB


  2. #2
    Join Date
    Oct 2013


    Try to Use Merge Rows(Diff) step...
    -- NITIN --

  3. #3
    Join Date
    Apr 2008


    You sound like you're trying to do a DB lookup... Retrieving values from a Database when values match, and retrieving nothing when they don't match.

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.