Skip to Content
0
Former Member
Mar 27, 2007 at 05:52 PM

File-XI-File

10 Views

Hi All,

Can anyone please help me in resolving my issue:

My input file structure is:

Details (0.unbounded)

---BankNumber

---Description

---Amount

My output file structure is:

Details (0.unbounded)

---BankNumber

---Description

---Amount

Trailer(1..unbounded)

---RecordCount

---TotalAmount

Now in my target file for every change in BankNumber I need to create a trailer record. In it Record count should give the no. of records and the total amount gives the total amount of all the Details.

Source File:

123456789,ABCBank,10000

123456789,ABCBank,20000

123456000,XYZBank,30000

My output should be:

123456789,ABCBank,10000

123456789,ABCBank,20000

2,30000

123456000,XYZBank,30000

1,30000

Please help me on how to acheive this in mapping and in my output file.