Login / Sign up
Table transformations

How to build a category path from several columns

2026-06-20
Task

Category levels are stored in cat_1, cat_2, and cat_3. The result needs one category path without extra separators when a level is empty.

Short Answer

Create category_path from cat_1. Then append cat_2 and cat_3 only when the corresponding column is not empty.

How to Do It in Eofferix

  1. Create the final category_path column from cat_1.
  2. In Transformations, add: condition source cat_2, condition Not empty, action Add to end, result / {cat_2}.
  3. Add the second rule: condition source cat_3, condition Not empty, action Add to end, result / {cat_3}.
    Building category_path with not-empty checks for cat_2 and cat_3
    The rules check cat_2 and cat_3, not “current value — any”. An empty level will not add an extra separator.
  4. Save the column settings.

Before / After

Before

source data
skucat_1cat_2cat_3
SKU-1001ClothingJacketsWinter
SKU-1002ShoesRunning

After

result
skucategory_path
SKU-1001Clothing / Jackets / Winter
SKU-1002Shoes / Running

Process data faster with Eofferix

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

Sign up