Concatenated Field

Concatenated field is used to merge 2 or more fields to get an Unique field per use-case to be able to map certain fields that you couldn't map without it. It is somewhat reverse from Split field.

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

Here all all the options for Concatenated field: 

Name - Name of the Concatenated Field

Concatenation Character(s) - A Special character that will stand in between the Fields that you are concatenating, so in this case it will be Name (special character ) Surname . It can be "." "-" , space or any kind of special character that you wish to use.

Prefix - A Letter or a number before the concatenated field so in this case you can put Mr, Sir, Miss etc.

Postfix - A Letter or number after the concatenated field 

Concatenate Column - Here is where you choose the fields you are concatenating, after you choose a field click on a "+" sign to add it to concatenation

Skip empty values - Skip all the fields that doesn't have a value in concatenated field

Result - a preview of how the field will look after you have configured this field.

This is how the settings look after we Map everything 

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

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