<PDB> <PRODUCER> <FIRM> <ENTITY_BIOGRAPHIC> <ADDRESSES> <STATE name="AK"> <ADDRESS branch_id="41027004"> <DATE_UPDATED>11/08/2013</DATE_UPDATED> <COUNTRY>U.S.A.</COUNTRY> </ADDRESS> </STATE> <STATE name="AL"> <ADDRESS branch_id="41027005"> <DATE_UPDATED>11/08/2015</DATE_UPDATED> <COUNTRY>U.S.A.</COUNTRY> </ADDRESS> </STATE> </ADDRESSES> <CONTACT_INFOS> <STATE name="AK"> <CONTACT_INFO branch_id="41027004"> <BUSINESS_PHONE>206-448-9400</BUSINESS_PHONE> <BUSINESS_PHONE_UPDATE_DATE>06/08/2015</BUSINESS_PHONE_UPDATE_DATE </CONTACT_INFO> </STATE> <STATE name="AK"> <CONTACT_INFO branch_id="41027005"> <BUSINESS_PHONE>206-448-9400</BUSINESS_PHONE> <BUSINESS_PHONE_UPDATE_DATE>06/08/2015</BUSINESS_PHONE_UPDATE_DATE </CONTACT_INFO> </STATE> </CONTACT_INFOS> <ENTITY_BIOGRAPHIC> </FIRM> </PRODUCER> </PDB>
If the branch_id of <ADDRESS> node under <ADDRESSES> node for a State is equal to branch_id of <ADDRESS> node under <CONTACT_INFOS> then all the child nodes of same state of <CONTACT_INFOS> should become child nodes of <ADDRESS> nodes of a state under <ADDRESSES> nodes. The output should be as below:
<PDB> <PRODUCER> <FIRM> <ENTITY_BIOGRAPHIC> <ADDRESSES> <STATE name="AK"> <ADDRESS branch_id="41027004"> <DATE_UPDATED>11/08/2013</DATE_UPDATED> <COUNTRY>U.S.A.</COUNTRY> <BUSINESS_PHONE>206-448-9400</BUSINESS_PHONE> <BUSINESS_PHONE_UPDATE_DATE>06/08/2015</BUSINESS_PHONE_UPDATE_DATE </ADDRESS> </STATE> <STATE name="AL"> <ADDRESS branch_id="41027005"> <DATE_UPDATED>11/08/2015</DATE_UPDATED> <COUNTRY>U.S.A.</COUNTRY> <BUSINESS_PHONE>206-448-9400</BUSINESS_PHONE> <BUSINESS_PHONE_UPDATE_DATE>06/08/2015</BUSINESS_PHONE_UPDATE_DATE </ADDRESS> </STATE> </ADDRESSES> <ENTITY_BIOGRAPHIC> </FIRM> </PRODUCER> </PDB>
</BUSINESS_PHONE_UPDATE_DATE
>
<ENTITY_BIOGRAPHIC>
Addresses->State->name == Contact_infos->State->name &&Address->branch_id == Contact_info->branch_id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)