EHDEN / CdmInspection

R Package to support quality control inspection of an OMOP-CDM instance
Apache License 2.0
11 stars 16 forks source link

Mapping completeness: Error division by zero #9

Closed MaximMoinat closed 3 years ago

MaximMoinat commented 3 years ago

If one or more domain tables contains an empty _source_value column, the query exits with 'ERROR: division by zero'.

This is due to the COUNT(distinct source_value) returning 0.

Although it is against OMOP conventions to have no source_value, we should catch this.