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.