Compare workbooks
compare_workbooksCompare two CSV or XLSX tables by explicit key columns to surface duplicate or blank keys and changed records, including cell value previews only when requested.
Instructions
Compare two CSV/XLSX tables using explicit key columns. Duplicate or blank keys are surfaced; keys are never returned. Changed cell values are excluded unless include_values is true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| after_path | Yes | Later CSV/XLSX path relative to KINGWORKBOOK_ROOT. | |
| after_sheet | No | Optional sheet name in the later XLSX file. | |
| before_path | Yes | Earlier CSV/XLSX path relative to KINGWORKBOOK_ROOT. | |
| key_columns | Yes | One or more exact normalized column names from inspect_workbook. | |
| before_sheet | No | Optional sheet name in the earlier XLSX file. | |
| include_values | No | Set true only when the user wants changed cell value previews. | |
| max_reported_changes | No | Maximum changed-record samples to return. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| notes | Yes | ||
| status | Yes | ||
| changes | Yes | ||
| added_rows | Yes | ||
| after_path | Yes | ||
| after_sheet | Yes | ||
| before_path | Yes | ||
| key_columns | Yes | ||
| before_sheet | Yes | ||
| removed_rows | Yes | ||
| added_records | Yes | ||
| after_records | Yes | ||
| changed_cells | Yes | ||
| before_records | Yes | ||
| changed_records | Yes | ||
| removed_records | Yes | ||
| values_included | Yes | ||
| changes_truncated | Yes | ||
| unchanged_records | Yes | ||
| columns_only_after | Yes | ||
| columns_only_before | Yes | ||
| added_rows_truncated | Yes | ||
| missing_key_rows_after | Yes | ||
| removed_rows_truncated | Yes | ||
| missing_key_rows_before | Yes | ||
| duplicate_key_rows_after | Yes | ||
| duplicate_key_count_after | Yes | ||
| duplicate_key_rows_before | Yes | ||
| duplicate_key_count_before | Yes |