I need to achieve the following using Sort card.
I want to sort it in such a way that the record with '9999' comes at top. The first 7 places corresponds to ID1, next 7 places ID2, next 4 places ID3 and final 3 places ID4. The problem is that ID2, ID3, ID4 are all alphanumeric as mentioned above. The final O/P should look like...
Please help me. Thanks in advance !!!