# Lookup table

## Overview

{% embed url="<https://www.youtube.com/watch?v=qwfStgOZc0U>" %}

* Lookup tables let you group raw data into clear categories like turning product IDs into product lines, campaign codes into marketing channels, or region codes into territories... They create a single source of truth, reduce inconsistencies, and make your data easier to monitor and visualize.

## Settings up a Lookup table

<div><figure><img src="/files/fQswrOGv7oi1miPDM7jn" alt=""><figcaption></figcaption></figure> <figure><img src="/files/bCMnIpZu9YT74M4pP4Ay" alt=""><figcaption></figcaption></figure></div>

* In a Widget view, you can click on the Footer or + button on the right side and open the Lookup table setup.

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

* The Name bar is on the top which you can rename it.
* Lookup keys and Lookup values must be set in order to create a Lookup table.
* The preview section will show 100 rows of the table.

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

* Click on Add field and choose column(s) as Lookup key(s).

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

* Click on Add field and choose column(s) with its type as Lookup value(s).

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

* You can change the Lookup values name by directly click on it.

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

* You can remove the current setup by clicking the See more button then choose Remove option.
* Click Create button when all things are setup.

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

* The Lookup table will be in Edit mode for you to input the value properly with its type.

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

* There is also the Sort option to further visuzalize.
* Click Discard to close the Edit mode without saving. Click Save button to apply all the values to the Lookup columns.

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

* When you back to the Main view, you can see the Lookup values is connect the View dependently with the Lookup keys.

## Edit a Lookup table

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

* In  a Lookup view, you can Edit the values again or reconfigure the whole Lookup table.

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

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

* The Lookup keys can be added more or removed.

{% hint style="warning" %}
All values will be reset if you add or remove Lookup keys.
{% endhint %}

{% hint style="info" %}
Only one person in a team can update a Lookup table as a time.
{% endhint %}

## Manage your Lookup table

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

* You can add as many as Lookup table.

<figure><img src="/files/3SZl38wmAi7JxA1bbwpZ" alt="" width="563"><figcaption></figcaption></figure>

* For each Widget view, you can unlink its Lookup table.

<figure><img src="/files/umQSpdwemLMYztbGmS2O" alt="" width="459"><figcaption></figcaption></figure>

* If you choose to delete a Lookup table, a warning message will ask for confirmation.

{% hint style="warning" %}
Delete a Lookup tables will break the view of all widgets linked to it, that you can reset then later.
{% endhint %}


---

# 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://endash-guidance-docs.gitbook.io/docs/dashboard/lookup-table.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.