Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Extract data from two sources and combine based on condition — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Extract data from two sources and combine based on condition

Received Response
16
Views
2
Comments
edited Jul 27, 2020 8:42AM in Integration 2 comments

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"?>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!