Atrributing Event Data to a Given ID

  • Follow


I am trying to associate certain events for a given ID if the event falls
between the start and stop dates of the ID. If it does I want to append the
string of events separated by a comma together and put them in a new field
called events. What is the best way to do this?

Input data

ID file

ID   start    stop
---------------------------
id1  1/1/09   1/9/09
id2  3/1/09   3/5/09
id3  2/5/09   2/9/09

Event file

ID  event   start
-------------------------
id1 event1 1/5/09
id1 event2 1/6/09
id3 event3 2/6/09
id3 event4 2/7/09
id3 event5 7/1/09
id3 event1 2/6/09

desired output

ID   start    stop   events
------------------------------------------------
id1  1/1/09   1/9/09 event1, event2
id2  3/1//09  3/5/09
id3  2/5/09   2/9/09 event1, event3, event4
0
Reply harrypotterdhf (23) 1/20/2010 7:31:53 PM


0 Replies
185 Views

(page loaded in 0.049 seconds)

Similiar Articles:













7/18/2012 7:04:20 AM


Reply: