Dataset comparison / merge tool
To start using, download from here.
Comparing two datasets by eye only can get problematic when the reviewer has hundreds or thousands of rows to compare. Imagine having a dataset that contains a list of names, addresses and telephone numbers that needs to be compared and reviewed against a more recent one. This is often performed manually by eye, row by row or in a haphazard approach in Excel. This ends up being very inefficient and potentially error-prone. For critical datasets such as medical or financial records this would be an unacceptable method.
This is one big area where Excel users come unstuck - comparing seemingly two identical sheets. Many users still compare manually which will quickly lead to inefficient working practices. Imagine how many times in the workplace there is a need to reconcile or compare two different datasets. One may be a review that was performed 3 months ago and now another almost identical sheet has been located which forces the user to play 'spot the difference'. But how how is this possible when you have over 30,000 rows to compare? That's where this latest tool from Apples and Oranges can save you quite a bit of time!
ExCompare can do this task in seconds and quickly showing the user what any differences there are between the two datasets. The tool helps the user by:
Preventing the need for double data review of the same data from different timepoints (Temporal data)
Flagging NEW data (e.g. insertion of complete new records)
Flagging DELETED data (e.g. a datapoint in one or more records has been deleted)
Flagging CHANGED data (e.g. some records in the file may have been edited, but the reviewer doesn't know which ones)
Selection criteria (identify columns that have unique identifier(s)) and locate 'header row'
Easy two-file upload technique
The tool will compare changes between the two files (e.g. records removed, added or changed)
See below videos for a better understanding of how the tool can help you!
The tool can be used to any industry: Pharmaceuticals (clinical research data: patient data listings such as adverse events, concomitant medication...), IT, Geo-physics, Financials, Healthcare, Human Resources.....
Licencing / pricing structure
Until 30th September 2020, the tool is being provided on a FREE LICENCE. This means that you are able to download a copy for free and utilise the tool until the aforementioned expiry date. During this trial period you will be able to use the tool for all your comparison work! We would also appreciate any feedback that you may have so that we can make any adjustments or introduce new features. All you need to do is contact us!
Download the application below. Read EULA here.
Access to the tool is via a serial key (click key). Please contact us to get the latest key.