cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping issue

Former Member
0 Kudos

Hello,

I have a requirement in message mapping. source strucutre contains a repeatable segment RECORD.

Some of the fields under RECORD are key,amount and tax code.

The rule here is when the key has a specific value 30, then I need to sum up the values for amount.This should happen only for RECORD that has key 30.

Can this be achieved using standard functions? or is java required?

Regards,

Moorthy

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hello.

Will this suffice?

I have a target structure with one RECORD segment and one field AMOUNT

I used the if KEY=30 to filter only the keys needed, and used removeContext so that

the sum standard function will work.

Hope this help.

Good luck,

Imanuel Rahamim.

Former Member
0 Kudos

Hello.

What is the target record?

just one segment of RECORD with the sum of all the amounts where key=30?

Regards,

Imanuel Rahamim.