Data Comparator
Compare two datasets (files or tables) and explore the differences.
Start a Comparison
Upload two files or reference tables to compare.
Dataset A - Select Table
sandbox
0731-102328-nflpsp31
hive_metastore
pov_pmi_db
fl_m_approvedvendorlist_consolidated_sf02_09
1_inventorymovement_all_vendors_consolidated
1_inventoryonhand_all_vendors_consolidated
1_open_po_all_vendors_consolidated
1_runningaltchange_all_vendors_consolidated
fl_m_approvedvendorlist_consolidated_sf02_09
fl_m_forecast_consolidated_sf_02_09
fl_m_inventoryageing_consolidated_sf_02_09
Dataset B - Select Table
sandbox
0731-102328-nflpsp31
hive_metastore
pov_pmi_db
gz_m_approvedvendorlist_consolidated_sf_02_09
fl_m_forecast_consolidated_sf_02_09
fl_m_inventoryageing_consolidated_sf_02_09
fl_m_inventorymovement_consolidated_sf_02_09
fl_m_inventoryonhand_consolidated_sf_02_09
fl_m_open_po_consolidated_sf_02_09
fl_m_runningaltchange_consolidated_sf_02_09
gz_m_approvedvendorlist_consolidated_sf_02_09
Select tables from configured data sources to compare.
Comparison Summary
Overview of the comparison results
Rows in A
1,000
Rows in B
1,000
Schema Findings
4
Coerced Matches
0
Schema Differences
Columns added/removed/changed
Showing 4 differences
| Type | Column | Details |
|---|---|---|
| warning | HIGH LEVEL CATEGORY | Type changed: string → null |
| warning | TSH MU | Type changed: string → null |
| warning | Version | Type changed: string → null |
| warning | ATTRITION RATE % | Type changed: string → number |
Value Differences
Row and cell-level mismatches
Showing 18,747 differences
| Primary Key | Column | Value A | Value B |
|---|---|---|---|
| 0 | ORGANIZATION | FL | GZ |
| 0 | EMS PLANT CODE | 124 | 176020 |
| 0 | EMS_MATERIAL_CODE | PMM-FGNH-00015748-100 | PM-49.T625-R01-C |
| 0 | PMI_MATERIAL_CODE | RAM.000525 | 49.T625 |