True or False: In a transform map only one field can be used for coalesce.

True or False: In a transform map only one field can be used for coalesce.

• A. True
• B. False
• C. Not specified
• D. Sometimes

Answer: (B)

Coalescing during a data import in a transform map is about using designated fields to locate existing records and decide whether to update or create. You can mark more than one field to coalesce. When multiple fields are set for coalescing, the system treats the combination of those field values as a composite key. If it finds a record that matches on all coalesced fields, it updates that record; if not, it creates a new one. So the statement is not correct because you’re not limited to a single field—you can coalesce on several fields to better identify duplicates. For example, you might coalesce on both email and phone number to ensure an existing contact is updated only when both values match, otherwise a new contact is created.

Coalescing during a data import in a transform map is about using designated fields to locate existing records and decide whether to update or create. You can mark more than one field to coalesce. When multiple fields are set for coalescing, the system treats the combination of those field values as a composite key. If it finds a record that matches on all coalesced fields, it updates that record; if not, it creates a new one.

So the statement is not correct because you’re not limited to a single field—you can coalesce on several fields to better identify duplicates. For example, you might coalesce on both email and phone number to ensure an existing contact is updated only when both values match, otherwise a new contact is created.