validate_data_consistency
Cross-validate data integrity across related Excel/CSV files by checking referential integrity, data completeness, and value ranges to ensure consistency.
Instructions
Cross-validate data integrity across related files
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| primaryFile | Yes | Path to the primary data file to validate | |
| referenceFiles | Yes | Array of reference file paths for validation | |
| validationRules | No | Specific validation rules to apply (optional, defaults to all) | |
| keyColumns | No | Specific columns to validate for referential integrity (optional) | |
| autoDetectRelationships | No | Automatically detect column relationships (default: true) | |
| tolerance | No | Tolerance for numeric validations (default: 0.01) | |
| sheet | No | Sheet name for Excel files (optional) | |
| reportFormat | No | Format of validation report (default: detailed) |