Using DataLoader with Lookups

What is a Lookup?

A lookup is a type of Salesforce relationship that connects two objects without impacting their security or deletion behavior. It enables linking standard, custom, and external objects through intermediary relationships.

When Should I Use Lookups in DataLoader?

Lookups are ideal when associating two records. For example, to link a Quote to an Account, a lookup field can point to the related Account object (including custom objects).

When Can I Use Lookups in DataLoader?

Lookups can be applied during Insert, Update, or Upsert operations in ARM DataLoader.

Apply Lookups

When performing an Insert task and you’ve uploaded your CSV file, proceed to the Fields Mapping step. There, you'll find a "Lookup via" checkbox.

Example: To map Account Name to Account ID in Salesforce:

• Click the "Lookup via" checkbox.

• Select 'Account Name' as the field to search by.

ARM DataLoader will search for the Account ID using the provided Account Name and populate the correct IDs expected by Salesforce.

More Lookup Options

• Use first match in multiple results: If multiple records match the selected non-unique field (e.g., several accounts named GenePoint), then DataLoader selects the first match automatically.

• Mark record with an error if more than one match is found: If enabled, ARM DataLoader flags the row with an error stating multiple matches exist. You can resolve this by fixing the data in Salesforce or by manually providing the correct ID in the CSV and re-uploading.