Closed eeerika closed 5 months ago
This sounds good. It is also often useful to look for type mismatches, which often represent missing value codes that are defined. E.g., in a column of type double
with values like 1.2,2.1,3.4,NA,3.4,FAIL,4.5,2.2,POWER,1.1,2.2
the string values probably represent error conditions or missing values.
Purpose
This check will look to see if documented missingValueCodes of a file match the codes present in the data.
Components
Result
SUCCESS: if all of the missing value codes found in a file are present in the missingValueCode sections for each applicable column FAILURE: if there is one or more difference (would be good if it showed the difference: what code and for which columns) ERROR: on system error or exception in the check code, representing a bug in the check system