How to Delete Data Using Transform Map

Go to solution
hamauzutr13
Giga Contributor

3 weeks ago

We are considering importing an Excel file into the group member (sys_user_grmember) table.
This involves not only adding data but also potentially deleting data from the group members table.
We are exploring adding a deletion flag to the Excel file and using a Transform Script to branch the process based on the deletion flag value, handling data deletion and addition accordingly.
Could you advise whether this approach is feasible or if there is a better method?

0 Helpfuls
  • 588 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron

3 weeks ago

@hamauzutr13 

Data load is usually done for insert & update and not for deletion.

Why not ask user to share separate excel or csv for data deletion and then you can read that file using CSVParser or ExcelParser and then delete the record?

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

5 REPLIES 5

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron
In response to Ankur Bawiskar

3 weeks ago

@hamauzutr13 

Thank you for marking my response as helpful.

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

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader