Extract data from two sources and combine based on condition

Content

Hi Experts,

Getting data from two queries and both have a common field <aid>. Based on the <aid>, wanted to merge the data. See the below. Can we achieve the same in OIC? Please suggest.

Data from 1st query:

<?xml version="1.0" encoding="UTF-8"?>
<data>
   <accounts>
      <aid>123</aid>
      <aname>abc</aname>
      <contact>
         <cid>c124</cid>
         <cname>ankur</cname>
      </contact>
      <contact>
         <cid>c123</cid>
         <cname>amit</cname>
      </contact>
   </accounts>
   <accounts>
      <aid>456</aid>
      <aname>xyz</aname>
      <contact>
         <cid>c099</cid>
         <cname>jain</cname>
      </contact>
      <contact>
         <cid>c107</cid>
         <cname>vasim</cname>
      </contact>
   </accounts>
</data>

 

Data from 2nd query

<?xml version="1.0" encoding="UTF-8"?>