Match by Dictionary

How to insert a dictionary value by an ID stored in the current item or row.

Dictionary matching is useful when the current item contains an ID, code, or key, while the readable value is stored elsewhere: in a section dictionary, another sheet, a JSON array, or a separate XML branch.

Dictionary matching in additional settings
The setting links the current item ID to a dictionary record and inserts the needed value.

Fields to configure

  • What to insert — a dictionary value or a section path.
  • Where the current item ID is stored — the product, offer, or row field used for lookup.
  • Where to take the ID from in the dictionary — the dictionary field that must match the current ID.
  • Where to take the value / name from — the dictionary field that goes to the result.

A common example: the product has category_id, while the section dictionary has id and name. The result can output the section name instead of the numeric ID.

When to enable multiple values

If one field contains several IDs separated by a delimiter, enable multiple values and specify the delimiter. The service matches every ID separately and assembles the result back.