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 Values |
Required |
| Input 1 |
Column or Literal |
✔ |
| Input 2 |
Column or Literal |
|
- 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
- Input: Co, Business Unit, Subsidiary, Description (00001, 20, SUB, Liabilities)
- Quick Calculations > Text > Concatenation
- Output: Co - Business Unit - Subsidiary - Description (00001 - 20 - SUB - Liabilities)