Hi,
My source is a file. I have one column name like ENAME and data's are like below.
ENAME
1
1
2
3.
Now, my problem is I need to capture all the unique records in one file. The records not unique need to capture in other files. I know only If any duplicate records are there, I will capture that records and store it in seperate file. This logic I don't have idea how to implement this. Please any help is really appreciated.
Output:
Uniq_File1 NotUniq_File2
2 1
3 1
Identify Unique and Non_Unique Records...
Moderators: chulett, rschirm, roy
Identify Unique and Non_Unique Records...
prabakaran.v
Re: Identify Unique and Non_Unique Records...
First sort the data
then use aggregator and perform group count, then use filterstage and send the records which contains count >1 to alink and count=1 to another link
try this
then use aggregator and perform group count, then use filterstage and send the records which contains count >1 to alink and count=1 to another link
try this
Regards
Sankar
Sankar
Re: Identify Unique and Non_Unique Records...
Thanks ds. Really your input helped me a lot. I fixed my problem. Thx once again
prabakaran.v