Reconciles data sources using stable identifiers (Pay Number, driving licence, driver card, and driver qualification card numbers), producing exception reports and “no silent failure” checks. Use when you need weekly matching with explicit reasons for non-joins and mismatches.
- Initial release of the data-reconciliation-exceptions skill. - Reconciles multiple data sources using stable identifiers (Pay Number, driver documents). - Produces comprehensive exception reports with explicit reasons for each non-match or mismatch. - Implements “no silent failure” checks—pipelines stop when anomalies or tolerance breaches are detected. - Provides clear input requirements, configurable normalization, and threshold options. - Outputs a detailed CSV report categorizing every record (matched, missing, duplicate, mismatch, invalid).