need help on bundling records

[balaji_pichaimuthu]

Hi

I ill get list of electricity records and gas records say E1,E2.E3,E4 (eleactricity records) and G1 G2 G3 G4 (Gas records). The i ill take value of one field from Electricity record (product id ) and do the rfc lookup to get the corresponding gas records.. assume E1 has G1 G2 has correpsonng records.

Now my target xml should be has two bundles like below..

Bundle

record

E1 electriciy record fields

G1 gas record fields

record

summay

total amount = e1 amount + g1 amount

summary

bundle

Bundle

record

E1 electriciy records fields

G2 gas records fields

record

summary

total amount = e1 amount + g2 amount

Summary

Bundle

Please give ur valubale suggestion to achieve this

Regards,

Balaji

[Former Member · Accepted solution]

Hi,

You can achive this using UDFs.

To map Target G1 record use the following logic in UDF.

-> Take E1 from the source and get its G1 and G2 from RFC Look up.

-> Use this G1 value and search the whole Gass Queue value and if you find the G1 value there then Mapp it to G1 target value .

TO Map Total Amount value:

->Use G1 value coming from RFC lookup and search the whole Gass Queue value and if you find the G1 value the take its corresponding Amount value from the amount Queue. Then add this amount with the E1 amount and map it to the amount feeld.

Shweta.

[balaji_pichaimuthu]

myself found the way to achieve this using many UDF.

Thank you the replies.