RowMerge

Returns a string in list format that contains all referenced data from a multi-record-set Databox (Keyfax version 4.4.8 and later).

This Expression constructs a string from a multi-record-set, multi-value Databox such as an HTTP Request or a 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

Expression	Databox Value	Result	Comments
RowMerge("[name] ([userId])", ", ")	<KFXmlValue rows="2"><KFRow id="0"><userId>1</id><name>George Smiley</name></KFRow><KFRow id="1"><userId>2</id><name>Tobey Esterhase</name></KFRow></KFXmlValue>	George Smiley (1), TobyEsterhase (2)	RowMerge requires that the databox contains a KFXmlValue with an attribute rows to indicate that it is a multi-record-set result.