Open your dataset → Click column header → Edit Column.Column Name & Description: Use descriptive names and explain the column’s purpose.Data Type: Short Text, Long Text, Number, Date, Boolean, Email, URL, Phone, or JSON.Validation Rules: Set length limits, format patterns, value lists, min/max ranges, or conditional rules based on other columns.
Phone Numbers: ^\+?1?\d{9,15}$Industry Values: Technology, Healthcare, Finance, Manufacturing, Retail, OtherConditional: If Country = "US", then State must be valid US state code
Assign agents to columns for automatic processing:Enrichment Mode: Agent adds information to empty cells, preserving existing data.Enhancement Mode: Agent improves or standardizes existing data.Analysis Mode: Agent analyzes data and adds insights, original data preserved.
Customize agent behavior with column-specific guidance:
Copy
For "Company Name":- Extract official business name- Remove LLC/Inc unless part of brand- Standardize capitalization- Handle abbreviations consistently
The system calculates quality metrics for each column:Completeness: % of non-empty values
Validity: % passing validation rules
Consistency: Standardization and format consistency
Accuracy: Estimated accuracy from validationSet thresholds to trigger alerts when quality drops below acceptable levels.