---
title: "Apply lookup (Field option)"
slug: "apply-lookup-field-option"
description: "Learn how to use lookups to retrieve values from other tables, apply type conversions, and transformations in your integration design process."
tags: ["Task topic"]
updated: 2026-03-20T08:03:15Z
published: 2026-03-20T17:44:14Z
canonical: "docs.staedean.com/apply-lookup-field-option"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.staedean.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Apply lookup (Field option)

You can use a lookup to get a value from another table and use it as the output value of this option. For example, you can get a value from a table that is not in the source document. The other table must have the source field as the single key field. The current value of the '**Modify a value**' process is the input of the lookup. As a result, the value that is returned by the lookup is the value of the **Return value** field. Before determining the output value of this option, you can apply a type conversion or a transformation.

### Steps

1. Click **Connectivity** **studio - Integration Design**.
2. On the **Message** tab, in the list, find and select the desired message.
3. Click **Edit**.
4. In the **Mapping** section, in the **Target record** pane, in the list, find and select the desired target record.
5. On the **Mapping** tab, on the **Field mapping** tab, in the list, find and select the desired field mapping.
6. Click the **Field options** tab.
7. Select the **Lookup** check box.
8. Define the table from which you want to get a value.

In the **Lookup** **table** field, enter or select a value.
9. Define the key field of the table from which you want to get a value.

In the **Lookup key field** field, enter or select a value.

> [!NOTE]
> **Note**
> 
> This key field must be the same field as the source field of the current field mapping.
10. Define the field of the lookup table which value must be returned.

In the **Return** **field value** field, enter or select a value.
11. Before the output value is set, you can apply a type conversion to the returned value.

In the **Type conversions** field, enter or select a value.
12. Before the output value is set, you can apply a transformation to the returned value.

In the **Transformation** field, enter or select a value.
13. Close the page.