Login / Sign up
Table transformations

How to replace status or category codes with a small dictionary

2026-06-20
Task

A feed stores status or category as short codes, for example A and N. The final file needs readable values.

Short Answer

For a small dictionary, add several replacement rules in one column: A → active, N → inactive.

How to Do It in Eofferix

  1. Create or open the final status column and choose the code column as the source.
    Opening the status column settings in the Eofferix table editor
    The settings button is highlighted under the final status column.
  2. In Transformations, add a rule: condition Current value equals A, action Replace with, result active.
  3. Add the second rule: condition Current value equals N, action Replace with, result inactive.
    Rules that replace A and N with dictionary values
    The status settings contain two rules: A is replaced with active and N with inactive.
  4. Save the column settings.

Before / After

Before

source data
skustatus_code
SKU-1001A
SKU-1002N

After

result
skustatus
SKU-1001active
SKU-1002inactive

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up