# Mapping

💡 Here you will choose which columns in your Source data should be mapped to which Salesforce fields.

## General Mapping Information

### Lookup Relationships

💡 Use Lookup Relationships to link records with other records in Salesforce e.g. link a Contact with an Account

You can link, and lookup relationship records in Dataimporter, using any Text, Email, or Phone field in Salesforce. To do this, choose the source column you want to use for the lookup, and the Salesforce object and field you want Dataimporter to look for records with:

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

If you have the Salesforce Id in the source data then you can map it directly without using a lookup relationship:

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

### Formulas

Here, you can map your formulas, to the corresponding Salesforce field:

<figure><img src="/files/7qAxQh9HGIohq1GSsrjZ" alt=""><figcaption></figcaption></figure>

Formulas are shown with the ♾️ symbol before them.

## Insert

One the Mapping page for an Insert Job you will choose which source fields should map to which Salesforce fields.

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

## Update & Upsert

On an Update or Upsert Job, you will have the same mapping options as the Insert Job, plus an additional mapping to select which Source and Salesforce fields should be used to determine which records to update:

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

{% hint style="info" %}
For Update Jobs, you can choose any Text, Number, or Id Field to match records. For Upsert Jobs, you can choose any Field marked as External Id.
{% endhint %}

## Delete

For a Delete Job, you simply choose the source field, which contains the Salesforce Id values for the records which you want to Delete.

![](/files/9S6KzuXgl1SAnWt78jkP)


---

# 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://help.dataimporter.io/jobs/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.