Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Database lookup from rowset

  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Default Database lookup from rowset

    Hi to all,
    I need to execute a query on a table and the parameter in the WHERE clause comes from a rowset created with a Copy to Rowset object.
    E.g.: select attribute_name, attribute_value from users_attributes where user_id = <rowset element>
    Which object can I use after the Get Rows from result?
    I've tried with the Database lookup but the result is a row for each user even if the table contains more than one record for each user.
    Any suggestions?
    Thanks in advance

    Claudio

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

    Default

    Database Lookup uses only a single row from a lookup table - that's by design.
    Use Database Join to consider the whole matching set.
    So long, and thanks for all the fish.

  3. #3
    Join Date
    Nov 2013
    Posts
    2

    Default

    ThankYou so much.
    I've used Database Join and it works as expected.

    Thank You once again

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.