Hi, how can we help you?

• Easy To Use

  Compare is a powerful data comparison tool designed to be simple and easy to use.

• Multiple Uses

  Compare can be used by business analysts, data scientists, integration specialists, and other software professionals to quickly and accurately find the differences between datasets.

• Powerful

  Large files consisting of hundreds of columns and hundreds of thousands of rows can be processed in a matter of minutes.

• Secure

  Compare is secure. All data processing occurs on your local machine. Nothing is transmitted or processed in the cloud.

• Speed

  Compare automatically processes millions of records per minute and outputs the results to Excel, where more analysis can occur.

• Support

  Dispatch Integration supports everything we build. We prioritize servicing your needs throughout the data integration and workflow development lifecycle.

1. Select Files to Compare
   Select two comma-delimited files with the same column headers. The ID number of each file is used to match the records between the files.

   

2. Select Key Fields
   After selecting the files that need to be compared, select a key field by using the options available (column headers from the files). More than one field can be selected.

   

3. Select Output Options
   The output file will contain more columns than the original files being compared. This allows the user to filter files that have differences in datasets and decide how to deal with the identified discrepancies.

   

4. Compare Output In Excel
   The output highlights the discrepancies between files and provides users with information such as the number of records in each file, the number of unique records between the two files, the number of differences detected, and the total number of warnings (e.g. records with identical ID numbers).

   

Compare Is For You!

	Data Migration Specialists	Data Migration Specialists move data between internal and external systems. Compare lets Data Migration Specialists compare data loads from different times or systems to ensure differences are understood, and bad data doesn’t inadvertently pollute systems. Differences can easily be flagged in the output file for further investigation or acceptance.
	Quality Assurance Professionals	Compare can help QA professionals quickly analyze datasets to pinpoint quality issues or anomalies. Whether you’re looking for temporal changes, piece-to-piece changes, within-piece changes or population-to-population changes, Compare will help you quickly discover potential quality problems.
	Business Analysts	Business Analysts use Compare to analyze datasets to find anomalies quickly. Cleaning datasets that have gotten out of sync is easier and faster using Compare. Differences can quickly be tagged for further review and correction or accepted as is. The output is in Excel format and can include both the original datasets plus a rich comparison sheet to conduct more analysis if required conveniently.
	IT Professionals	IT professionals use Compare to help with regression testing during system upgrades. When applications are modified, reconfigured, upgraded, or replaced, Compare can save hours of time during testing to confirm system output is the same before and after any change. Simply take a “known-good” output file and compare it to a file generated by the changed system. Compare will flag any differences between the files in minutes.
	Developers	Enterprise Systems Developers use Compare to determine if their code is delivering the output they expect. Compare is a simple tool to use while doing unit tests to validate that output of systems in development matches legacy code and business requirements.
	Engineers, Researchers, and many more professions	Engineers, Researchers, and many more professionals use Compare as a simple and fast tool to help them analyze data quickly.  Compare saves time and eliminates tedium, regardless of the type of data.
	Data Scientists	Data scientists use Compare to determine differences between datasets quickly. Data scientists typically have many analytical tools at their disposal, but Compare is the simplest and fastest way to look for quickly find differences between data files.