Skip to Content
0
Former Member
Jun 07, 2011 at 02:41 PM

Remove cancelled records

35 Views

Hi,

I have source XML as follows:

<ROW>

<ZPOSSIPNO>1001</ZPOSSIPNO>

<AMOUNT>65</AMOUNT>

</ROW>

<ROW>

<ZPOSSIPNO>1001</ZPOSSIPNO>

<AMOUNT>-65</AMOUNT>

</ROW>

<ROW>

<ZPOSSIPNO>1002</ZPOSSIPNO>

<AMOUNT>40</AMOUNT>

</ROW>

Result XML should be like;

<ROW>

<ZPOSSIPNO>1002</ZPOSSIPNO>

<AMOUNT>40</AMOUNT>

</ROW>

Is there any solution to solve this issue? We need to remove the record lines with ➖ amount values.

Thanks in advance,

Nurhan