Data Quality Validation App

[#1]

The purpose of this app is to validate a table against a reference table. If the table is validated, then it can be outputted to the desired location. A report is also generated providing details of the table quality. If desired, the report can be emailed to, for example, the developer.

After inputting the table to be tested as well as the reference table (reference file path can stay static), multiple tests occur:

1. Missing fields from the expected input

2. Testing that the expected fields have the same types, and flagging the fields that have different types.

3. Percent of missing values from valid fields

4. Flagging extra fields

5. Row count of the inputted table

6. Testing that the file types are the same