Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Lookup/retrieve value that needs GROUP BY in the database

  1. #1
    Join Date
    Dec 2010
    Posts
    16

    Default Lookup/retrieve value that needs GROUP BY in the database

    Hi, If I need to lookup a value that needs a GROUP BY or similar constructs in SQL, what is the best way of doing that? The Lookup steps do not seem to have options for anything but the simplest select and the SQL script step cannot seem to return values to the stream.

    Any suggestions/ideas are greatly appreciated!

  2. #2
    Join Date
    Nov 2008
    Posts
    271

    Default

    Hi,
    a couple of alternatives, according to your needs:

    1) database join step: you can submit a complex query and lookup values according to a list of parameters coming from previous steps.
    2) table input with a select...group by statement -> Stream lookup step

    HTH
    Andrea Torre
    twitter: @andtorg

    join the community on ##pentaho - a freenode irc channel

  3. #3
    Join Date
    Dec 2010
    Posts
    16

    Default

    Ah, I totally missed these. The database join step works perfectly for what I need. Thanks a lot Ato!

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.