Combining Data Fields


Merge field function is a function used to combine different fields to create and display a single consolidated field.

  • e.g., CONCAT function
  • reason for combining fields of information is to form a unique key for that record
  • can be used to create full address fields