Capturing duplicates
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 104
- Joined: Thu Jul 12, 2007 11:32 pm
- Location: Canada
Capturing duplicates
Hi,
I have an requirement where in if my source file is having duplicates, i need to capture all the duplicates and load into another table.
for ex:
101,test,austraila
101,test,austraila
202,test1,india
I need to capture both first two records and load into a table.
I have done it through the sort and filter stage, but in this one record is going to one link and other to another link.
Can anyone please suggest on how to proceed on this.
I have an requirement where in if my source file is having duplicates, i need to capture all the duplicates and load into another table.
for ex:
101,test,austraila
101,test,austraila
202,test1,india
I need to capture both first two records and load into a table.
I have done it through the sort and filter stage, but in this one record is going to one link and other to another link.
Can anyone please suggest on how to proceed on this.
Depending upon what you want to do there are several stages and methods available to you.
It is not quite clear from your description what you want to achieve. In your example, the "101" row is duplicated. Do you want both records to go down one link, or the first to go down one link and subsequent duplicates to go another path?
It is not quite clear from your description what you want to achieve. In your example, the "101" row is duplicated. Do you want both records to go down one link, or the first to go down one link and subsequent duplicates to go another path?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 104
- Joined: Thu Jul 12, 2007 11:32 pm
- Location: Canada
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 284
- Joined: Fri Oct 13, 2006 4:31 am
Re: Capturing duplicates
Hi,
take sort stage set properties like allow duplicates=T,
creatate key change column=T,
in filter u can write conditions like
whre creatate keychange cloumn=0---->to capture duplicate records
where creatate keychange cloumn=1---->to capture unique records
take sort stage set properties like allow duplicates=T,
creatate key change column=T,
in filter u can write conditions like
whre creatate keychange cloumn=0---->to capture duplicate records
where creatate keychange cloumn=1---->to capture unique records
ANJI
-
- Premium Member
- Posts: 104
- Joined: Thu Jul 12, 2007 11:32 pm
- Location: Canada