How to I check for or prevent erroneous data from being run through my process?
We find that our users routinely configure steps at the beginning of their process to validate their data as it “comes in”. This includes comparing the format and structure of an input file to a pre-defined template (e.g. have I got the right columns etc…) and performing simple sanity checks on the data (e.g. count of records, checking dates etc). Furthermore, the processes are often configured to stop and alert a key user in the event that a validation issue has arisen.