About transform map script

[VaishnaviK43271]

What is the difference between,

1)Explicit Transform Map

2)Transform Event Script

3)Field Map Script   AND

What are the use cases for that?

[palanikumar]

Transformation Event Scripts:
Purpose: These scripts are used to run custom actions at specific stages of the transformation process (e.g., when the transformation starts, before or after each record is transformed, or when the entire transformation finishes).
Use Case: Setting up, validating, or finalizing actions for the whole process.

DOC URL: https://www.servicenow.com/docs/bundle/yokohama-integrate-applications/page/script/server-scripting/...

Explicit Transform Map Scripts:
Purpose: These scripts are written to handle the transformation of individual records as they are being processed. You write these scripts in the Transform Map to manipulate or modify data on a per-record basis before it’s saved in the target table.
Use Case: Handling complex logic for individual record transformation.

DOC URL: https://www.servicenow.com/docs/bundle/zurich-integrate-applications/page/script/server-scripting/co...

Field Map Script: These script are written to process the source field values and then map to target field if there is no direct mapping is not available between source and target field

Use Case: Handle Calculated field value calculation

[Ankur Bawiskar]

@VaishnaviK43271 

these explains the purpose and the sequence

Decoding ServiceNow Data Imports: Understanding the Sequence of Transform Scripts 

Validating the order of execution for transform map scripts 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[svirkar420]

Hi @VaishnaviK43271 , 

An Explicit Transform Map is a transform map that you must manually select when importing data, useful when multiple maps exist for the same source and target tables and you want control over which mapping applies. Transform Event Scripts run during different stages of the transform (onStart, onBefore, onAfter, onComplete) and are used for record-level or batch-level logic such as cleaning data, handling duplicates, skipping invalid records, or triggering actions after import. Field Map Scripts, on the other hand, are tied to individual field mappings and are used to manipulate source values before saving into the target field, such as converting codes to readable values, splitting full names, or changing date formats.

Use Case -

Imagine you’re importing employee data from an external HR system. You have two transform maps (one for full-time staff, one for contractors), so you mark them as Explicit Transform Maps and pick the right one at import time. In the chosen map, you add a Transform Event Script in onBefore to skip any record missing an employee ID, ensuring only valid records are processed. Finally, you use a Field Map Script on the “Gender” field to convert source values like M/F into Male/Female  in the target table.

If this solution helped you Please Mark this solution as accepted and helpful as it will be helpful for other users as well.
Best Regards.
Saurabh V.