how to ensure Completeness and Accuracy of the workflow?

[bui195]

Hello,

I have a very simple workflow that in the original Excel format, I did vlookup from 3 different reports to the main report using customer ID. The information coming from these 3 reports including customer rating, some Yes/No questions, customer date. For the QA review purposes, I need to add some checks in the workflow to ensure the completeness and accuracy of the input and output files. I already added a Record count check for the completeness (make sure the number of records in the main file I vlookup to and the final output file are the same). However, I'm not sure what I can add to check the accuracy of the final output file? Thank you!

[Luke_C]

Hi @bui195,

It's a bit tough without seeing data, but in addition to validating record counts, you might consider adding browse tools to review L/R join anchors and see what, if any, records drop out. You might also leverage summarize tools to do counts by IDs or some other relevant attribute to further review the data at a high level.