Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: How to sort data and load only first 5 max?

  1. #1

    Default How to sort data and load only first 5 max?

    Hi all,

    I am loading data from a XML file to Database. In that I want to load only first five ranked data into a table and rest I need to reject.
    In my situation, I have a column called points. I am using Sort row to order the rows. From here I want to take only the top five data or first five maximum points to load.
    How to achieve it? Please help.

    Thanks,
    Darius

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Add an "add sequence" after your sort and then a filter outputting only stuff where sequence number < 6... It wastes a bit of resources but it does work.

    Regards,
    Sven

  3. #3

    Default

    Thanks, Its working.


    Darius

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.