How to abort action on specific row if condition is met

[Alon Grod]

Hi,

I have the field u_mail in my transform and it supposed to populate the 'mail' field on the sys_user table.
This field is also my Coalesce in the transform map.
Im using source script in order to populate the mail field in the sys_user table, How can I achieve that?

if(source.u_mail.includes('idfts')) {

    skip current row and do nothing;
}

else {
 return source.u_mail;
}

[Sohail Khilji · Accepted solution]

Hi @Alon Grod ,

try the below:

if(source.u_mail.includes('idfts')) {
return;
}
else {
target.mail = source.u_mail;
}