> For the complete documentation index, see [llms.txt](https://docs.kawa.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kawa.ai/03_00_computations/03_03_mapping_columns.md).

# Mapping columns

Mapping columns are a useful feature for performing ad-hoc data enrichment by manually associating values from a dimension with custom mapped values.

## 1. Creating mapping columns

Mapping columns can be created from the Enrich Data section > **Manual Input**.

<div data-with-frame="true"><img src="/files/eDh2wHrJLQioPAVHL3hd" alt=""></div>

They let you input manual mappings for the values of your dimension columns.

For example, you can manually define the desks at which your traders work:

<div data-with-frame="true"><img src="/files/6nF1gGIYX2j1DaQmNzXo" alt=""></div>

*Here, we are defining a mapping column for the Trader dimension. A Desk name was manually selected for each trader of the firm.*

> When a dimension has a high cardinality, some of the available values might be missing from the displayed list. It is recommended to use CSV files to configure exhaustive mappings of large dimensions.

<div data-with-frame="true"><img src="/files/NNSi4nj9QZlZxn66SmrC" alt=""></div>

The name of the newly created mapping column should be entered in the header of the input column, as shown on the screenshot above.

**CSV imports and exports:** Your mapping can be exported as a CSV file and imported into the software.

Below, the CSV associated with the trading desk mapping:

```csv
trader,desk
Alice Brown,EXO
Bob Johnson,EXO
Jane Smith,EXO
John Doe,EXO
Joojoo Boy,CRYPTO
Tom Davis,CRYPTO
```

This CSV file can be edited manually and loaded back in KAWA.

**Handling values without mapping:**

When the mapping does not cover all the values of your dimension, for example: after an ETL, a new trader was added into the system - and they were not assigned to a desk yet.

* *Empty cell:* All the unmapped values will not be filled and left empty.
* *Original value:* Unmapped values will stay unchanged. A trader without a desk will be rendered as the trader name without change.
* *Custom value:* You can define a placeholder there for unmapped values like: N/A etc...

## 2. Editing a mapping column

In the 3 dots menu of a mapping column, click on **Edit Mapping**. You can then change the mapped values (either manually or by loading a new CSV file), you can rename the column and change the behavior for unmapped values.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.kawa.ai/03_00_computations/03_03_mapping_columns.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.