Page 1 of 1
Compare Data using UUID
Posted: July 1st, 2025, 10:48 pm
by YFT_CBSD
Hello everyone,
When comparing data, the tool uses the case ID, which leads to issues when the file contains duplicate case IDs. Is there a way to compare using the UUID instead, without modifying the data?
Re: Compare Data using UUID
Posted: November 19th, 2025, 11:13 am
by Gregory Martin
Based on this request, I added a feature to CSPro 8.1 that will improve Compare Data's handling of duplicate cases. As now described in the helps:
Some data sources allow duplicate cases. These are cases share the same case key (ID values). These data sources generally use a UUID to uniquely identify each of the cases. When running a comparison in indexed order, the Compare Data will:
1. Match cases first by case key.
2. When there are cases sharing the same case key, the cases will be matched based on UUID.
3. When there is no UUID match, an input duplicate case will be compared against a reference case that has a case key and UUID combination that does not match any case in the input data. If there is no such match, the case will be listed as missing.
I think this would have addressed your concerns. If you want to test this out, here is the current version of CSDiff.exe (from CSPro 8.1 alpha):
https://drive.google.com/file/d/1VoOhoQ ... 6CyZM/view