Skip to Content

Filter out Duplicate records and Unique records seperately

Hi Experts,

I have generated my output with desired result set. My output contains few duplicate records and few unique records, which is correct as per requirement. But final output that I need to achieve is to get only duplicate records onto target template. kindly suggest me what condition can be applied to separate out the duplicate and unique records.

please find attached result set for more understanding of problem.cusersswapnilranedesktopoutput-file.png

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 16, 2017 at 08:34 AM

    Hi Experts,

    Any suggestion on situation please.

    Regards..

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 16, 2017 at 10:27 AM

    Use 2 Query transforms.

    In the first add a column with mapping count(*) and group by on all source columns.

    In the 2nd, filter out all records with count = 1.

    Add comment
    10|10000 characters needed characters exceeded