Step 3 Concatenation Virtual Field

Step 3. Concatenation Virtual Field

REP008 - Virtual Fields

In this step you will concatenate the Department field iiiDeptCode with the Employee Number field iiiEmployNumber to set the value of the Full Employee Number field iiiFullEmployNumber.

1.  Select the iiiFullEmployNumber field in the list of Undefined virtuals.

2.  In the Details tab, enter the following:

Virtual field type	Concatenation
Derive value when record is read	Select box for yes
Populate real field when writing to the file	No
Field name	iiiDeptCode  iiiEmployNumber

 

     Your Details tab should now look like this:

3.  The iiiFullEmployNumber field will now be listed under Read virtuals.