Hi guys,
I have source like this.
Table A
MSGID | CREDTM | No.Txns | Controlsum |Nm | PMTINFID | PMTMD |CCY | INSTDAMT | USTRD
CAVAY1234 2013.06.02 2 1085 Smith CAVAY/88683 DD GBP 985 CAR INSURANCE PREMIUM
CAVAY1234 2013.06.02 2 1085 Smith CAVAY/88683 DD GBP 100 BIKE INSURANCE PREMIUM
I need to create an xml file based on this data in the below form.
<?xml version="1.0" encoding="UTF-8" ?> <?valid true?> <?description Sample Message?>- CAVAY1234 2013-06-02T14:25:00 2 1085
- Smith
- CAVAY/88683 DD
- 985 CAR INSURANCE PREMIUM
100
Bike INSURANCE PREMIUM
I’m finding it hard to generate this file as my output file is repeating for each record.
Could someone please give me a solution to the above. I would really appreciate it.
niranjan479 (BOB member since 2014-01-08)