Total amount in mapping

[former_member182412]

Hi Experts,

I need to caluculate total amount based on eventType in message mapping.

1) i need to caluculate total amount when /session_mt/event/eventType = "T" or "R" and

/session_mt/event/eventSeqNum = session_mt/media/seqNum

Can anyone help me out of this.

Source message:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:session_mt xmlns:ns0="urn:gp:prototype">

<event>

<eventSeqNum>1</eventSeqNum>

<date>19-09-2010</date>

<eventType>T</eventType>

</event>

<media>

<seqNum>1</seqNum>

<amount>100</amount>

</media>

<media>

<seqNum>1</seqNum>

<amount>299</amount>

</media>

<event>

<eventSeqNum>2</eventSeqNum>

<date>19-09-2010</date>

<eventType>Y</eventType>

</event>

<event>

<eventSeqNum>3</eventSeqNum>

<date>21-09-2010</date>

<eventType>D</eventType>

</event>

<media>

<seqNum>3</seqNum>

<amount>199</amount>

</media>

<media>

<seqNum>3</seqNum>

<amount>499</amount>

</media>

<event>

<eventSeqNum>3</eventSeqNum>

<date>21-09-2010</date>

<eventType>R</eventType>

</event>

<media>

<seqNum>3</seqNum>

<amount>199</amount>

</media>

<media>

<seqNum>3</seqNum>

<amount>499</amount>

</media>

<media>

<seqNum>3</seqNum>

<amount>699</amount>

</media>

</ns0:session_mt>

Target Message:

<?xml version="1.0" encoding="UTF-8"?>

<ns0:lineItems_mt xmlns:ns0="urn:gp:prototype">

<item>

<date>19-09-2010</date>

<amount>1796</amount>

</item>

</ns0:lineItems_mt>

Thanks

[Former Member · Accepted solution]

Hi,

Use this UDF:

Execution type all values of a context.

4 inputs var1,var2,var3,var4.

int d =0;

for(int i=0;i<var1.length;i++)

{

if(var1<i>.equals("T") || var1<i>.equals("R"))

{

for(int j=0; j<var3.length;j++)

{

if(var2<i>.equals(var3[j]))

{

d = d+ Integer.parseInt(var4[j]);

}

}

}

}

result.addValue(String.valueOf(d));

(u may change this UDF according to ur req)

Mapping will be:

eventType-----removeContext-

eventSeqNum--removeContext

---

UDF--

---

Amount(Traget)

seqNum--

---

removeContext-

amount--

---

removeContext-

Thanks

Amit