◆ Illustrator · logo

Data Validation

Compare the fact table on page 7 with the source spreadsheet and flag swapped figures or unit mismatches; correct any …

2heights
2tasks
1roles do it
See the prompt↓More logo workflows

The same job, four prompts

do it · improve it · decide · become
AExecute — “help me do it”Compare the fact table on page 7 with the source spreadsheet and flag swapped figures or unit…+
Compare the fact table on page 7 with the source spreadsheet and flag swapped figures or unit mismatches; correct any numeric or unit errors in the table and note each change with a source cell reference.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Audit the data table for statistics editor Priya: verify every figure against the supplied…+
Audit the data table for statistics editor Priya: verify every figure against the supplied spreadsheet, correct swapped numbers and unit mismatches, annotate each correction with the original sheet cell and a one‑line explanation of the discrepancy, and save a change log for legal review.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

How to do it

the tool · the steps · what to avoid
The tool
Pathfinder

The Pathfinder panel helps you combine and divide overlapping objects to create new shapes.

  1. 1

    Select Window > Pathfinder to open the Pathfinder panel.

    Best practiceYou can also use the keyboard shortcut Shift + Ctrl + F9 (Windows) or Shift + Cmd + F9 (Mac) to open the panel.

  2. 2

    Select two or more overlapping shapes using the Selection tool.

  3. 3

    In the Pathfinder panel, click a Shape Mode button to combine or subtract shapes.

    NoteFor example, click Unite to merge selected shapes into one.

  4. 4

    Alternatively, click a Pathfinders button to divide or trim shapes.

    NoteFor example, click Divide to cut shapes where they intersect.

  5. 5

    Press the Escape key to deselect the resulting paths.

  6. 6

    To access more options, click the More Options button in the Pathfinder section.

  7. 7

    Select Pathfinder Options from the panel menu to set Precision and Remove Redundant Points.

  8. 8

    Save your document by selecting File > Save or File > Save As.

Use layers to organize your document before applying Pathfinder operations for better control.

Pathfinder operations can be scripted using Illustrator's API for repetitive tasks and automation.

Glossary

words on this page
Remove Redundant PointsAn option that simplifies paths by deleting unnecessary anchor points without altering the shape.ExampleYou select Remove Redundant Points to simplify a complex path without changing its smooth curve.
Pathfinder OptionsSettings that control how Pathfinder operations are applied, including precision and redundant point removal.ExampleYou adjust settings to ensure the combined shapes have perfectly smooth edges after an operation.
PathfindersA set of tools and effects used to combine, subtract, or intersect multiple objects to create new shapes.ExampleUsing these tools, you cut one shape out of another to create a unique design.
Panel menuA menu within a panel that provides additional options and commands specific to that panel's functions.ExampleClicking the small icon in the Brushes panel reveals options like 'New Brush' or 'Delete Brush'.
Shape ModeA set of options within the Pathfinder panel for combining or subtracting shapes to create new forms.ExampleUsing Shape Mode, you combine two circles to form a single, larger oval shape.

The real tasks

1 of them
Compare a fact table against the source document to catch swapped figures or unit mismatches before publication.

Who does this

1 roles
Copy Editor

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Illustrator — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.