> For the complete documentation index, see [llms.txt](https://docs.keyfax.biz/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.keyfax.biz/product-suite/admin/databox-expressions/text-expressions/rowmerge-1.md).

# RowMerge

This Expression constructs a string from a multi-record-set, multi-value Databox such as an HTTP Request or a [SQL Query](/product-suite/admin/entities/databoxes/sql-query.md).

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. seperator - the string to use between each row's data e.g. a comma with a space (", ") produces a reasonable output for a list

<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="2">&#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>Tobey Esterhase&#x3C;/name>&#x3C;/KFRow>&#x3C;/KFXmlValue></td><td>George Smiley (1), TobyEsterhase (2)</td><td>RowMerge requires that the databox contains a KFXmlValue with an attribute rows to indicate that it is a multi-record-set result. </td></tr><tr><td></td><td></td><td></td><td></td></tr></tbody></table>