> This page is for Unified.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.merge.dev/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.merge.dev/_mcp/server.

# AI data transformations

> How to use Merge's AI assistant to auto-generate JSONata transformation expressions for Field Mapping, instead of writing them manually.

---

## Overview

Advanced field mappings let you transform remote field data using JSONata expressions before mapping to a target field. However, writing JSONata expressions can be complex — particularly when working with deeply nested objects or multi-field conditions. Merge's AI-assisted transformation lets you describe the transformation you want in plain language and generates the expression for you.

This feature is available directly within the advanced mapping setup flow in the Merge dashboard.

## How it works

The AI accepts a plain language description of the desired transformation and returns a JSONata expression, evaluated against the remote field's sample data. The expression can be edited before applying.

## Example

**You write:**

> If employment type is full-time, return annual salary plus bonus, otherwise return just the annual salary

**Merge generates:**

```
employment_type = "FULL_TIME" ? annual_salary + bonus : annual_salary
```

To read the transformed values in API responses, see Access mapped data.