Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-11-17
Concatenate Text

Concatenate Text

  • Create the text constants that you want to use in the calculated field.
  • Security:
    Custom Field Management
     domain in the System functional area.
You can concatenate a series of text fields within Workday. When setting up the concatenated text field, Workday:
  • Provides global text constants for commonly used special characters when concatenating fields.
  • Removes any leading or trailing spaces from the results of a concatenated field.
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Concatenate Text
     for the
    Function
    .
  3. On the
    Calculation
     tab, select a
    Field
     in the grid.
    Available options depend on the business object. If you add rows, Workday concatenates the fields from top to bottom.
  4. (Optional) In the
    Advanced
     section on the
    Additional Info
     tab, select the
    Do not use Alternate Display ID
     check box from the
    Options
     prompt.
    Instead of using the alternate display ID, Workday uses the display ID from the text source when concatenating text.
You can:
  • Append the literal
    (cell)
     to the end of a mobile phone number.
  • Create a name field that generates
    Smith, John, (Jack)
     using the Worker business object. In the grid for the concatenate field, select these options for each row:
    1. Legal Last Name
      .
    2. A comma by accessing
      Global Fields
      Text
      ,
      .
    3. A space by accessing
      Global Fields
      Text
      Single Space
      .
    4. Legal First Name
      .
    5. A comma.
    6. A space.
    7. A left parenthesis by accessing
      Global Fields
      Text
      (
      .
    8. Preferred Name
      .
    9. A right parenthesis.
You can create:
  • Additional calculated fields.
  • New calculated fields from within a concatenate text calculated field.