# Transform mapping/lookup tables (services)

{% hint style="warning" %}
This page is due to be updated shortly. Until then, your screens may look a little different to the examples shown here. 
{% endhint %}

### Add a new transform map

1\. In the menu click \[Settings]

![](/files/O0Me3T5cASiR0hASf69n)

2\. In \[Settings] click \[Transform Maps]

![](/files/qYtOcQHBNXFQn3tXh7nQ)

3.Click \[Add new]

![](/files/4DoPu2WgYbQHIxT3PiC4)

4.Enter a descriptive name (this will be used later on lists to help identify the map).

{% hint style="info" %}
The \[Default Value] will be used if no matching value is found in the map.
{% endhint %}

![](/files/wX8WJjnugyGLaUJLRm82)

5.Click the add new row ➕

![](/files/4IVXNVoPZrPa6kwZuGDo)

6.Add your lookup values (what each systems data needs converted to)

![](/files/UhNd29Oognh5iFxRhTre)

7.Click \[Save Map]

![](/files/ba2wyn0FErcohlcZUBWR)

### Using a transform map

1.Follow the \[Field transform] steps to choose a transform function

2.Select \[Map] as your transform function

3.Select the map preset (any custom maps will be added here)

![](/files/GX4Dw6gDKuaFcG4jKqtC)

4.Review the Data map selected

5.(Optional) The direction arrow will show which side is used as the source.  Clicking the \[Direction] arrow will change the change the source and destination direction

![](/files/XVks2ka41dPCP5mkz4TM)

6.Click \[Save Function]

![](/files/jinJsDW4G1DIxHnYapci)

### Updating a transform map

1\. In the menu click \[Settings]

![](/files/O0Me3T5cASiR0hASf69n)

2\. In \[Settings] click \[Transform Maps]

![](/files/qYtOcQHBNXFQn3tXh7nQ)

3.Click \[Manage] on the map you want to edit

![](/files/4DoPu2WgYbQHIxT3PiC4)

4.Make the changes required

![](/files/UhNd29Oognh5iFxRhTre)

5.Click \[Save Function]

![](/files/ba2wyn0FErcohlcZUBWR)

###

### Deleting a transform map

1\. In the menu click \[Settings]

![](/files/O0Me3T5cASiR0hASf69n)

2\. In \[Settings] click \[Transform Maps]

![](/files/qYtOcQHBNXFQn3tXh7nQ)

3.Click \[Edit] on the map you want to edit

![](/files/4DoPu2WgYbQHIxT3PiC4)

4.Click \[Delete Transform Map]

{% hint style="warning" %}
Removing a transform map that is being used by a service will cause the mapping to fail
{% endhint %}

![](/files/liRqmNxe7cjvXHdoLPM6)


---

# 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://doc.wearepatchworks.com/product-documentation/patchworks-services/working-with-services/field-mappings-and-transformations-services/transform-mapping-lookup-tables-services.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.