Validate citation pointers after a table transformation — what should the operator record?
A transformation can preserve every source URL yet break the connection between a statement and the evidence row supporting it. Check citation pointers after sorting, filtering or flattening. The goal is operational referential integrity, not a new judgment about whether the cited statement is substantively correct.
Ensure every retained citation still resolves to the correct permitted evidence row.
Use statement_ref, evidence_row_key and input_revision in the local citation index. A spreadsheet row number is not a durable evidence pointer because sorting can move the record while leaving the number-looking reference in a copied note unchanged.
Record citation_index_revision and the unresolved pointer list alongside the derived table. A source link being clickable does not by itself establish that the linked record is the one intended by a particular local statement reference.Define the pointer contract
Use statement_ref, evidence_row_key and input_revision in the local citation index. A spreadsheet row number is not a durable evidence pointer because sorting can move the record while leaving the number-looking reference in a copied note unchanged.
Inspect pointer targets
Resolve each permitted evidence_row_key against the declared input revision. Classify targets as present, withheld or unresolved rather than replacing a missing target with a similarly titled record from a newer table or another research session.
Test a sorting fixture
Use labeled source rows with different keys and deliberately reorder them. The same statement_ref should still identify the intended evidence object after sorting, proving the relationship depends on explicit keys rather than its original screen position.
Review broken relationships
For an orphaned pointer, inspect the transformation ledger to determine whether a key changed, a row was filtered out or access now prevents resolution. Keep the supported cause separate from guesses about the underlying publisher or source content.
Release the checked index
Record citation_index_revision and the unresolved pointer list alongside the derived table. A source link being clickable does not by itself establish that the linked record is the one intended by a particular local statement reference.
Keep the boundaries clear.
- Ensure every retained citation still resolves to the correct permitted evidence row.
- Operational record: Define the pointer contract. Context badges do not certify access.
Start with a read-only check: ask your agent to report actual source coverage before collecting records or exporting an audience.
Primary references
Documentation reviewed 2026-11-15. Product capabilities, client availability and plans can change. Third-party marks identify their products, not an affiliation.