CONCAT

This action concatenates two or more input fields into a single output field.

This action is useful when you have more subfields in an input field than in the target output field. The remaining input subfields are concatenated into the last output subfield.

You can also concatenate constants and subfields into a destination value.

In the Separator field, specify the character to place between the fields which are being concatenated.

For example, three fields must be separated with a comma:

  • PID.lastname
  • PID.firstname
  • PID.middleinitial

To do this, select CONCAT and specify a comma (,) in the Separator field. This results in lastname, firstname, middleinitial.