Data Transformation Types For Export

It is used for merging values from multiple child mapping records based on the configuration in the following fields:

• Concatenate Child Field Order - In the child mapping record, specify a number that indicates the order of concatenating the fields.

  Example:
  First name and Last name are created as child integration mapping records for the parent integration mapping record Full name.
  To display the Full name field in the format - {First name} {Last name}, where First name should come first and Last name should come second, you need to set the Concatenate Child Field Order for First name as 1 and for the Last name as 2.

• Parameters - In the parent integration mapping record, specify a character or space that will separate the concatenated words.

  Example: To separate the child mapping records with a single space, specify " " in the Parameter field.

It is used to export fields of type date and time.

In the Parameters field, specify the date and time format, and the timezone of the destination system.

You can use one of the following date formats:

• yyyyMMdd
• yyyyddMM
• ddyyyyMM
• ddMMyyyy
• MMyyyydd
• MMddyyyy

The exported date will be segregated into year, month and date values based on the date format. The month format (MM) must be typed in upper case.

Standard date separators can also be used in the format. For example, the format can be dd/MM/yyyy.

It is used to add a prefix to the integration mapping record when the record is exported, based on the following field values:

• Internal Field Name - Specify the field name in Anthology Reach that must be prefixed.

• Parameters - Specify the characters or symbols that must be prefixed.

  Example: To prefix the Country Code field with the + symbol, specify + in the Parameters field.

It is used for replacing the existing field value with a new value during the export, based on the configuration in the following fields:

• Internal Field Name - The field name whose value must be replaced with a new value.

• Parameters - Specify the existing and new values in the following format:

  {Existing Value} >> {New Value}

  Examples

  • Bangalore>>Bengaluru

    In this example, the text Bangalore will be replaced with Bengaluru after the export.

  • >>Bengaluru

    In this example, if the field is blank it will be updated with Bengaluru after the export.

  • Bangalore>>

    In this example, the text Bangalore will be replaced with blank after the export.

It is used for splitting the field values of an integration mapping record during export based on the configuration in the following fields:

• Internal Field Name - The source field name whose data must be used for splitting

• External Field Name - The destination field name where the split value must be added.

• Parameters - Use the following format to specify the character or space that will be used for separating the value and whether the value must be split from the beginning or end:

  {Separator},1

  or

  {Separator},-1

  Where,

  • {Separator} is any character or space. If using space as the separator to split the field value, specify " ".

  • 1 - Indicates to start from the beginning of the field value and split the field value.

  • -1 - Indicates to start from the end of the field value and split the field value.

  Example: The Full name field includes the name as {First name} {Middle name} {Last name}.
  To split the value in the Full name field and update in the First name field, you can create the integration mapping record for the Full name field with the following field values:

  • Internal Field Name - Full name

  • External Field Name - First name

  • Data Transformation Type - SPLIT

  • Parameters - " ", 1

It is used to add a suffix to the integration mapping record when the record is exported, based on the following field values:

• Internal Field Name - The field name in Anthology Reach which must be suffixed.

• Parameters - Specify the character(s) or symbol(s) that must be suffixed.