ServiceNow: Building Powerful Workflows

Transforming the data

Once the data has been brought into an Import Set table, it needs to be transferred to its final destination. Transform Maps do exactly that. By creating field maps and scripts, Transform Maps will validate, check, and copy data to the appropriate place. A Transform Map is always associated with a source Import Set table and a target table. The configuration is contained in a Table Transform Map [sys_transform_map] record, accessible under System Import Sets > Administration > Transform Maps.

The basic element of a transform map is a field map. It is an association between a particular field in an import set table and one in the target table. There cannot be more than one field map for a particular field on a target ...