How to skip a row in transform map insertion if field is empty
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2023 12:54 AM
Hi,
how can I skip a row insertion in transform map if field specific field is empty.
if (source.u_computer_name == '') {
skip row
}
else {
return source.u_computer_name;
}
6 REPLIES 6
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2023 01:48 AM
Hi @Alon Grod ,
Please refer the below link.
If my answer resolves your issue then please mark it as correct and helpful.
Regards,
Namrata
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2023 01:52 AM
you can use onBefore transform script.
But please share what script you are using currently?
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader