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


Derive value when record is read

Select box for yes

Populate real field when writing to the file


Field name

iiiDeptCode  iiiEmployNumber


     Your Details tab should now look like this:

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