Example: List of City Trees
In this example we will open a very large table of public trees in Wisconsin and sort it.
We have two Excel spreadsheets of city-planted trees. We will attempt to find days when the same species of tree was planted in both of our lists.
Our strategy for doing this will be to set date as a key column and then remove all of the other columns using the rules button.
We are going to choose a key column and also, choose some columns to ignore or delete.
- First, make the view wider:
view->overAndUnderLayout - You can choose one or more key columns from
rulesButton->columnsChoose date in this example. - Still at
rulesButton->columns->editdo a delete of many unimportant columns. Don't worry, the original file will be unharmed. Keep deleting until all that remains is your Address[key] column and a few other columns of interest.
How the file looks when it first opens. It has 17 columns. We want to only look at two. Rightclick the column top you want to be your unique key. Then in RulesButton->Columns start doing 'remove' on the unwanted columns.
How NOT to choose a key: Springfield is an example of a bad key. It is far from unique
This is from: Session->SessionSettings->Columns Keep rightclicking and removing until only your interesting columns remain. Note that each row here is a 'column' in your spreadsheet.
Result: Using date as the key, we found a day when both lists planted the same species, a Magnolia, one August 21st.
Note that Beyond Compare is in Read-Only mode for Microsoft files (Excel & word) and PDF files. We cannot alter the file nor save our work. We can export the report though! Use
Session->TableCompareReport.