I have exported data from production in .csv file, now I'm trying to import data to sandbox and I'm running into issue where RecordType.Id is not same as in the sandbox.
How should you go after correcting this? is there any tool to use? some says use vlookup to map and some says copy the production recordtype.id and update the same to sandbox recordtype.id.
select Id from RecordType where Name = 'Canada' and SobjectType = 'employee__c' limit 1