What is Colease Fields

[Gunjan Kiratkar]

Hi @devservicenow k ,

Make the account and assignment group both as "coalesce" in transform map level. so that it will eliminate the duplicate entries.

[Abhijit4]

What was the reason to write onAfter script to create new reocrds? I think it is not necessary. You can just create field maps for your field, it should do work. If you want to set customer field to true, you can have field map script.

To avoid duplicate record, you can coalesce on field ( in you case most probably account which should be unique) while mapping fields which will automatically avoid duplication of the record.

Please mark answer as Correct or Helpful based on impact.

[Abhijit4]

Hey @devservicenow k ,

Don't change question completely once you get your required answers, instead you should be asking new question to understand what is coalescef field means. Me and Gunjan have tried to answer your previous question. If that was resolved then please mark appropriate answer as Correct so that it will be removed from unanswered question.

FYI, Coalesce is checkbox on field mapping on transform map which will make sure target table will have unique records based on configured field. You can find more detail on ServiceNow docs.