Steps: changing a value before it is used

A step changes a value on its way into a field, a placeholder or a rule, for example to trim it, replace text, format a number or date, or split it into a list. Every step explained, with what happens when a value holds several values.

Updated November 6, 2026

A step changes a value on its way to wherever it's used. Anywhere you set a value in Renable (a catalog field on the Mapping tab, a Set field or Map product fields action in a rule, a placeholder in a Studio template, a channel field, a prompt), you can add steps with "+ Add step". They run in order, top to bottom, each working on the result of the one above, and the value from the last step is the one that's used.

For how rules and mapping fit together, see Fixing your feed data with rules and Mapping your feed to catalog fields.

Where steps live#

Click a placeholder chip (a feed column in a rule or mapping, a product field in a template or channel) to open its value editor. It shows the value's steps, with "+ Add step" underneath, grouped as Text, Numbers and Lists. Each step shows its settings when you expand it, and the editor shows what each step produced for a real product. Drag a step to reorder it, and use the bin icon to remove it.

The same steps are available everywhere, except that QR code is offered on Studio templates, channels and prompts, and not on a catalog's mapping and rules.

A step on a mapping or rule runs on every import. A step on a template or channel runs every time the template renders or the channel runs.

Text steps#

StepWhat it doesExample
ReplaceReplaces every occurrence of one piece of text with another. Search for is matched as written. Search for and And replace with take text you type or a chip from the placeholder menu (a product field, or in a catalog another column), mixed with text, such as Brand followed by a space. If a field in Search for has no value on a product, nothing is replaced. If a field in And replace with is empty, the match is removed; if the product doesn't have that field at all, the value stays as it is.SALE! Blue jacket → Replace SALE! with nothing → Blue jacket; Blue Air Headphones → Replace Brand and a space with nothing → Headphones
RegEx replaceLike Replace, but Search for is a regular expression, so one step can match a whole family of text: any word in a list, any number, anything in brackets. An invalid pattern, or a replacement that refers to a group the search doesn't have, is refused when you save or publish, with the step named in the message. In a replacement, $1 or ${name} inserts what a group matched, \$ writes a dollar sign and \\ a backslash. A field you insert is matched as written.Jacket (2024) → RegEx replace \s*\(.*\) with nothing → Jacket
UppercaseMakes the whole value capital letters.blue jacket → BLUE JACKET
LowercaseMakes the whole value lowercase.BLUE JACKET → blue jacket
Titlecase (first letter)Capitalizes the first letter. A value written entirely in capitals is lowercased first.BLUE JACKET → Blue jacket
Capitalize wordsCapitalizes the first letter of every word and lowercases the rest.blue JACKET → Blue Jacket
Strip HTMLRemoves HTML tags and turns HTML entities back into plain characters, for a description that arrives as web markup. Paragraphs and line breaks become plain line breaks.<p>Warm &amp; light</p> → Warm & light
Trim whitespaceRemoves spaces, tabs and line breaks from the start and end of the value. Spaces inside the value stay.Blue jacket → Blue jacket
Map valuesTranslates values through a table you fill in, one row per From → To. A row has to match the whole value. Matching ignores capitalization unless you switch on Case sensitive, and it doesn't trim, so add a Trim whitespace step first if your values carry spaces. A value with no row passes through unchanged, or becomes what you put in Default for unmatched values.in_stock → Map values in_stock → in stock, out_of_stock → out of stock → in stock
Build textWrites new text around the value. Type text and insert placeholders, including Value, which stands for the value as it is at this step. A new Build text step starts as just Value, so it changes nothing until you edit it.4490 → Build text with Value followed by kr → 4490 kr
QR codeTurns the value, usually a link, into a QR code image in the color you pick. Studio templates, channels and prompts only.A product link → a QR code of that link

To translate many values at once, such as your own category names onto an ad network's, a mapping table scales better than Map values.

Number and date steps#

These are in the Numbers group.

StepWhat it doesExample
Format numberWrites a number the way you want it read: Round to decimals (empty means As is, the number's own decimals), and a Decimal separator and Thousands separator that each start on the separators of the catalog's language. The menu says which, for example Catalog language (sv-SE: 4 490,50), or reads Catalog default where the page doesn't know which catalog the value is for. It turns the number into text.4490.5 → Format number, 2 decimals → 4 490,50 on a Swedish catalog
Format dateReads the value as a date and writes it in the Output pattern you give, such as yyyy-MM-dd or dd/MM/yyyy. A pattern with a month name (d MMMM yyyy) writes it in the catalog's language, and Time zone picks the clock it is written in. It turns the date into text.2026-10-06 → Format date dd/MM/yyyy → 06/10/2026
Date differenceCounts from the value's date to the Other date (Today's date, or another field such as a sale start date) in the Unit you pick: minutes, hours, days, weeks, months or years. The result is a whole number, negative when the other date is earlier, so a Math or Format number step can follow it.2026-09-26 → Date difference in days to Today's date, on 6 October → 10
Shift dateMoves the date by an Amount of the Unit you pick: a whole number you type, negative to move back, or a field from your feed. The result is still a date, so a Format date step can follow it.2026-10-06 → Shift date +7 days → 2026-10-13
MathDoes one calculation with the value: Add, Subtract, Multiply or Divide by the number you give, or by another field you pick. The result is a plain number: 4939, never 4939.0.4490 → Math Multiply by 1.1 → 4939

A number is written exactly as it is unless a Format number step says otherwise; a Format number step's separators left on their first option are the catalog language's. See Languages and localization. What the date steps can read, how they count, time zones and what Today's date costs are in Working with dates.

  • Put Math before Format number. Format number turns the number into text, and a Math step after it has to read that text back as a number and can get it wrong. Text steps are fine after it, such as a Build text step that adds the currency.
  • Put Date difference and Shift date before Format date. Format date turns the date into text, so a date step after it has nothing to work with, and Publish refuses that order. A Math or Format number step directly after Shift date is refused too, because both need a number. See When Renable won't publish.
  • A value that can't be read as a number or a date counts as missing, so the placeholder's fallback takes over, as it does for a product with no value at all.

Typing a number#

A number you type into a step, a rule's condition or a monitor reads the same in every catalog. A dot or a comma is the decimal separator, so 1,50 is 1.5 and 1.000 is 1. Thousands separators and units aren't read, so 1 000 and 12 kr aren't numbers: type 1000 or 12.

Lists: when a value holds several values#

Some values hold several values at once. In a catalog that's a column your feed repeats for a product, such as additional_image_link with four images. Anywhere else it's what a Split step makes. In a CSV or TSV feed, or a Google Sheet, several values usually share one cell separated by commas: a Split step turns that cell into a list, and for the image columns the automatic mapping adds one for you (see Mapping your feed to catalog fields). A column that holds several values for some rows shows a list icon beside its type in the Feed columns rail on the Mapping tab.

Text, number and date steps run on each value and keep the list a list. Four image links with a Replace step come out as four image links. A number or date step drops the values it can't read and keeps the rest. The value counts as missing only when none could be read, and the step's row in the value editor says how many were left out.

Where one value is needed, the first one is used. That applies to:

  • a field that holds one value (Title, Price, Image link)
  • text built from several pieces, such as the brand column, a dash, then a list
  • a Split step
  • a group key or a lookup key
  • the value a condition compares against
  • a computed field using Sum, Average, Smallest, Largest, Any or All (Values, Distinct values, Distinct count, Sorted first and Sorted last look at every value)

The first value is read as it is, so if it's blank, the result is blank, and the rest go unused. To choose another value, or keep them all, add a step from the Lists group before that point: First, Last or Nth to pick one, Join to write them all into one text.

A condition on the column itself looks at every value. "Contains x" matches when any value contains it, and a "does not" condition only when none does. Is blank and is not blank each match when any one value does. On a column declared Number or Date, a single value that can't be read fails the whole condition for that product.

A list that comes out empty, such as after a Filter that kept nothing, stays empty. The field ends up blank, and a fallback doesn't take over, because the Filter was your choice.

List steps#

StepWhat it doesExample
SplitTurns one text into a list, cutting it at the Delimiter (a comma if you leave it empty). Max parts keeps at most that many pieces, and the last piece keeps everything after it, so a,b,c with Max parts 2 gives a and b,c. Trim whitespace cleans the spaces around each piece and Remove empty items drops the empty ones (both on for a new step). Regular expression reads the delimiter as a pattern; an invalid one is refused when you save or publish, with the step named in the message. If the value is already a list, only its first value is split.red, blue, green → Split on , → red · blue · green
JoinWrites a list as one text, with the Separator between the values (a comma if you leave it empty).red · blue · green → Join with , → red, blue, green
Map eachRuns its own list of steps on each value. Text and number steps already work on every value, so you need it only when the inner steps include a list step, above all Split. See the recipe below.A list of color/size codes → Map each with Split on / then First → the colors
FilterKeeps the values that pass a condition, using the same conditions a rule does, and drops the rest. After a Split the values are text, so a number comparison such as is greater than matches none of them until a Math step inside a Map each has turned them into numbers. The value it compares with can be text you type or a chip from the placeholder menu. A filter Aimée set up with several conditions shows as Complex filter and can't be edited in the step: ask Aimée to change it, or delete the step and add a new one.Four image links → Filter doesn't contain placeholder → the real ones
FirstKeeps the first value. On an empty list the result is blank.red · blue · green → red
LastKeeps the last value. Nth counts from the start only, so this is the way to the end of a list.red · blue · green → green
NthKeeps the value at a Position, counted from 1. A position past the end gives a blank, and with no position set the step does nothing.red · blue · green → Nth position 2 → blue
DedupeDrops repeated values, keeping the first of each. Exact repeats only, so Red and red are different values.red · blue · red → red · blue
FlattenTurns a list of lists into one list, one level deep. You need it after Map each with a Split inside it.(S · M) · (L) → S · M · L

The list steps treat a single value as a list of one, so Filter keeps it or drops it, and First, Last and Join give it back as it is.

Recipe: split every value, not just the first#

A Split step on a list splits only its first value. To split each value, say a feed that repeats sizes per product, each holding S/M/L, use three steps:

  1. Map each, with a single Split step inside it on /. Each value becomes its own list.
  2. Flatten. The lists become one list.
  3. Whatever you want next: Dedupe, Join, or nothing, if the field takes several values.

Recipe: keep every image after cleaning the links#

A repeated additional_image_link column mapped to Additional image link keeps all its images, and a Replace step on the mapping, rewriting w_200 to w_1200 say, runs on every link. The same column mapped to Image link gives the first link only, since Image link holds one. Add a Last or Nth step to pick a different one, or a Filter first if the first link can be a blank or a placeholder.

When Renable warns that only the first value is used#

If a mapping or rule reads a column with several values at a place that takes one, Renable warns you. For example: "The Image link mapping: “additional_image_link” holds several values in 1,234 rows of your feed and only the first will be used. Add First, Last, Nth or Join to choose."

You see it on the catalog's Activity tab and in the publish dialog. It describes your setup, so it doesn't mean an import failed. Templates, channels and prompts use the first value without a warning.

What to do#

  • The first value is right: add a First step. The warning goes away.
  • You want another value: add Last or Nth, or Join to keep them all as one text.
  • On a Split step: add First, or use Map each, Split and Flatten to split every value.
  • "A list of lists": a Map each with a Split inside loses values even in a field like Additional image link, which otherwise keeps every value. Add Flatten.
  • You don't want to change anything: archive the warning. It comes back only if it gets worse, for example if a "may" becomes certain.

Reading the warning#

  • "The Image link mapping" is that row on the Mapping tab. "The rule 'Colors'" is that rule on the Rules tab.
  • "In 1,234 rows of your feed" counts rows in the feed file as it arrives, before rules and splits. "In at least 1,234 rows" or "in 3 of the 50 sampled rows" means Renable has read only part of the feed.
  • "May hold several values" means Renable can't be sure, for example after a Filter or an Otherwise branch, or for a column it didn't reach. These are minor issues: they show on the Activity tab and the project's Overview, but not in the dashboard's Needs attention queue. A certain warning does appear there, however few rows it affects.

Warnings don't list products. To see a real one, find the column in the rail on the Mapping tab and use "Trace a product that has a value in this column". See Imports, warnings, and tracing a value.

What the editor shows while you edit#

The same check runs in the catalog workspace as you edit, so you can fix a warning before you publish.

  • On the Rules tab, an expanded rule shows one line per place, such as "Then, action 1, the Title mapping, step 2: “additional_image_link” can hold several values and only the first will be used for the Title field." A certain warning and a "may" both show in warning colour, and only the wording tells them apart. A collapsed rule shows one line instead: "Uses only the first of several values in 2 places."
  • On a Split step, the same sentence sits on the step in the value editor.
  • On the Mapping tab, a field's row carries the sentence under its value. A place in the mapping's conditions is shown once above the table.
  • "Warnings may be incomplete" means the editor couldn't check a ruleset the rule applies, because it couldn't load it or the ruleset nests too deeply. If the check can't run on your rules at all, the editor says so, and publishing still checks them.

What the trace shows#

A trace shows all of a value's values (a · b · c, then +2 more), and the type badge reads List · 5. It also shows two things the warnings can't, because they depend on one product's values:

  • A blank first value. If the first of several values is blank, the field gets nothing and a Split splits nothing. Add a Filter step (is not blank) before it.
  • A list of lists that loses values for this product. Add Flatten.

Or ask Aimée#

Ask Aimée to "take the last image link instead of the first". She can add the step, then publish once you approve.

Related articles#