Hi,
Can i know the sort card for the below,
I have records as follows...
Num1 status
111 A
111 A
111 d
222 d
222 d
333 a
444 a
444 a
444 a
What i need is,
1. In one file, I need all the Coloums of Num1 for which Status is same( i.e 222 & 333 & 444),
2. In another file i need, all coloums of num1 for which status is different(I.e 111)
Let me know how to write this sort step.
Thanks
Shankarhgouda