Product: ImportOmatic
This solution describes how to use a virtual field with a copy field function in order to populate values to a field based on a value being present in the source file
Environment: All
Version: All


For information on using virtual fields, please refer to the following knowledgebase solution: How to use virtual fields.

You will need to use a regular expression dictionary on the virtual columns to accomplish this process. One specific value can be assigned when data is present in the source column. When data is not present in the source column no value will be assigned. The specific value assigned must be the same for all incoming records that have a value populated in the source column.

For information on dictionaries, please refer to the following knowledgebase solution: How to create a dictionary

The information that will live in the dictionary is as follows:

Dictionary Title: (Your choice)
Replacement Value: (Enter the Value that Will Be Assigned when the source field is populated)
Value To Match On: ^.+$
Regex Check box: Selected

In the IOM profile, on the virtual field column select and set the "Function" to "Copy Field". On the same virtual field, map the respective dictionary that was created above by its title. Continuing on the same virtual field, in the "Seed" column, select a value of the column letter from the field map where the source data lives.

The described steps will create functionality using a dictionary and virtual fields to populate the selected mapped field. This population will only take place when there is a value in the source column copied from the field map.

Please refer to the ImportOmatic User Guide for additional information.