J
johkar
I need to get distinct ID and DATE combinations and I am unsure how to
do it. I need a 1.0 solution. Getting a unique list based on one
element's value I can do, but this has me stumped so far. Below are
sample source and result XML.
Reduced source XML:
<?xml version="1.0" encoding="UTF-8"?>
<POL>
<POLFORMS>
<FORMS>
<ID>12455</ID>
<BUS_TYPE>HAT</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12455</ID>
<BUS_TYPE>INS</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12455</ID>
<BUS_TYPE>INS</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12455</ID>
<BUS_TYPE>HAT</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<BUS_TYPE>INS</BUS_TYPE>
<DATE>07-2010</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<BUS_TYPE>INS</BUS_TYPE>
<DATE>07-2010</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<BUS_TYPE>POM</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<BUS_TYPE>POM</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
</POLFORMS>
</POL>
This is what I want to end up with, unique ID - DATE combo list. I
will be bringing along other nodes also, but this is the essence.
<POL>
<POLFORMS>
<FORMS>
<ID>12455</ID>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<DATE>07-2010</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<DATE>07-2008</DATE>
</FORMS>
</POLFORMS>
</POL>
do it. I need a 1.0 solution. Getting a unique list based on one
element's value I can do, but this has me stumped so far. Below are
sample source and result XML.
Reduced source XML:
<?xml version="1.0" encoding="UTF-8"?>
<POL>
<POLFORMS>
<FORMS>
<ID>12455</ID>
<BUS_TYPE>HAT</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12455</ID>
<BUS_TYPE>INS</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12455</ID>
<BUS_TYPE>INS</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12455</ID>
<BUS_TYPE>HAT</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<BUS_TYPE>INS</BUS_TYPE>
<DATE>07-2010</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<BUS_TYPE>INS</BUS_TYPE>
<DATE>07-2010</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<BUS_TYPE>POM</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<BUS_TYPE>POM</BUS_TYPE>
<DATE>07-2008</DATE>
</FORMS>
</POLFORMS>
</POL>
This is what I want to end up with, unique ID - DATE combo list. I
will be bringing along other nodes also, but this is the essence.
<POL>
<POLFORMS>
<FORMS>
<ID>12455</ID>
<DATE>07-2008</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<DATE>07-2010</DATE>
</FORMS>
<FORMS>
<ID>12456</ID>
<DATE>07-2008</DATE>
</FORMS>
</POLFORMS>
</POL>