I have a picklist field 'Priority' on the Account object with the values 'A+, A, B+, B, C+' and also I have the record types 'Test, Test1, Test2' on the Account object. I have around 1M records in Account object,
My current need is to replace all my Priority field values as,
A+ -> High Priority
A -> Priority
B+ -> Medium Priority
B -> Low Priority
C -> Low Priority
only for the Record Type 'Test'.
I can simply add the new picklist values to the field priority and can select only the record type 'Test'. But I need to replace the existing record priority values with the new values for the record type 'Test'. I don't think we can replace the values by clicking the replace button since it will update all the records instead of only the records that Record Type 'Test'.
Am I correct or can we do it by clicking the replace button for a specific record type?
If not,
What is the best way?
Data loader with bulk API?