# Mapping and Properties transformation

## Transform data before it gets to the destination.

In some case, you would need, for a specific destination, to transform your event before it is sent to the destination.\
\
\&#xNAN;*Properties transformation* support currently renaming or deleting properties.

Enter on the left the property name you want to add or delete. Then enter on the right the property name to map (or leave empty to remove the property)

<figure><img src="/files/T6OiMpvTjGeY5dZIbGAn" alt=""><figcaption></figcaption></figure>

## Smart mapping

{% hint style="info" %}
Deployment in progress for all destinations
{% endhint %}

The smart mapping feature shows the mapping between standard events/properties and destination partner properties.

<figure><img src="/files/PBdjFVPvR4upAVw6Sz9N" alt=""><figcaption></figcaption></figure>

Ex: Standard property: value ⇒ Partner property: revenue

If needed, you can modify this mapping, with custom properties for example.

## Text input (settings)

On settings configuration, you can simply enter values with the text input.

Use brackets button {{ }} to enter a dynamic value, like a property name. Without brackets, the value is considered as a string.

Examples:

* `{{price}}`corresponds to the property price, the output will be "12,30" for example.
* `price` corresponds to a static value, the output will be "price".
* `{{price}} excl.taxes` corresponds to the property price concatenated with the string 'excl.taxes', the output will be “12,30 excl.taxes” for example.

<figure><img src="/files/fehXVvfUypY0Ebykc1rG" alt=""><figcaption></figcaption></figure>

If you click on the *T* icon, you can switch to functions mode.

## Functions (settings)

Use no-code formulas to transform properties. You can use more than 25 formulas (list [here](/features/data-quality/data-cleansing/supported-transformation-functions.md)).

<figure><img src="/files/jqSvTpnSuyI219153NtR" alt=""><figcaption></figcaption></figure>

In settings, functions could be useful to define a complex value, for example a concatenation of 2 properties to create a unique ID required by the destination.

## Functions inside smart mapping

{% hint style="info" %}
Coming soon
{% endhint %}

These functions are also available in the [smart mapping feature](#smart-mapping), to easily transform properties before to send to the destination.

For example, if a destination requires MD5 email, you can select the email in clear and apply the MD5 formula to turn the clear email into a MD5 email, only for this destination (if it is for all destinations, please use our [Data Cleansing](/features/data-quality/data-cleansing.md) feature).

Other example, if a destination requires a price with "." (ex: 12.30), but in your database prices are stored with a "," (ex: 12,30), you can transform the data with a dedicated formula to turn the "," into a "."


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.commandersact.com/features/destinations/advanced-mapping.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
