Skip to main content
Maps values from a source field to new values using a lookup dictionary - similar to VLOOKUP in spreadsheets. Supports inline key-value pairs, entity-based dictionaries, and fuzzy matching.

​
Configuration

​
Inline Dictionary

​
Entity Dictionary

​
Match Modes

​
Fuzzy Matching Options

​
How It Works

1

Select the source field

Choose which field contains the values to look up.
2

Define the dictionary

Use inline key-value pairs for simple mappings, or reference an entity for larger dictionaries.
3

Choose a match mode

Use Exact for clean data, Fuzzy for messy data, or Regex for pattern-based mapping.

​
Output

A new field containing the matched dictionary value. For entity mode with multiple value fields, multiple columns are returned (like a multi-column VLOOKUP).

​
Examples

​
Inline: Map country codes to names

  • Source Field: Country Code
  • Dictionary Source: Inline
  • Entries: US → United States, GB → United Kingdom, DE → Germany
  • Default: “Unknown”

​
Entity: Fuzzy company name matching

  • Source Field: Company Name
  • Dictionary Source: Entity (reference list of canonical company names)
  • Match Mode: Fuzzy
  • Threshold: 80
  • Noise Words: “Inc, LLC, Ltd, Corp”

​
Best Practices

  • Use Inline for small, static dictionaries (< 50 entries)
  • Use Entity for large or frequently updated dictionaries
  • Start with a higher fuzzy threshold (80+) and lower gradually if needed
  • Use Noise Words to strip common suffixes before fuzzy matching (e.g., company suffixes)
  • Use Collect All mode when you need to aggregate all matching values
  • Reference Lookup - looks up matching rows and formats as text
  • Transform - use CASE expressions for simple value mapping without a dictionary
  • Find Duplicates - fuzzy matching across records rather than against a dictionary