num name num name
4 ccc 1 aaa
5 ddd 2 bbb
You could try using embedded SQL. Read from your input file. Then using SQL, query input file for that data returning a count. If value returned is 1 then write unique. If more than on the write to duplicate. Then read next input record and repeat till %EOF.
Register Hereor login if you are already a member