Skip to Content
0

Filter out Duplicate records and Unique records seperately

Aug 11, 2017 at 08:49 AM

84

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Aug 16, 2017 at 08:34 AM
0

Hi Experts,

Any suggestion on situation please.

Regards..

Share
10 |10000 characters needed characters left characters exceeded
Dirk Venken
Aug 16, 2017 at 10:27 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded