I have a master file of 100,000+ records in excel downloaded from our CRM. Each month i receive a separate 100,000 + records from a supplier which can contain updated information and new information.
The master files are structured as follows.
[url removed, login to view] information
2. Additional company information (we call them opportunities at this stage)
Each record will contain 1 and 2 information.
We need to get the 3 outcomes as follows.
1. If record received from supplier matches an existing record(in the master sheet) and matches the opportunity(in the master sheet) then create a batch file of these.
2. If record received from supplier matches an existing record (in the master sheet) but doesnt match the opportunity the we create a batch file of these
3. If not match on ether record or opportunity then create a batch file of these.
The batch fiels that get outputted need to be in maximum 5000 records each as our CRM cannot handle additional loads.
We will also need to be provided with the steps how to do this after the work is complete.