some drugs have multiple dose forms

[tiozab]

Here is a list of (drug) concept_ids with concept name that have multiple dose forms. Can the dose form mapping be corrected that the drugs only have one dose form?

duplicate dose forms.csv

[thisismexp]

We encountered the same issue and identified about 6.763 affected concepts in RxNorm/RxE with this query:

--sqlite
SELECT d.concept_id, d.concept_name, group_concat(df.concept_name)
FROM CONCEPT d
INNER JOIN CONCEPT_RELATIONSHIP cr
    ON d.concept_id = cr.concept_id_1
    AND cr.relationship_id = 'RxNorm has dose form'
    AND cr.invalid_reason = ''
    AND d.invalid_reason = ''
    AND d.vocabulary_id IN ('RxNorm', 'RxNorm Extension')
INNER JOIN CONCEPT df
    ON cr.concept_id_2 = df.concept_id
    AND df.invalid_reason = ''
GROUP BY d.concept_id
HAVING count(df.concept_id) > 1