Transform Map Deletion Action

Bishal Sharma1
Tera Contributor

Hi Team,

 

Need your suggestion here!

 

I have an excel sheet which contains 10 records and in ServiceNow there is one table which has 15 records. I need to delete/inactive all those extra 5 records while I am doing transform using import set.

 

Please assist.

 

3 REPLIES 3

Nicolas Piveta
Kilo Sage
Hi 
you cannot delete any record by using transform map you have to remove record manually, or create an script and pass your logic.
Regards, 
Nicolas

VaranAwesomenow
Mega Sage

You can write a transform map and coalesce on required key fields, once you do that which ever records were not found as target record in import set row those will be eligible for deletion.

There are two ways in which you can attempt deletion

1. Write on complete transform map script

2. Write post import script on scheduled import.

Depending on whether you want the delete to happen for all data loads on that import set table you can make that decision, if only in some cases delete should happen then approach 2 applies, if delete has to happen in all scenarios then scenario 1 will apply.

Happy deleting 🙂

 

Quyen
Tera Contributor

Hi @Bishal Sharma1 ,
Have you found the solution? I am facing a similar issue.
Thanks