Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Primary key validation

  1. #1

    Default Primary key validation

    hello,

    is it possible to make validation on source values is it is replicated or not

    i have source file and wana move it to destination table with field primary key

    and i wana to make check before moving data if there were duplicate keys


    i checked data validation step , but i didn't find option to check on duplicate values

    is it possible or not?? and how to do it if it was possible??

    thanks in advance

    waiting a reply

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

    Default

    Unique Rows (from transforms) with counter field switched on, or a group by step... then you can filter on the counter being > 1... those were duplicate e.g.

    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.