In your left-side navigator, type transform map and open the Transform Map table. These mappings are what transform data from your import set table into the final destination table (in our example, u_incident_import to incident) - Create a base transform map and name it appropriately.
- In the Source table dropdown, select the correct import set table. In our example, it's u_incident_import.
- In the Target table dropdown, select the correct destination table. In our example, it's incident.
- Check the following boxes:
- Active
- (Optional) Run business rules - for if you want to run Business Rules (for validations, notifications, SLA)
- (Optional) Copy empty fields - for if you want to be able to set values to empty
CoalescingThis option will determine whether the incoming logic will insert or update a record. By default, Perspectium's Common Document format accounts for this. However, if you are creating an import set/transform map from scratch, you should check this box. Learn more about coalescing strategies here. ImpersonationThis option allows you to adjust which user is making updates. Without adding a user, your records will show as being updated by the "system user". This feature is useful for auditing and comment/activity log purposes. Learn more about impersonating strategies here. Field MappingsUnder the Related Links, click on Auto map matching fields. This will automatically map fields you created in the import set table to related fields in the destination table. In the Field Maps tab below, make sure that the entry for sys_id has Coalesce set to true, since this is what ServiceNow uses to determine whether to insert or update. ![](/download/attachments/28941733/transformmap-field_maps.png?version=1&modificationDate=1618433481000&api=v2)
|