Concatenated Field

Erstellt von Igor Galic, Geändert am Wed, 03 Aug 2022 um 01:01 PM von Igor Galic

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 

 

War dieser Artikel hilfreich?

Das ist großartig!

Vielen Dank für Ihr Feedback

Leider konnten wir nicht helfen

Vielen Dank für Ihr Feedback

Teilen Sie uns mit, wie wir diesen Artikel verbessern können!

Wählen Sie wenigstens einen der Gründe aus

Feedback gesendet

Wir wissen Ihre Mühe zu schätzen un werden versuchen, den Artikel zu korrigieren