design suggestion for updating records without loop

Certified Associate Developer

hi, 

I have a record list from  excel sheet which will be uploaded from interface

Excel sheet

record1 : id:1,name:"A"

record2: id:2,name:"B"

record3: id:3,name:"A" 

Database : 

record1 : id:"A01",name:"A"

The record list in the excel has to go to the data base with new updated id , based on validating existing record in the database. 

Updated list should be like 

record1 : id:"A02",name:"A"  -> increments because this name already exists

record2: id:"B01"name:"B"  -> starts with 1 because , it is not available in the database yet

record3: id:"A03",name:"A" 

I am trying to lay out a design with out using loops for the records in the excel sheet as they might be huge. Can you provide any optimized design solution for this ?

  Discussion posts and replies are publicly visible

Parents Reply Children