FieldMerge

Returns a named item from a multi-value Databox (Keyfax version 4.4.8 and later).

This Expression constructs a string from a multi-value Databox such as an Address question, an HTTP Request or a SQL Query returning multiple columns with individual column values accessible using the column name.

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

Expression	Databox Value	Result	Comments
FieldMerge("[name] ([userId])")	<KFXmlValue rows="1"><KFRow id="0"><userId>1</id><name>George Smiley</name></KFRow></KFXmlValue>	George Smiley (1)	If the databox value has multiple records (as supported by multi-record-set databoxes (Keyfax 4.4.8 only) FieldMerge will return a merge of fields in the first row only.

Using an expression in a databox driven Dynamic List Question (a 4.4.8 feature) that contains a FieldMerge will result in the FieldMerge expression being executed on each row of the Dynamic List Question options. This is an ideal way to format Dynamic List Question options.