search

sema4hai / s4-msdw2trinetx

0 stars 0 forks source link

LOINC mapping has duplicating rows #4

Closed aaronzhangSema4 closed 2 years ago

aaronzhangSema4 commented 3 years ago

one example

source code test_name unit loinc default_unit
EPIC 6485 CREATININE MG/DL 2160-0 mg/dL
EPIC 6485 CREATININE mg/dL 2160-0 mg/dL
EPIC 6485 CREATININE NA 2160-0 mg/dL
EPIC 6485 CREATININE mg/dl 2160-0 mg/dL

address this and then repopulate the database table

aaronzhangSema4 commented 2 years ago

This is not really a bug. The "unit" is from the source data, so it is expected to have variants.

aaronzhangSema4 commented 2 years ago

It is going to be kept as is.