Concatenation with a Delimiter

To combine two or more data items into a third “computed” item with a delimiter between the combined data items, use the reference button within the computed item dialog box in the Query section only.

  1. In Query section, select Request button and then select Query menu.
  2. Select Add Computed Item.
  3. Name the new data item in the Item dialog box.
  4. Press the Reference button on right in dialog box.
  5. Reference the topic (table) and first data item and click OK
  6. Type two vertical bars or pipes, i.e. ||
  7. Type the delimiter between single quotes, i.e. for a delimiter of a comma followed by a space, type ‘, ‘
  8. Type two vertical bars or pipes, i.e. ||
  9. Press the Reference button on right in dialog box
  10. Reference the topic (table) and second data item and click OK.
  11. Click OK in the Item dialog box.
  12. To review/modify the computed item double click on the item name on the Request Line.

Last updated: October 15, 2013

Last updated: October 15, 2013