Transform Map Event

[Sagar_pawar]

Hello All,

I am confused in transform map event can anyone please guide me on  transform event in simple word .

Thank You.

[reshmapatil · Accepted solution]

Hi @Sagar_pawar ,

Transform Event Scripts

Transformation events occur during the process of transforming an import set table onto a target table. Transformation Event Scripts modify the transformation behavior at different points in the transformation process.

To create a Transform Event Script, switch to the Transform Scripts related list in a Transform Map and click the New button.

The When option in the Transform Script trigger specifies when in the transformation process the script should run.

The When field choices are:

• onStart: executes at the start of an import before any rows are read
• onAfter: executes at the end of a row transformation and after the source row has been transformed into the target row and saved
• onBefore: executes at the start of a row transformation and before the row is transformed into the target row
• onChoiceCreate: executes at the start of a choice value creation before the new choice value is created
• onComplete: executes at the end of an import after all rows are read and transformed
• onForeignInsert: executes at the start of the creation of a related, referenced record before the record is created
• onReject: executes during foreign record or choice creation if the foreign record or choice is rejected. The entire transformation row is not saved.

For example, when coalescing, the requirement might be to update only records that match and not insert any new records. To meet the update records only requirement requires an onBefore Transform Script. The onBefore script executes after ServiceNow has determined whether there is a matching record in the target table and before the insert happens.

The action string variable is automatically created. It has two possible values: insert and update. The action variable is set after coalescing determines if there is a match (update) or no match (insert).

The ignore boolean variable is automatically created. When true, the ignore variable stops the transformation process for the source data row.

For more check:

https://developer.servicenow.com/dev.do#!/learn/learning-plans/quebec/new_to_servicenow/app_store_le...

Regards,

Reshma

**Please mark my answer correct or helpful based on the impact**

[Sagar_pawar]

Thank You So Much @reshmapatil