topic Generic Load with Repeating events in QlikView https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155266#M31574 <HTML><HEAD></HEAD><BODY><P></P><P dir="ltr">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</P><P dir="ltr">Patient # Status Status Date/Time</P><P dir="ltr">1234 ARRIVED 1/2/2011 10:00 AM</P><P dir="ltr">1234 WAITROOM 1/2/2011 10:02 AM</P><P dir="ltr">1234 REG 1/2/2011 10:05 AM</P><P dir="ltr">1234 WAITROOM 1/2/2011 10:10 AM</P><P dir="ltr">Right now with my Generic Load it looks like this</P><P dir="ltr">Patient # ARRIVED WAITROOM REG</P><P dir="ltr">1234 1/2/2011 10:00 AM 1/2/2011 10:02 AM 1/2/2011 10:05 AM</P><P dir="ltr">1234 1/2/2011 10:00 AM 1/2/2011 10:10 AM 1/2/2011 10:05 AM</P><P></P><P dir="ltr">How do I deal with the WAITROOM status since it can occur more then once ?</P><BR /><BR /> <P></P><BR /><BR /> <P></P></BODY></HTML> Thu, 10 Mar 2011 22:48:05 GMT 2011-03-10T22:48:05Z Generic Load with Repeating events https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155266#M31574 <HTML><HEAD></HEAD><BODY><P></P><P dir="ltr">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</P><P dir="ltr">Patient # Status Status Date/Time</P><P dir="ltr">1234 ARRIVED 1/2/2011 10:00 AM</P><P dir="ltr">1234 WAITROOM 1/2/2011 10:02 AM</P><P dir="ltr">1234 REG 1/2/2011 10:05 AM</P><P dir="ltr">1234 WAITROOM 1/2/2011 10:10 AM</P><P dir="ltr">Right now with my Generic Load it looks like this</P><P dir="ltr">Patient # ARRIVED WAITROOM REG</P><P dir="ltr">1234 1/2/2011 10:00 AM 1/2/2011 10:02 AM 1/2/2011 10:05 AM</P><P dir="ltr">1234 1/2/2011 10:00 AM 1/2/2011 10:10 AM 1/2/2011 10:05 AM</P><P></P><P dir="ltr">How do I deal with the WAITROOM status since it can occur more then once ?</P><BR /><BR /> <P></P><BR /><BR /> <P></P></BODY></HTML> Thu, 10 Mar 2011 22:48:05 GMT https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155266#M31574 2011-03-10T22:48:05Z Generic Load with Repeating events https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155267#M31575 <HTML><HEAD></HEAD><BODY><P>What do you want the result to be? One row with the earliest or latest WAITROOM? Or multiple fields. WAITROOM1, WATIROOM2, etc?</P></BODY></HTML> Fri, 11 Mar 2011 04:20:40 GMT https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155267#M31575 rwunderlich 2011-03-11T04:20:40Z Generic Load with Repeating events https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155268#M31576 <HTML><HEAD></HEAD><BODY><P>I would like WAITROOM1 and WAITROOM2</P></BODY></HTML> Fri, 11 Mar 2011 15:59:50 GMT https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155268#M31576 2011-03-11T15:59:50Z Generic Load with Repeating events https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155269#M31577 <HTML><HEAD></HEAD><BODY><P>Attached is a possible solution.</P></BODY></HTML> Fri, 18 Mar 2011 14:53:52 GMT https://community.qlik.com/t5/QlikView/Generic-Load-with-Repeating-events/m-p/155269#M31577 rwunderlich 2011-03-18T14:53:52Z