How to lookup a value in one xml based upon some key in another xml in ICS
Summarylooking for example to use lookup-xml function
Hi ICS community,
We would like to lookup a value from one xml (response received from a REST call) based upon some key value in another XML (response from another REST call). Basically we are looking at a way to join the two separate XML in ICS. We looked at the lookup-xml function and it seems to be doing the same. Below is the example from the oracle documentations.
oraext:lookup-xml('file:/d:/country_data.xml', '/Countries/Country', 'Abbreviation', 'FullName', 'UK') returns the value of the element
FullName child of