By Team Hypomnema · Data
Replace codes and labels using a checked reference dictionary.
Use the guide alongside the working tool.
Open Data Value Mapper →Explicit working sample
id,region,product,amount,units,date
001,North,Notebook,24.5,2,2026-10-01
002,South,Pen,9,3,2026-10-02
003,North,Pen,15,5,2026-10-03
004,West,Notebook,,1,2026-10-04
005,South,Notebook,49,4,2026-10-05
006,North,Pen,1200,2,2026-10-06Replace codes and labels using a checked reference dictionary. Dictionary has from/to columns or your selected source/target names. Duplicate normalized source keys are rejected. Matching can trim whitespace and ignore case; original unrecognized values can be retained, blanked or rejected. This is a value lookup, not a multi-table row join.
Prepare the input
Replace codes and labels using a checked reference dictionary.
CSV, TSV and arrays of scalar JSON objects are supported. Identifiers stay text. Empty cells are missing by default; add special missing tokens only if their meaning is certain. Use the sample to inspect the exact workflow.
Review the method
Dictionary has from/to columns or your selected source/target names. Duplicate normalized source keys are rejected. Matching can trim whitespace and ignore case; original unrecognized values can be retained, blanked or rejected. This is a value lookup, not a multi-table row join.
Keep the useful output
Review the summary and result records. Transformation tools retain separate change, rejected-record or diagnostics datasets where relevant. Choose the dataset before exporting; a report and a cleaned dataset serve different purposes.
CSV exports protect formula-like text. JSON keeps data portable without making an Excel workbook. Reports and editable backups may contain private source values; download only what you intend to share. No automatic account storage or server processing is used.
Ready to apply this workflow?
Try Data Value Mapper →Explore a related workflow
- Group & Aggregate Data: methods and data limits
Summarize records by multiple keys with explicit aggregate measures.
- Pivot & Unpivot Data: methods and data limits
Reshape long records into wide data, or turn wide columns into rows.
- Data Filter Builder: methods and data limits
Keep or exclude records using typed, exportable filter conditions.
- Column Split & Extract: methods and data limits
Extract structured pieces from a column while keeping the original values.
Keep your original files and review the result. Found unclear instructions? Contact Team Hypomnema.