Transform Maps

Transform Script 

 

OnStart: Runs once at the start of the Transform Process. Can have multiple onStart scripts and can run them based on the order. OnComplete: Runs when the entire transaction is completed. OnBefore: starts before the row transformation before the source row is transformed into the target row. OnAfter: runs after the source row has been transformed and saved. OnForeignInsert: Runs before a reference record is created. (If we have a Location as a Reference, then we can use this to add a new option). OnChoiceCreate: Runs before a new choice list entry is created. OnReject: This can be used when the OnForeignInsert and OnChoiceCreate both fail. This Skips the current row and processes the next record.

This field is available if the target field is a choice list or reference field. This field specifies what to do if the import set contains a reference or choice value other than those available. Select one of these options:

• create: Create a new choice or record in the reference table.
• ignore: Ignore the new value from the source table.
• reject: Skip the entire row (record) containing the new value and continue to the next row.

Object availability:

vailability: