CSV Conditional Record Rule Auditor
Check explicit per-record IF/THEN field rules with exact string or decimal comparisons and bounded witnesses.
Loading tool…
How to use CSV Conditional Record Rule Auditor
Audit cross-field rules such as a chosen status requiring a code or an end value not preceding its start. Each rule reports passed, failed, skipped and indeterminate records separately; invalid numeric data cannot quietly turn into zero or a passing comparison.
- Enter input, rule objects json.
- Choose the settings for csv conditional record rule auditor, then run the tool.
- Review the result and any limitations before copying or downloading it.
Good to know
- 200,000 CSV characters,5000 records,30 rules and 100 detailed failure/indeterminate witnesses per rule. Witness output is preflighted at 350,000 characters.
- Supported predicates: eq, ne, empty, nonempty, lt, le, gt, ge. Comparisons use one literal string or another column; no arbitrary expression language, regular expression, SQL or repair operation. Witness cell evidence is limited to 200 characters.
- Processing is local. Output is limited to 1,000,000 text characters unless a stricter file limit is stated.
Common questions
Does an invalid number count as a rule failure?
It is explicitly indeterminate when you choose reporting, or it stops the operation when you choose refusal. It never becomes a successful numeric comparison.
Is this input sent to a server?
No. The application processes this input inside your browser tab and does not save it to persistent storage.
Keep going with related tools
All data →Supported CSV Data Schema Validator
Check a small declared CSV schema for column types, required cells and composite primary-key uniqueness.
DataDeclared Functional Dependency Checker
Check whether equal determinant CSV fields always have equal dependent fields in the supplied records.
DataCSV Foreign Key Checker
Check child records against unique parent composite keys with explicit blank-key handling.
DataBounded CSV Arithmetic Column
Create a numeric CSV column from a fixed JSON arithmetic AST without executing spreadsheet formulas or user code.
DataFinite Decision Table Auditor
Enumerate declared categorical domains and show every rule gap, overlap, conflicting outcome and selected-rule witness.