OHDSI Home | Forums | Wiki | Github

Best practices for merging two CDM schemas?

Say you have two CDM schemas, A and B. Assume they do not share patients.

What are best practices for producing CDM schema C combining all data from A and B, but properly adapted to avoid collision of IDs (person_id, condition_occurrence_id, etc.)?

I do not think such task is particularly hard. I just wonder if others have pre-made approaches, scripts, maybe even functions in R packages.

Thanks!

Any reason you wouldn’t simply append the tables to each other? And if IDs overlap re-id?

Nothing against what you said, Christian. As I mentioned, I don’t think the task is hard. I just wanted to pass it by the forum, just in case I’m missing something or someone’s already, say, written an R package for that.
Thanks!

t