Excel
Spotting Data Entry Errors With Conditional Formatting
Use Excel conditional formatting to flag duplicates, blanks, out of range values, bad dates and unknown codes as people type, with formulas that stay fast.
7 min read
Tag
error-fix
93 posts
Excel
Refreshing Charts From a Changing Data Range in Excel
Fix charts that miss new rows or show blank gaps when data size changes: Excel tables, dynamic named ranges, generated ranges and refresh settings.
7 min read
JSON
Backfilling Historic Events After a Schema Change Safely
Three ways to rewrite a renamed JSON property across 1.5 million events in PostgreSQL: one UPDATE, batches and a table swap, with WAL, bloat and leftovers.
7 min read
JSON
Handling Properties That Change Type in JSON Event Data
Fix invalid input syntax for type numeric on a JSON property that became a string, null or object, with jsonb_typeof, pg_input_is_valid and a function.
7 min read
CSV
Reporting Row Level Errors Back to the User of a CSV Import
Report CSV import errors users can act on: line, column, value and rule, all problems per row, and a file of rejected rows to fix and re-upload.
8 min read
CSV
A Log Export With Unescaped Quotes and How to Read It
A log export has quotes inside quoted fields without doubling them. See what Python and DuckDB return, which setting reads them right and how to prove it.
7 min read
Excel
Error Handling With IFERROR and Safer Alternatives Today
Handle Excel formula errors without hiding bugs: IFERROR versus IFNA, testing inputs first, ISERROR functions, XLOOKUP not-found values and error codes.
6 min read
YAML
Fixing YAML Indentation Errors With a Linter and Editor
A messy file with nine findings, reported by yamllint line by line, then repaired with yq and a project config. The workflow that finds and fixes indentation.
7 min read
CSV
Loading CSV Into Snowflake and Handling Errors in COPY
Load CSV into Snowflake with a file format, a stage and COPY INTO, then read the errors: ON_ERROR, VALIDATION_MODE, VALIDATE and the 64 day skip rule.
7 min read
Excel
Audit Trails and History That Excel Cannot Give You
Excel cannot say who changed a cell and why. See what version history does, and build an audit trail in PostgreSQL with triggers or temporal tables.
8 min read
CSV
Handling a CSV Provider Who Changes Columns Without Warning
A provider adds, renames or reorders columns and your load breaks or, worse, succeeds. A header check that names the change, aliases and a policy per case.
7 min read
PostgreSQL
Comparing PostgreSQL Plans Before and After a Change
Compare PostgreSQL query plans before and after a change: capture both, control cache and noise, line up nodes and decide if the gain is real or warm cache.
7 min read