---
schema_version: "1"
id: d37783358e0ca390bc6023e03675570e8d7e958fe0d4b8e9c0c56ff0bc60e081
title: Creating Lookup Tables
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/partner-manager/latest/lookup-tables-create.md
canonical_url: https://docs.mulesoft.com/partner-manager/latest/lookup-tables-create
source_site: docs.mulesoft.com
content_type: documentation
content_hash: 55c8c5c7b3d8bf4f54d7080473d88e8f22113cd826e2a5080c22e6f688d58232
description: MuleSoft Documentation Site
release: 2.x
latest: true
---
---
product: Partner Manager
version: 2.x
is-latest-version: true
---

# Creating Lookup Tables

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

Create lookup tables in Partner Manager to support value translation across systems. For an overview
of lookup table types and benefits, see
[Configuring and Managing Lookup Tables](https://docs.mulesoft.com/partner-manager/latest/lookup-tables-overview).

> [!NOTE] Each lookup results in an Object Store v2 call. If you anticipate processing a high volume
> of transactions that use lookup tables, consider an Object Store v2 premium subscription. This
> subscription level removes the standard 10 TPS cap, making sure your message flows remain fast and
> reliable during peak processing times. For more information about rate limiting, see
> [Object Store v2 Rate Limiting and Billing](https://docs.mulesoft.com/object-store/osv2-usage).

## Create a Lookup Table

To create a lookup table:

1.  From the Partner Manager sidebar, select **Lookup Tables**.

2.  Click **New Lookup Table** and select **Composite Key Lookup** or **Cross-Reference Lookup**.

3.  Enter a unique name with no spaces and a maximum of 50 characters. Names can include **\_** and
    **\-** characters.

4.  Optionally add a description.

5.  Click **Next**.

6.  Optionally enable generic lookup so that searches can use any combination of columns to find one
    or more matching rows.

7.  Configure up to 10 columns. Give each column a unique name and use no more than 30 characters.
    For both table types, the **Mandatory** and **Key** options are selected by default for the
    first column and can’t be unselected. For cross-reference lookup tables, both options are also
    selected by default for the second column.

8.  For each column, configure options as needed:

    - **Mandatory** - Column value is required when you add or import rows.

    - **Key** - Column can be used as a lookup input.

9.  Click **Save**.

> [!NOTE] Columns can’t be added or modified after the table has at least one row.

> [!NOTE] If generic lookup is enabled, table limits are lower. A generic lookup table supports up
> to 1,000 rows and 6 columns.

## Add Rows to a Lookup Table

After creating a lookup table, you can add up to 10,000 rows.

To add a row, click **Add Row** and enter up to 200 characters for the value in each column. New
rows are added to the top of the lookup table.

> [!NOTE] Duplicate values aren’t permitted in key columns.

For DataWeave functions and examples, see
[Using Lookup Tables in DataWeave](https://docs.mulesoft.com/partner-manager/latest/lookup-tables-dataweave).

## Import Data from a CSV File

To import data from a CSV file:

1.  Click **Import CSV** and select the file.

2.  Append the data to the existing lookup table or replace the existing lookup table.

    If you replace the lookup table, the existing data is deleted and can’t be recovered.

3.  Click **Import**.

## Export a Lookup Table

To export a lookup table, click **Export CSV**. The lookup table is exported and can then be
downloaded as a CSV file.

## Delete a Lookup Table

To delete a lookup table:

1.  Click **Delete**.

2.  Indicate that you understand that this action can’t be undone and click **Delete**.