Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • Madrid
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Case-sensitive coalesce field values

Log in to subscribe to topics and get notified when content changes.

Case-sensitive coalesce field values

You can control if an import set will coalesce on matching values with different cases.

The field map Coalesce case sensitive field enables you to coalesce field values by case sensitivity.

By default, fields marked as Coalesce in the field map are used in a case insensitive lookup for existing records. If the Coalesce case sensitive check box is selected, the instance attempts to match coalesce field values by case. The target table record is updated only if the value in the target record and the import set staging record have the same value and case. Otherwise, a new record is created.