Skip to Content
0
Former Member
Jun 10, 2011 at 08:01 AM

Mapping Issue

51 Views

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