Concatenation

To combine two data items into a third “computed” item as a string, use the concatenation string function in either the Query or Results section.

  1. In Query section, select Request button and then select Query menu (In Results section, select Results menu).
  2. Select Add Computed Item.
  3. Name the new data item in the Item dialog box.
  4. Press the Functions… button on right in dialog box.
  5. Select String Functions from the Function List Categories window in the Database Functions dialog box.
  6. Select Concat from the Functions available in the window to the right.
  7. Complete the table by referencing the first column name and the second column name.
  8. Click OK in the Database Functions dialog box.
  9. Click OK in the Item dialog box.

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