Coalesce is feature of a field that is used in transform map field mapping and enables you to use the field as a unique key. If a match is using the coalesce field and get detected, the existing record will be updated with the information being imported. If a match is not found, then a new record will be inserted into the database.