# RowMerge

This Expression constructs a string from a multi-record Databox such as can be achieved by selecting the multi-record-set option on a [SQL Query](/product-suite/admin/entities/databoxes/sql-query.md) or HTTP databox. 

The syntax of the call is:

1. format - a string containing a string with square bracketed column names to indicate the positions at which the column values should be substituted into the string
2. separator - a string containing the characters to use between each formatted string when joining the result together

<table><thead><tr><th>Expression</th><th>Databox Value</th><th width="88">Result</th><th>Comments</th></tr></thead><tbody><tr><td><code>RowMerge("[name] ([userId]), ",")</code></td><td>&#x3C;KFXmlValue rows="1">&#x3C;KFRow id="0">&#x3C;userId>1&#x3C;/id>&#x3C;name>George Smiley&#x3C;/name>&#x3C;/KFRow>&#x3C;KFRow id="1">&#x3C;userId>2&#x3C;/id>&#x3C;name>Ann Sercomb Smiley&#x3C;/name>&#x3C;/KFRow>&#x3C;/KFXmlValue></td><td>George Smiley (1), Ann Sercomb Smiley (2)</td><td>This expression compliments FieldMerge that achieves this goal only for the first record of a databox result (if multiple records exist).</td></tr></tbody></table>

{% hint style="info" %}
RowMerge is useful when you require a comma separated list of results from a SQL or HTTP databox.
{% endhint %}


---

# 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://docs.keyfax.biz/product-suite/admin/databox-expressions/text-expressions/rowmerge.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.