Generic Load with Repeating events

[#1]

Im looking at some data where they change the status of the patients multiple times.. Here is my issue, the patient has a couple statuses for instance

Patient # Status Status Date/Time

1234 ARRIVED 1/2/2011 10:00 AM

1234 WAITROOM 1/2/2011 10:02 AM

1234 REG 1/2/2011 10:05 AM

1234 WAITROOM 1/2/2011 10:10 AM

Right now with my Generic Load it looks like this

Patient # ARRIVED WAITROOM REG

1234 1/2/2011 10:00 AM 1/2/2011 10:02 AM 1/2/2011 10:05 AM

1234 1/2/2011 10:00 AM 1/2/2011 10:10 AM 1/2/2011 10:05 AM

How do I deal with the WAITROOM status since it can occur more then once ?

[rwunderlich]

What do you want the result to be? One row with the earliest or latest WAITROOM? Or multiple fields. WAITROOM1, WATIROOM2, etc?

[#3]

I would like WAITROOM1 and WAITROOM2

[rwunderlich]

Attached is a possible solution.