I have policies A1, A2, A3 ,... with set of record types like shown below:
A1
RT - 1, 2,3,4,4,4,6
A2
RT - 1,2,3,4,4,4,4,4,6 ,etc
I would like to sort only record type 4 on some condition for each policy without disturbing other record types sequence. Can anyone pls let me know how this can be done?
I would like to sort only record type 4 on some condition for each policy
Also please explain more on this.
what is the condition? where is the condition present? in A record or 4 type records on what key you wan to sort rec type 4 records?
What is SORT product you have now at your shop? Your old posts shows you have SYNCSORT.
It is FB and 276 bytes.
REcord format looks something like this. At 41 position we have record type and I would like to sorr only record type '4' wrt to postion (43,6) and 48 postion :
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Sambhaji,
Why would you copy the field at 43 to 277 and then SORT on the field at 43? What does that accomplish? I guess you meant to SORT on the field at 277 like this:
Note that with the supplied input records, the following would actually work:
Code:
OPTION EQUALS
SORT FIELDS=(41,1,CH,A,43,6,CH,A)
The data would have to be more complicated for the solution to really require sorting on blanks at 277 for the fields that do not have '4' in 41.
For example, if there were two '1' records with values 222222 and 111111 at 43. The blanks in 277 and EQUALS would then keep those '1' records in their original order instead of sorting them by the key at 43.
Sometimes the supplied data is not good enough to determine if a solution will actually work or not.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Ah, you were thinking in the right direction then. I find its best to add test data that matches the situations I'm solving for when the original data doesn't cover those situations. That way, you know if your solution works for all of the situations you're trying to cover. Testing is certainly an "art".
the above syntax isnt wrking for my requirement. Here it is disturbing record types 1,2,3 and 6 sequence. I want to keep this sequence intact and sort record type 4 based on some fields internally for a policy. I need to internally sort record type 5 on conditions which are not same as record type '4' conditions if a specific policy has record type '5' multiple occurnces along with record type '4'.