How to combine multiple values into one field

Value concatenation helps to assemble one resulting field from several JSON/XML columns or parts.

When to use

Example: product name from brand and model, address from city and street, description from several characteristics.

How to set up

1. Select a summary field.
2. Add the values you want to connect.
3. Specify the delimiter: space, comma, semicolon, or line break.
4. Configure skipping empty parts to avoid getting extra delimiters.
5. Check the result on lines with different sets of filled fields.

What will happen

The resulting file will have one neat value instead of several disparate parts.

What is important to remember

• The separator must be understandable to the receiving system.
• For HTML descriptions, it is better to agree on hyphens and tags in advance.