AnsweredAssumed Answered

Multiple record values to combine into single record

Question asked by mounika.m077710 on Jun 12, 2017
Latest reply on Jun 15, 2017 by mounika.m077710

Hi All,

I have an xml file converting to DB, Customer having multiple children each child with multiple units.

 

<Customer>
    <Id>001</Id>
    <Name>AAA</Name>

<Child__c>
   <Id>0010</Id>
   <Name>aaa</Name>

<Unit__c>

   <Name>abc</Name>

<Child__c>
   <Id>0011</Id>
   <Name>bbb</Name>

<Unit__c>

   <Name>def</Name>

<Child__c>
   <Id>0012</Id>
   <Name>ccc</Name>

<Unit__c>

   <Name>ghi</Name>

 

For which the expected output should be the combination of all the child & unit into single customer.

CustomerID || Name || Child Name-Unit Name, Child Name-Unit Name, Child Name-Unit Name ||

 

But what am getting is Customer with individual child & unit.

 

Can any one suggest me in this?

Outcomes