Lesson 2.3.4
Repair a broken column without paying twice
What this costs
Only the rows you deliberately re run.
Before you start
A column that returned less than you expected.
Something went wrong on a run and you want to fix it. The instinct is to re run the column. The instinct is usually wrong, because a normal re run leaves successful rows alone but an advanced run may not, and the difference is your credit balance.
- 1
Diagnose before you re run
Lesson 2.1.6. Sort the blanks into skipped, not found and returned empty. Only skipped rows are worth re running as they are.
- 2
Fix the input, not the output
Most skips are a missing dependency. Fill the parent column and the skips resolve without touching the child configuration at all.
- 3
Understand the run options before choosing one
A standard re run leaves successfully enriched rows alone, so you do not spend twice. Advanced options exist for forcing a reprocess, and they charge for every row they touch.
- 4
Filter to the rows you actually want repaired
Then run on that selection only. Never re run a whole column to fix a subset.
- 5
If the prompt was wrong, do not repair, rebuild
A column whose configuration was wrong produced wrong answers on the rows that succeeded too. Those are the expensive ones to spot, because they look filled.
Forced a full reprocess to fix 40 rows
- What you see
- Charged for the 600 that were already fine
- The fix
- Filter to the 40, then run.
Deleted and rebuilt a column to fix it
- What you see
- Paid for the whole column twice
- The fix
- Re run the failed subset instead. Deletion refunds nothing.
Repaired a column whose prompt was wrong
- What you see
- Wrong answers persist on rows that had succeeded
- The fix
- Rebuild the column. A bad prompt corrupted the successes too.
Check yourself
0 of 2 answered1.A column returned less than you expected. What comes before re running it?
2.The column’s prompt was wrong. Should you repair or rebuild?
Related and next
This lesson is written and complete. Its screen recording is still to come, and the written walkthrough is designed to stand on its own without one.