[GH-ISSUE #45] Add check for duplicate custom concepts #27

New issue

Closed

opened 2026-03-23 20:28:36 +00:00 by mirror · 1 comment

mirror commented

2026-03-23 20:28:36 +00:00

Owner

Originally created by @pjlammertyn on GitHub (Apr 11, 2024).
Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/45

Originally assigned to: @pjlammertyn on GitHub.

example query for check:

select T.concept_code, count(*)
from (
    SELECT DISTINCT swap.y as concept_id, t.* EXCEPT(concept_id)
    FROM `work.observation__observation_concept_id_concept` t
    INNER JOIN `work.concept_id_swap` swap 
        on swap.x = concat('observation_concept_id__', t.concept_code)
) T
group by T.concept_code
having count(*) > 1

Originally created by @pjlammertyn on GitHub (Apr 11, 2024). Original GitHub issue: https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/issues/45 Originally assigned to: @pjlammertyn on GitHub. example query for check: ```sql select T.concept_code, count(*) from ( SELECT DISTINCT swap.y as concept_id, t.* EXCEPT(concept_id) FROM `work.observation__observation_concept_id_concept` t INNER JOIN `work.concept_id_swap` swap on swap.x = concat('observation_concept_id__', t.concept_code) ) T group by T.concept_code having count(*) > 1 ```

mirror

2026-03-23 20:28:36 +00:00

closed this issue
added the
enhancement
label

mirror commented

2026-03-23 20:28:37 +00:00

Author

Owner

@pjlammertyn commented on GitHub (Apr 12, 2024):

solved in commit github.com/RADar-AZDelta/Rabbit-in-a-Blender@b81f8cf172

@pjlammertyn commented on GitHub (Apr 12, 2024): solved in commit https://github.com/RADar-AZDelta/Rabbit-in-a-Blender/commit/b81f8cf172d1f9361c68f0fdf227f7a8f3d00f1c

mirror referenced this issue

2026-03-23 20:28:57 +00:00

[PR #27] [CLOSED] Bump dash from 2.14.1 to 2.15.0 #82