Mapping 2-3 receivers based on type.
Hi experts
My source message is as below:
<?xml version="1.0" encoding="utf-8" ?>
<ns:testdata xmlns:ns="http://mytest.com/dotcom/test">
<row>
<Type>D</Type>
<ACCT>111001</ACCT>
<AMT>1000</AMt>
</row>
<row>
<Type>D</Type>
<ACCT>111001</ACCT>
<AMT>5500</AMt>
</row>
<row>
<Type>C</Type>
<ACCT>111001</ACCT>
<AMT>100000</AMt>
</row>
<row>
<Type>D</Type>
<ACCT>1561001</ACCT>
<AMT>905</AMt>
</row>
<row>
<Type>C</Type>
<ACCT>1561001</ACCT>
<AMT>10</AMt>
</row>
</ns:testdata>
and the rest for other channel.
Pls advice on how to achieve this.