Task
A supplier file stores the product name in separate brand, model, color, and size columns. The export needs one name column.
Short answer
Create the name column and add a Replace with rule using {brand} {model} {color} {size}.
How to Do It in Eofferix
- Open the settings of the output
namecolumn.
The click is on the settings icon of the output namecolumn. - In
Transformations, addReplace with:{brand} {model} {color} {size}.
The template takes values from brand,model,color, andsizein the same row. - Save the column settings and go to the
Exportstep.
Before / After
Before
source data| sku | brand | model | color | size |
|---|---|---|---|---|
| SKU-100 | Acme | Desk lamp | black | M |
| SKU-101 | Nord | Office chair | gray | L |
After
result| sku | name |
|---|---|
| SKU-100 | Acme Desk lamp black M |
| SKU-101 | Nord Office chair gray L |