How to auto-correct naming data

When working with large sets of naming data, mistakes happen — values sometimes end up in the wrong columns. For example, a Brand might be placed in the Product column, or a Region value might land in the wrong spot. The Auto-Correct feature detects these inconsistencies and suggests the correct order of values.

Example

Correct Format

Your taxonomy: Brand | Product | Region

Delimiter: _

Correct entry: Nike_Shoes_US

What Can Go Wrong

Somebody enters: Shoes_Nike_US

• Column 1 (Brand): “Shoes” ❌ (should be Product)
• Column 2 (Product): “Nike” ❌ (should be Brand)
• Column 3 (Region): “US” ✓ (correct)

Auto-Correct Solution

Detects misplaced values and suggests: Nike_Shoes_US.

How to use Auto-Correct?

Step 1: Run Auto-Correct Analysis

1. 1Navigate to the Taxonomy page
2. 2Open Workbook you want apply changes to
3. 3Click Actions in the top toolbar
4. 4Select Auto-Correct

5. 5‍‍System analyzes all naming data in the current view immediately

Step 2: Review Results

If No Issues Found

• You’ll see message: “No inconsistencies found! All naming data is correctly ordered.”
• Process ends, nothing to fix

If Issues Found

• Message: “Found X inconsistencies. Review and apply corrections.”
• Review panel appears with detected issues
• For each record, system shows:
• ID (identifier)
• Current Value (e.g. Shoes_Nike_US)
• Suggested Correction (e.g. Nike_Shoes_US)
• Before/After Parts (which values moved to which columns)
• Checkbox to select suggestion

Step 3: Select Corrections to Apply

Options available:

1. 1Accept All → Applies all corrections at once
2. 2Selective Accept → Choose only the suggestions you trust
3. 3Decline All → Close without changes

Step 4: Apply Corrections

1. 1Click Accept All Changes or Apply Selected
2. 2System updates naming data:

• Moves values to correct columns
• Regenerates the full names with correct order
• Updates all affected records

3. 3Review panel closes
4. 4Updated records appear in taxonomy table
5. 5“Unsaved Changes” indicator shows up
6. 6You must click Save Changes to confirm updates

How Auto-Correct Works

1. 1Extract Values

• Split name by delimiter (e.g., Shoes_Nike_US → ["Shoes", "Nike", "US"])
• Assign to columns based on position

2. 2‍Validate‍

• Check each column against glossary
• Identify misplaced values

3. 3‍Reposition

• Move valid values into the correct columns
• Leave unknown values in place

4. 4‍Generate Suggestion

• Build corrected version (Nike_Shoes_US)
• Show comparison with the original

Edge Cases

• If no valid match exists → invalid value stays where it is
• If multiple matches are possible → first valid one is used
• If everything is already correct → no suggestion is generated

Conclusions

Auto-Correct is a safeguard that keeps your naming data clean and consistent. It automatically finds values placed in the wrong columns and suggests corrected versions based on your glossary.

The process is entirely under your control: you decide whether to accept all changes, apply selected ones, or discard them. Importantly, no data is altered until you approve and save the corrections, making Auto-Correct a safe and efficient way to maintain taxonomy quality.