Use the following formula to combine the
values in two columns from the external data—Division and Activity—to create the cost code
of division.activity. Note how the formula adds the period between the
values.
Import Type: Employee Time Card
Column: Cost Code
Calculation: String.Concat(pData("Division"),".",pData("Activity"))