Joined: 17 Mar 2009 Posts: 30 Location: Bangalore.India
I am trying to remove the duplicate as well as original rows from input datastet to one output dataset and other output dataset should contain all remaining rows...It should work like this..
Input : ( Key position 1-3)
Output1 : ( Duplicate and original rows)
Output2 : (Remaing unique rows)
I could achieve output1 with SUM FIELD=NONE and match unitilty in two different steps..But again I need to delete these duplicates from input to create output2..This is going to be very tedious work for huge files..
Is it possible in one/tow SORT steps..
Please help me on this..