Coalesce is a field property that is used in transform map field mapping. When you use coalesce on a field, you can use that field as a unique key. If a match is found coalesce field is found, the existing record will be updated with the imported information. If you cannot find a match, a new record will be inserted into the database.