function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Data Migration 5Data Migration 5 

Data Loader: Update Case Information based on Case Number

I often need to update a custom field on Case based on the case number. I do not have case id. I was looking for a solution to update the custom field on case just by using case number and data loader. As Case Number is an auto number, I'm not able to make it external to be used as key in data loader.

Note: I want to avoid using VLOOKUP to get the case ID based on the case number. As this is an frequent activity, I'm looking for easy solution to updatecustom field.
pconpcon
You could probably create a field on the case that mirrors the CaseNumber into it as an externalId and just use that field.
Data Migration 5Data Migration 5
Probably yes, we can use workflow to populate this field. Thanks pcon
Any other suggestions from anyone else?