Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: sql Join

  1. #1
    Join Date
    Nov 2014
    Posts
    1

    Default sql Join

    Hi all,
    I have a need to run some sql with more than one table, which can pick parameters out of the stream and return results.
    I know I can do multiple lookups but if one of the lookups return multiple records, the number of rows in the stream would increase... which I cant do.
    I looked at sql script but that does not look like it returns results.
    I am kind of new and so looking for any ideas.
    Thanks

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by Jonnet View Post
    but if one of the lookups return multiple records, the number of rows in the stream would increase... which I cant do.
    Try setting the "Error on Multiple Rows" on your lookups.

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.