Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: How to the Unique rows

  1. #1

    Default How to the Unique rows

    Hi,

    Thanks in Advance. Can any one help me.

    I have passed 100 rows with duplicate to sort step and then unique row step to remove the duplicates.
    But i getting the result with duplicate.

    I has been attached my ktr with this. please guide me.


    Regards
    Naren
    Attached Files Attached Files

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

    Default

    And for the sample .xls file ...

    Regards,
    Sven

  3. #3

    Default How to the Unique rows

    Hi sven,

    I have attached the sample.xls.please find the attachment.


    Regards
    Naren
    Attached Files Attached Files
    Last edited by Naren1984; 11-22-2008 at 02:12 AM.

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

    Default

    1) Only 1 one of tabs of the select values per step... if you want to select&alter and remove ... use 2 select values step

    2) for the rest all looks ok to me... which in your sample excel file are duplicates which should be erased according to you... the way you set it up PDI compares the whole row and if one field is different it's considered a different row.

    Regards,
    Sven

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.