Hi Folks,
I am working with the concept_ancestor file for my project. I would like to retain the concept_ID which belongs to conditions only in the file. Is there any way to segregate this file wrt to “conditions”, “procedure”.
You can join CONCEPT_ANCESTOR table to CONCEPT table twice on ancestror_concept_id and descendant_concept_id and filter by domain_id = Condition or Procedure and then download it as a table