Comparestable

You have two datasets and need to find the differences between them – value mismatches, and rows that exist in only one side.

What it does

Compare reconciles two data sources row-by-row and column-by-column and shows exactly where they differ: changed values, and rows present in one source but not the other. Each source can be a CSV file, a SQL query (Oracle / GitHub), or a Report API endpoint. Typical uses: cutover rehearsals, payroll parallel testing, tenant-to-tenant checks, and post-go-live regression.

Typical workflow

1. Select the input and output sources (two files/queries to compare).
2. In Mapping, line up the columns and mark at least one Primary Key

(how rows are matched across the two sides).

3. Optionally add Translate (value crosswalks), Filter, or Calc

(calculated columns).

4. Run the comparison.
5. Review Diffs on screen, read the AI Analysis of the differences

(needs an AI provider), and download the Excel variance report. Monitor keeps a history of past runs you can reload.

Gotchas

• A Primary Key is required — without one, rows can't be matched and the run

is blocked.

• Inputs are CSV (or SQL/Report). An Excel file must be **converted to CSV

first** (see Convert).

• CSV files are uploaded into the app's local database when selected.
• The first run after launch may pause briefly while the data engine warms up.

Related tools

• Convert — turn an Excel/Report source into a CSV you can feed into Compare.
• EIB — if the goal is producing a Workday upload file rather than comparing.