Sort Card to Mask the particular field values
Posted: Thu Jan 03, 2013 6:24 pm
Hi,
i am trying to mask the particular field values that appears more than once, as below:
Output file:
Please provide me the sort card to achieve the above.
Code'd and aligned
i am trying to mask the particular field values that appears more than once, as below:
Input file:
Employee name Dep No
abc 666
xyz 123
xyz 888
xyz 222
bat 345
Employee name Dep No
abc 666
xyz 123
xyz 888
xyz 222
bat 345
Output file:
Employee name Dep No
abc 666
xyz 123
888
222
bat 345
abc 666
xyz 123
888
222
bat 345
Please provide me the sort card to achieve the above.
Code'd and aligned