Compare data from import set table to target table

[Divya_hg]

Hi

I receive quarterly data dumps containing salary IDs from the HR system, which I store in a custom table in ServiceNow. When some IDs are deactivated or deleted in HR during subsequent data updates, those IDs won't appear in the new data imported. I want to compare this data with a target table and remove records that are no longer present in the latest data dump. Deletion is preferred because the data will continually grow, and inactivating records in ServiceNow would lead to redundancy since they would never be used again. What is the best approach to handle this? We have data source and import set setup.

Thanks much in advance.

@Ankur Bawiskar any suggestions please.

Thank you

Divya

[Ankur Bawiskar]

@Divya_hg 

this link has solution which worked, check and enhance for your requirement as well

it involves using custom field, scheduled job logic

Transform Map remove records that no longer exist from destination table -> response from Katie A

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏