Pages

Sunday, March 17, 2013

How to separate the duplicate in 1 target and unique only to another target


I/P:
1|Piyush|Patra|
2|Somendra|Mohanthy
3|Santhosh|bishoyi
1|Piyush|Patra|
2|Somendra|Mohanthy

O/P:
File1
1|Piyush|Patra|
2|Somendra|Mohanthy
File2
3|Santhosh|bishoyi

Solution: 

This can be done this the help of Aggregator.
Group by the columns on which you want to decide duplicate or unique
Port
Expression
Group by
ID

Yes
FName

 Yes
LName

 Yes
Countcount(id) 
 
Use router to split the duplicate and unique 
Group Name
Group Filter Condition
Duplicate
count>1
Default


No comments:

Post a Comment