Concatenation: Building Fields from Parts

A Concatenation field builds one output value out of several parts - fixed text you type plus {{ tokens }} pulled from your data. Use it whenever the value a platform wants doesn't exist as a single column.

How it works

Type the field content as a mix of literal text and tokens. Everything outside {{ }} stays exactly as written; everything inside is replaced per record.

https://mystore.com/p/{{ sku }}

produces a full product URL for every row, while

{{ brand }} {{ model }} - {{ colour }}

assembles a title from three columns.

Good uses

• Product links from a base URL plus an ID or slug
• Titles stitched from brand, model, size, and colour
• Structured strings like a VLA installment string, where separators and units are fixed and only the numbers come from data

Fixed text stays fixed

Separators, units, and punctuation you type (-, /, USD, :) are never altered - only the tokens change. This makes concatenation ideal for formats that must follow an exact pattern.