AnsweredAssumed Answered

Merge Multiple Records (XML output) into one record with sum

Question asked by msonawane173815 on Aug 3, 2018
Latest reply on Aug 6, 2018 by msonawane173815

I have scenario where I have XML output ready to upsert into my SFDC object. But data at this stage is coming with multiple records for same external Id but with different sales numbers (based on specific category), since the source of data is our ERP system.

 

Before upsert I wanted to merge multiple records into one record where external id is same, while merging i wanted to apply various operations on each field. e.g. 2-3 fields will perform sum, 2-3 fields concatenate string

 

Below is the representation of my example:

 

Outcomes