> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Concatenated Field

## TABLE OF CONTENTS

* [1. What is Concatenated Field](#1.-What-is-Concatenated-Field)
* [2. Concatenated Field Options](#2.-Concatenated-Field-Options%C2%A0) 
* [2.1 Name](#2.1-Name)
* [2.2 Concatenation character (s)](#2.2-Concatenation-character-(s)-%C2%A0)
* [2.3 Prefix](#2.3-Prefix%C2%A0%C2%A0)
* [2.4 Postfix](#2.4-Postfix%C2%A0)
* [2.5 Concatenate column](#2.5-Concatenate-column%C2%A0)
* [2.6 Skip Empty Values](#2.6-Skip-Empty-Values%C2%A0)
* [2.7 Result](#2.7-Result%C2%A0%C2%A0)
* [3. Example and how to use it](#3.-Example-and-how-to-use-it)

### 
---
### 1. What is Concatenated Field

The concatenated field is used to merge 2 or more fields to get a Unique field per use-case to be able to map certain fields that you couldn't map without it. It is somewhat reversed from the Split field.

**Note: If you select fields from multiple collection fields, collection from the last selected field will be used as source data.**

###

### 2. Concatenated Field Options

![](https://storage.crisp.chat/users/helpdesk/website/-/5/2/7/0/52708cb7cc353000/6de974c3-4577-457f-b2b8-c15b94_1gu72c1.png)

#### 2.1 Name

The name of the Concatenated Field you would like to see in the Mapping section.

#### 2.2 Concatenation character (s)

This character(s) will be used to concatenate selected columns.

#### 2.3 Prefix

Entered text that will be added to the beginning of a resulting value.

#### 2.4 Postfix

Entered text that will be added to the end of a resulting value.

#### 2.5 Concatenate column

The Column you would like to concatenate and use in the Mapping section.

#### 2.6 Skip Empty Values

If this option is turned on, columns without values will be skipped as if they are not part of the concatenation. For example, if column name, color, and SKU are combined and color does not have value for a specific record, the result will be name/SKU. If this option is turned off, the result would be name//sku

#### 2.7 Result

Result of the desired fields you would like to concatenate together.

### 3. Example and how to use it

Example: Google Sheet to CSV Name and Surname to Full Name

To create and set a Concatenated Field. We can do this by going to the mapping section, and on the bottom left corner click on the **"+"** sign then click on **Concatenated Field.**

![](https://storage.crisp.chat/users/helpdesk/website/-/1/3/9/7/1397c6b0035c8200/3fba9c03-9697-4174-b882-62e16b_17w3mau.png)

We will be concatenating **"Full name"** with a prefix of Mr.

First, we will use the field name and click on a **"+"** sign, then we will be adding a surname field too.

The value we have for **the first name is Igor and Surname is Galic.**

This is how the settings look after we Mapped everything:

![](https://storage.crisp.chat/users/helpdesk/website/-/f/5/f/7/f5f734db9c543800/335485fb-3a26-4aa7-a73a-9f6b62_3v0m6z.png)

After you have mapped everything, just connect the Concatenated field with the Full name field, and voila!

![](https://storage.crisp.chat/users/helpdesk/website/-/5/5/b/2/55b2d54dda107000/b8c54981-de3d-49c1-b237-19696d_mxlr3p.png)

As you can see everything is as intended in the preview values

![](https://storage.crisp.chat/users/helpdesk/website/-/6/e/3/1/6e310154ed57f800/8c832193-0c46-4693-b8ab-e2b488_13oov2g.png)

With this, we will end our Concatenated field Article.

---
We hope that this covers everything. If you have any further questions or need additional clarification please reach out to us via [[email protected]](/cdn-cgi/l/email-protection#eb989e9b9b84999fab98928588989b828f8e99c5888486) or our Chat Widget!