Concatenate with duplicate keys

Discussions about tools to complement CSPro data processing
Post Reply
Posts: 333
Joined: July 22nd, 2016, 3:55 pm

Concatenate with duplicate keys

Post by AriSilva » September 13th, 2019, 4:29 pm

Duplicate keys are accepted in the csdb files, you can have 2 records (questionnaires) synced to the server, and downloaded as csdb,
However, when these files are concatenated, one of the duplicate records are skipped.
Is it possible to concatenate csdb files maintaining the duplicated records?

Posts: 2062
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: Concatenate with duplicate keys

Post by josh » September 14th, 2019, 2:27 pm

It isn't possible with the concatenate data tool. It is possible by creating a batch application with no logic and choosing multiple input files. Pick all the files you want to concatenate as input files and they will all be combined in the output file.

Posts: 2
Joined: March 21st, 2020, 12:18 pm

Re: Concatenate with duplicate keys

Post by Leo » March 21st, 2020, 12:41 pm

Hi Josh, Savy, and everyone. Hope all is well, especially in this challenging time.

I am searching for ways to deal with duplicate cases. I can set conditions on it in batch edit, but I still have to manually identify their IDs. Automated way is much better, right? For example, is there a way to prompt and choose one among the duplicate cases when I run the concat tool? Or keep only the completed cases among duplicates? I found an option in the Index tool, but it can't be used in csdb. Thanks.

This is my first time to post here. :)

Regards. Leo.

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

Re: Concatenate with duplicate keys

Post by Gregory Martin » March 24th, 2020, 10:45 am

Hello Leo,

CSPro 7.4 has several things that will help you. Firstly, the Index Data tool now works with .csdb files. Secondly, you can use the set access function in a batch application to only process your duplicate cases. If you can wait, in a few days we should be putting out the beta of this version, which you can get here:

Post Reply