Using Chronolator Samples
Exercise 5 - Finding duplicated events

Suppose you have already put together a Composite Chronology. One of the agencies in it sends you an updated version of their chronology with some new events, but they are unable to tell you exactly which ones they are. To save you having to trawl through the two chronologies to identify them, simply import and merge the new version and use the Duplicates tool to highlight or delete the events that you already have.

In this exercise we will highlight duplicates first, then delete them. There is no need to do this though - you can delete them without highlighting them if you want.



What to expect and other comments


Read Chronolator Toolbars and About the Exercises if you have not already done so.


None of the Sample documents contains any duplicated rows. We shall make some in the first steps of this exercise, which have a light blue background . . .


Open  SampleInternalChronologyBerrickshireAmbulance.

Duplicated rowsNote that this chronology has four events from Berrickshire Ambulance Service: two on 18 Feb 2013 and two on 15 Jul 2013.


Close  SampleInternalChronologyBerrickshireAmbulance.

The only reason to open it was to look at the events.


Open SampleCompositeChronologyHealth.

This chronology already contains the two events on 15 Jul 2013 from Berrickshire Ambulance Service.


Import  SampleInternalChronologyBerrickshireAmbulance,
giving it the Source of Information Berrickshire Ambulance Service.

Press Merge Tables.

Press Sort Tables > Ascending.

For an exercise about Import and Merge, see Exercise 4 - Importing and Merging tables into a Composite Chronology.

. . . we have now ensured that the Composite Chronology contains duplicated rows from Berrickshire Ambulance Service.


Press Tools > Duplicates > Highlight :

Highlight Duplicates button           

The Highlight Duplicate Rows form is displayed:

Highlight Duplicates form


Press OK.

Message 3025 is displayed, saying that two duplicate rows have been found:

Message 3025
If not, you might have mis-typed the Source of Information in step 6. Try repeating Steps 7 and 8, having ticked the Ignore source column check box.

Refer to Working with Duplicated Rows in Using Chronolator Documents for more details.


Press OK.


Press the leftmost navigation button on the toolbar:

Go to first duplicate button

The document scrolls to the first duplicate, which is highlighted in pale blue:

Duplicated rows are highlighted
The original event is not highlighted.


Press Tools > Duplicates > Delete :

Delete Duplicates button

The Delete Duplicate Rows form is displayed:

Delete Duplicates form
Refer to Working with Duplicated Rows in Using Chronolator Documents if you are interested in the Copy deleted rows check box. It saves the deleted rows in a new document, but is not used in this exercise.


Press OK.

The two duplicate rows have been deleted, and Message 3030 is issued to confirm this. Press OK  to dismiss it.


Close SampleCompositeChronologyHealth without saving changes.


In this exercise, you have seen that: