If you wanted to test the output of a workflow every time it's run for things like:
- Number of rows is in a certain range.
- Sum or average of some columns are within certain ranges.
- All rows are unique over a certain subset of columns.
- Dates in one column are within a certain range.
As well as stuff you can do with the Test tool, like checking that statements hold for each row...
How would you do it?
Have two test tools, one which takes the raw table to do row-level tests, and another that takes the transpose or cross-tab of the table to test the column-wise requirements?
