Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

how to ensure Completeness and Accuracy of the workflow?

bui195
7 - Meteor

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!

1 REPLY 1
Luke_C
17 - Castor
17 - Castor

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.

Labels
Top Solution Authors