For the complete documentation index, see llms.txt. This page is also available as Markdown.

RowMerge

Merges content from a multi-record-set databox result into a single string (Keyfax version 4.4.8 and later).

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 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

Expression
Databox Value
Result
Comments

RowMerge("[name] ([userId]), ",")

<KFXmlValue rows="1"><KFRow id="0"><userId>1</id><name>George Smiley</name></KFRow><KFRow id="1"><userId>2</id><name>Ann Sercomb Smiley</name></KFRow></KFXmlValue>

George Smiley (1), Ann Sercomb Smiley (2)

This expression compliments FieldMerge that achieves this goal only for the first record of a databox result (if multiple records exist).

RowMerge is useful when you require a comma separated list of results from a SQL or HTTP databox.

Last updated