Issue with Data Validation Due to Transform Map Handling in List View Imports

Gayatri_23
Tera Contributor

Every time I import records from a list in the Incident table, it deletes and creates a new transform map in ServiceNow. As a result, I'm unable to validate the data using transform scripts or field map source scripts. This issue of deletion and creation of new transform maps occurs only when importing from the list view, not when using the Load Data functionality.

Please suggest.

1 ACCEPTED SOLUTION

Satishkumar B
Giga Sage
Giga Sage

Hi @Gayatri_23 

The issue occurs because importing from the list view automatically creates a new transform map each time, unlike the Load Data functionality which uses an existing transform map.

 

Use the Load Data functionality instead of importing directly from the list view. This way, you can maintain a consistent transform map and leverage transform scripts and field map source scripts for data validation.



…………………………………………........................................................................................
Mark it helpful 👍and Accept Solution !! If this helps you to understand.

…………………………………………........................................................................................

View solution in original post

1 REPLY 1

Satishkumar B
Giga Sage
Giga Sage

Hi @Gayatri_23 

The issue occurs because importing from the list view automatically creates a new transform map each time, unlike the Load Data functionality which uses an existing transform map.

 

Use the Load Data functionality instead of importing directly from the list view. This way, you can maintain a consistent transform map and leverage transform scripts and field map source scripts for data validation.



…………………………………………........................................................................................
Mark it helpful 👍and Accept Solution !! If this helps you to understand.

…………………………………………........................................................................................