Transform map to update only empty fields

NirupamH1
Tera Contributor

Hi,

 

Consider "Short description" field of incident. I want to run transform map with a coalesce turned on for "Number" Field. There's one additional requirement though, my transform map should update the short description field for an incident record where it is empty and  not for a record which already has a short description. Can someone please help me with this?

1 ACCEPTED SOLUTION

Aman Kumar S
Kilo Patron

you can write script in the field map for short description,

you can just write below script:

 

if(target.short_description != ''){

ignore = true;

}

else return source.short_description;

Best Regards
Aman Kumar

View solution in original post

5 REPLIES 5

Hi @NirupamH1 

Great, please mark the response as correct and helpful so it ends up in solved queue.

 

Best Regards
Aman Kumar