A primaryid_c custom field exists on the candidate_c custom object. The filed is used to store each candidate's id number and is marked as Unique in the schema definition. As part of a data…

Process Builder is an automation tool for workflow processes and cannot be directly used to map or reconcile incoming data during a CSV file upload.

While a `before Insert` trigger could programmatically attempt to find and update existing records, it is a less efficient and more complex solution for bulk data uploads compared to leveraging the built-in External ID functionality with an upsert operation.

By updating the `primaryid__c` field definition to mark it as an External ID, data loading tools like Data Loader can use this unique identifier from the CSV file to perform an upsert operation, matching existing `Candidate__c` records and updating them, or creating new ones if no match is found, thereby ensuring accurate data mapping and preventing duplicates.

Uploading the CSV into a custom object related to `Candidate__c` would create separate, new records and not directly update the existing `Candidate__c` records, leading to fragmented data and not achieving the goal of updating existing candidate information.