> For the complete documentation index, see [llms.txt](https://endash-guidance-docs.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://endash-guidance-docs.gitbook.io/docs/dashboard/lookup-table.md).

# 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FvlHnpN8N8w1dz39ECUNo%2Fimage.png?alt=media&amp;token=bd3511bd-6e60-4262-8ce8-ec711f306925" alt=""><figcaption></figcaption></figure> <figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FRRU0pJvNxmfIWgonL5J6%2Fimage.png?alt=media&amp;token=091f7a04-ca24-4ff6-9e02-623eaf1012d0" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FvdUGSZ0aoMbNUnU6fdig%2Fimage.png?alt=media&amp;token=0a0f5482-96de-4ebb-93a2-84b34ef8b157" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FX8NLU845NmMDd3AmzQCM%2Fimage.png?alt=media&amp;token=92388d78-906d-453f-8c4d-64f552ac32a9" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FPlG8m6VKffsWjqW4EdSI%2Fimage.png?alt=media&amp;token=ed7b3aa4-436f-4811-9bac-45297fc6b732" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FAAOl5UQKpd4IHPpeM06b%2Fimage.png?alt=media&amp;token=af52b7fc-4bc5-44ee-af13-d123f5e396d5" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FawFpxFHvDY0rN3LIfdyK%2Fimage.png?alt=media&amp;token=1c2df80b-636a-4ba7-90ee-70c7e2fe24e4" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2Fpj0lPdsaJnv8RRNkb3EK%2Fimage.png?alt=media&amp;token=07a43618-8dc2-405d-ac0c-5c9d55bcd8d6" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FjUfE5DO4sExPItOCzxOU%2Fimage.png?alt=media&amp;token=d956c603-f65c-4f01-99e1-d43675867560" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FD8pSnDZxk3fem3Uu92tN%2Fimage.png?alt=media&amp;token=6fa510f5-3b6a-47c3-837b-a805455c3a45" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FVcH11gaaehBGRGPZvjtA%2Fimage.png?alt=media&amp;token=6d6a6767-8db0-422e-a6c6-e6c05f9db1ed" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FNFUVff5VWF44lnGjaqyI%2Fimage.png?alt=media&amp;token=b3bb9d63-7074-4c89-ab03-5abcb2e8ec29" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F5Fud8g9gawb2mXU04Hhn%2Fimage.png?alt=media&amp;token=6dc4bc1c-61bc-44fd-957f-6c5c36e60c0c" 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="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FjJDoqBV3eb6T7tOkt89z%2Fimage.png?alt=media&amp;token=eac3117f-36ec-4d29-af9b-2235cb1331b9" alt=""><figcaption></figcaption></figure>

* You can add as many as Lookup table.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FpbaayZ2lA55mtwWoQ2rO%2Fimage.png?alt=media&amp;token=27c1ea8d-9ef3-4653-a44a-abbbd34f747e" alt="" width="563"><figcaption></figcaption></figure>

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

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FnWjZGUpST8cwFT5ED5pz%2Fimage.png?alt=media&amp;token=b45dcbf8-f35c-4f72-a686-2299a7989149" 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 %}