Page Icon

Getting Started with Data Compare - Rons Data Compare


Rons Data Compare is an application for comparing and previewing differences between two CSV files. This document is intended to help users effectively update one CSV file based on the differences identified in another.

First Things First

Of course the first thing to do is download and install Rons Data Compare. This will give you the essential software needed to do the job.

Data Compare Start

Concepts

Each Rons Data Compare comparison is opened in a new tab within the main window. Each comparison contains two CSV files and represents a single comparison session used to transfer updates from one document to another.

When one document is compared to another, the columns are mapped (or aligned) between the two files. The values in those columns are then used to align the rows. Differences in columns, rows, and cells are displayed, along with navigation and update functions that help you review and apply changes.

Open a Compare

You can start by opening a blank comparison (New Comparison) and then opening the two CSV files you want to compare. Alternatively, you can open a CSV file using Open Comparison. This automatically creates a new comparison and opens the selected file on the left side.

You can also use the Locations panel on the left side of the window to browse for CSV files. From a file’s context menu, Open Comparison starts a new comparison with that file on the left, and Send Left or Send Right places it on one side of the comparison that is already open.

Data Compare Location

Compare Settings

Once a comparison has been opened and both documents are loaded, the next step is to define how the documents will be compared.

Data Compare Compare Settings

Column Mappings

Rows are matched by comparing the values in mapped columns between the left and right files.

Column mappings identify which columns in the two files contain equivalent data. These mappings are required because the application uses them to match rows and determine where differences exist.

At least one column mapping must be defined between the files.

Key columns

Key columns are one or more columns that contain data used to uniquely identify a row.

Examples include a 'Catalogue ID' in a product list or an 'Email address' in a contact list.

If one or more key columns are defined and a Match key compare mode is selected, only the key columns are used to match rows between the left and right files. If a key mode is selected and no key columns are defined, the compare falls back to Match sequential.

Using key columns provides several advantages:

  • Precision - Rows can be matched accurately and consistently.
  • Speed - Looking up rows by key is typically much faster than comparing entire rows.
  • Cell Differences - Once rows have been matched, the remaining mapped columns can be checked for differences at the cell level.

Compare Modes

Match sequential is the default.

Mode Description
Match sequential Walks both files from top to bottom in their current order, matching on all mapped columns. If the current rows differ, the compare looks ahead for an exact match so inserted or deleted rows can be absorbed. Rows that still cannot be matched are paired as a changed row, so cell differences can still be shown.
Match full row Matches rows by the full set of mapped columns, regardless of order. A row either matches completely or it does not, so individual cell differences are not reported. Unmatched rows appear as extras.
Match key - Left and right Mapped key columns match the rows. Every row from the left and the right is included. Other mapped columns are compared cell by cell.
Match key - Left only Mapped key columns match the rows. Every row from the left is included, together with the matching rows from the right.
Match key - Lookup Looks up rows in the right file that match the left file, using the mapped key columns.

Options

Beside the compare modes:

  • Conversion Region — culture used when values are compared.
  • Use Case — treat uppercase and lowercase as different.
  • Ignore space and symbols — ignore spaces and symbols while matching.

For more detail on row matching in Rons Data Compare see Data Compare Row Comparison Explained.

The Details

To quickly create a column mapping, use the Auto Map button. The available options are:

  • Build Map from Names (default) — matches columns by name.
  • Build Map from Positions — matches columns by their position in each file.

You can also manage mappings manually using the controls around the Columns Mapped list. Mappings can be added, edited, or removed as needed, although it is generally recommended to map all corresponding columns.

To designate key columns, select the appropriate mappings in the Columns Mapped list and choose Make Key Column. Key columns can be removed individually with Remove Key Column or all at once with Clear Key Columns.

The Comparison

When ready (or just to see what happens) press the Compare button.

Data Compare Differences

The two document views have now switched to Compare View. This view overlays the original documents and highlights differences in columns, rows, and cells between the two files. You can remove the comparison overlay by clicking Clear, which returns both sides to the normal document view.

Part of the power of Rons Data Compare is that its comparison features are implemented as a lightweight layer over the underlying documents. This approach keeps the application fast, efficient, and easy to use.

The Differences tab is the primary work space for reviewing and managing differences between the two documents. The Actions panels on the left and right provide synchronisation commands, while the Difference Summary displays the number of differences detected. The navigation panels make it easy to move between differences and review them efficiently.

Changes Detected and Navigation

After a compare is executed the display is updated to show differences in these ways:

  • Columns - All columns from both documents are displayed. If a column is not mapped or does not exist in the document being compared, it is highlighted in green. This ensures that the displayed column count always matches the column count of the underlying documents.
  • Row - Rows are matched by comparing the key columns or mapped columns, as described earlier. Matched rows are displayed without highlighting. If a row exists on one side but not the other, the existing row is highlighted in green and the corresponding missing row is highlighted in red. This approach ensures that the row count remains aligned on both sides of the comparison.
  • Cells - When both the row and column match, cells with identical values are displayed without highlighting. Cells containing different values are highlighted in purple. If a cell contains a value on one side but is empty on the other, the populated cell is highlighted in green and the corresponding empty cell is highlighted in red. When rows or columns do not match, cell highlighting follows the row or column highlighting rules.

Navigation between changes is straightforward. Changes are grouped into the following categories:

  • Column
  • Row
  • Cell

This allows each type of change to be reviewed independently.

Updates

Data Compare Updates

Updates can be applied to either the left or right document by selecting an action from the Actions panels located on either side of the Differences tab. The same commands are also available from the main menu and the column, row, and cell context menus.

The available actions are described below.

Column Actions

Action Target Document Description
Add Extra (Filled) Opposite Adds the columns to the opposite document and copies all row values.
Add Extra (Empty) Opposite Adds the columns to the opposite document without copying any values.
Delete Extra Associated Deletes the extra columns from the associated document.

Row Actions

Action Target Document Description
Add Missing (Filled) Associated Adds the missing rows and copies the column values from the opposite document.
Add Missing (Key) Associated Adds the missing rows and copies only the key column values.
Add Missing (Empty) Associated Adds empty rows corresponding to rows that exist only in the opposite document.
Delete Extra Associated Deletes the extra rows from the associated document.
Delete Same Associated Deletes rows in the current selection that are the same in both files.

Cell Actions

Action Target Document Description
Add Missing Associated Copies values from the opposite document into empty cells.
Update Different Associated Updates cells whose values differ from those in the opposite document.
Delete Different Associated Clears cells whose values differ from those in the opposite document.
Delete Extra Associated Clears cells that hold a value here when the opposite cell is empty.

Action Direction

With the exception of the column Add Extra actions, these commands update the document the action is applied to by pulling data from the opposite document. Row commands are named Add Missing, not Add Extra, because they fill rows that are absent on the side you are updating.

The Column Add Extra actions work differently. They update the opposite document by pushing the selected column to it. This behaviour reflects the fact that column differences always represent extra columns that exist in one document but not the other.

Related Information