Compare Data using UUID

Discussions about tools to complement CSPro data processing
Post Reply
YFT_CBSD
Posts: 65
Joined: January 3rd, 2023, 12:36 am

Compare Data using UUID

Post 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?
Gregory Martin
Posts: 1946
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Compare Data using UUID

Post 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
Post Reply