Data Standards Checkr Use Case

Data Standard Checkr

Use Case

Business parties exchange a lot of data. Best practise (and good for data quality) is that you do so based on a formalised data standard agreement between parties. Incoming files must be compliant to the rules of this agreement. The Data Standard Checkr tool checks if delivered data is compliant and informs on exceptions, errors etc.

How it works

This tool needs two input files: a data file and a corresponding data standards file. The data file can have an unlimited number of records with the columns as agreed and in the order as agreed. The data standards definition file should describe one line per column in the data file. Use the header from this example to make it all work: fieldname,columnnr,mandatory,fieldtype,minlength,maxlength,autocorrect,reference list,validation

For further explanation you can have a look at this example.
Share by: