Duplicate records in a csdb

Other discussions about CSPro
Post Reply
AriSilva
Posts: 255
Joined: July 22nd, 2016, 3:55 pm

Duplicate records in a csdb

Post by AriSilva » May 25th, 2019, 9:30 am

Hi folks,
I was having trouble with two records with the same ID, but with different contents. They were in different backup files, so, I executed a batch cspro program changing the ID of one of them, and did a concatenation to put them together, but the concat output told me that they were still duplicated.
I assumed that it was because of the internal cspro key the records have in the csdb, so, I converted one of the files to .dat and reconverted it back to .csdb, and it worked.
I wonder if there is some way to have access to that internal identification key.
Best
Ari
Best
Ari

Gregory Martin
Posts: 1208
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Duplicate records in a csdb

Post by Gregory Martin » May 29th, 2019, 11:59 am

You can access the key by calling this:
uuid(DICT_NAME)
However, you can't change it in logic, so the above is mostly just for informational purposes (or if you're working with paradata reports).

Post Reply