# RowMerge

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

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>