Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Cut rows

  1. #1

    Default Cut rows

    hello forum,

    i have a question, pls

    Is it possible to cut the rows which have not the lowest price with a transformation-step ?
    The task is to show only the lowest price by productnumber. (only one row) (please find enclosed an example)

    best regards,

    Bernett22


    Name:  clip.jpg
Views: 16
Size:  20.6 KB

  2. #2
    Join Date
    Sep 2013
    Posts
    235

    Default

    Why don't sort all rows ASC/DESC by price and shows last/first one?

  3. #3

    Default

    i sort the productnumber field and price field. After that i tried it with the group-step. Thank you

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.