Open Clean
In a project, choose Clean in the top pipeline (or press ⌘/Ctrl+2). You see the dataset grid, health status, and tools for transforms.
ScreenshotClean step with data gridGrid + health chip + Add operation
Work with the grid
- Scroll and inspect profiled columns.
- Rename a column inline when the UI offers rename (operation: rename_column).
- For multi-sheet Excel files, switch worksheets with the sheet tabs.
- Use Preview in the panels bar to limit which row range you are looking at (start/end indices).
Add an operation
- Choose Add operation and search if needed.
- Pick a transform and fill the modal, then Apply.
Common operations:
- Rows: Drop nulls, Drop empty rows, Remove duplicates
- Columns: Drop columns
- Values:Fill nulls, Find & replace, Parse dates
ScreenshotAdd operation pickerSearch operations modal
Data issues and health
Health may show Cleaned, Partially cleaned, or Not cleaned, plus an issues count. Open Data issues to see what still needs attention.
Review changes
The collapsible audit trail lists transforms with timestamps. When a review surface appears, you can walk changes with previous/next and Keep decisions on the diff toolbar under Review cleaning changes.
ScreenshotAudit trail and review toolbarCollapsed/expanded trail under the grid
Proceed to Analysis
- Choose Proceed to Analysis when the table is good enough to query.
- If issues remain, confirm Proceed with known data issues? → Proceed anyway, or go back and fix them.
Auto-clean is labeled Coming soon and is not available yet — use Add operation for transforms.
Next
Continue to Analyze to run queries.