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