> For the complete documentation index, see [llms.txt](https://doc.wearepatchworks.com/product-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.wearepatchworks.com/product-documentation/patchworks-services/working-with-services/field-mappings-and-transformations-services/transform-mapping-lookup-tables-services.md).

# 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)