create the statements as PSEUDO code for the MySQL in your report

Create a list of 5 specific data validation rules. Clean the data by filtering the data sources into valid and rejected output streams by transforming the data with the data validator. Transform the data into a usable format, and document the data validation results. Document any data validation errors that occur, and make corrections. Run the profiler again, and output the results into the database table. Execute the transformation to verify that the data are cleaned. Repeat the transformation steps until all of the data are satisfactory.