Table of Contents

Concatenation

Description

Allows two or more inputs to be concatenated and formatted into one output column.

Calculation Editor

Options

Input Parameter Values Input Values
Strip Blanks Check Box
Skip Delimiter for Blank Values Check Box
Only Rollup If Generic Criteria

Input

Input Input Values Required
Input 1 Column or Literal ✔
Input 2 Column or Literal

Remarks

  • Strip Blanks will remove the blank characters in a column before doing the concatenation. For example, the business unit column frequently has leading spaces. If you want those spaces to be maintained in the concatenation, uncheck the "Strip Blanks" check box.
  • Skip Delimiter for Blank Values: If this is selected, any field value that's a column with the cell value of BLANK will ensure that the following concatenated input of a literal will be skipped.
  • Every concatenation created from Quick Calculations will default to having " - " delimiters in between each column value. You can edit the calculation after the fact in favor of a different delimiter.
  • Enable the default preferences setting called "Double-click concatenates associated description" to automatically use this calculation to bring together a code column and its associated description when double-clicking the code column. This type of 'code - description' column format is common for many report writers.

Example

  1. Input: Co, Business Unit, Subsidiary, Description (00001, 20, SUB, Liabilities)
  2. Quick Calculations > Text > Concatenation
  3. Output: Co - Business Unit - Subsidiary - Description (00001 - 20 - SUB - Liabilities)