Re: Convert sequence number into ordinal value during load
Agreed. it's a stupid requirement because it's not real.
The example is just an abstract representation of the problem. I'm dealing with mental health diagnoses (multiple per patient) which are recorded in an ordinal way so that the primary diagnosis will be the earliest in the sequence. Each record also has a time, date, and category assigned to it. My abstract was just trying to distill things down.
I could find for the diagnosis with the minimum sequence in each case, using set analysis, but then I'd need to do the same thing with the secondary diagnosis, etc...with up to 10 sequences per patient. I'd rather assign the ordinal value during the load.