Hi Gurus,
we have a following requirement;
input xml;
<root>
<material>
<id>AAA</id>
<value>10</value>
</material>
<material>
<id>AAA</id>
<value>-10</value>
</material>
<material>
<id>BBB</id>
<value>20</value>
</material>
<material>
<id>CCC</id>
<value>30</value>
</material>
</root>
As per the above source file having one duplicate record with ID = "AAA" . One of this record have a negative value (-10), so here my requirement is need to update at receiver side as below.
output.xml;
<root>
<material>
<id>BBB</id>
<value>20</value>
</material>
<material>
<id>CCC</id>
<value>30</value>
</material>
</root>
We just need to delete both record lines with same ID when one of the value is negative.
Thanks in advance,
Peter