Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: order by in DB lookup step

  1. #1
    Join Date
    Mar 2010
    Posts
    159

    Question order by in DB lookup step

    When I have multiple rows returned from DB lookup I can populate ORDER BY in the dialog to select a single row from multiple returned.

    A couple of questions that I will answer experimentally if nobody has quick answer.

    Can you use ASC and DESC in this entry to alter the ordering?

    Does it take the first row or the last row once they've been ordered?

    Regards,
    Jeremy

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Yes you can add ASC/DESC.
    It takes the first row.

    It allows you to pick the "best", "worst" and so on based on some metric.

  3. #3
    Join Date
    Mar 2010
    Posts
    159

    Default

    Great, thanks much Matt! - just what I need.

    Regards,
    Jeremy

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.