Skip to Content
0

How file can be split after 998 line items & do the sum of credit and debit based on sign

Mar 06, 2017 at 09:43 AM

59

avatar image
Former Member

Hi Experts,

I have a requirement in file to proxy scenario Source file coming in lacks of records with header & line items.

Document need to be split after the line items have reach 998 and do the sum of credit and debit based on +/- separately, and balance need to be add at the 999 row of that document.

after 999 spiting same Header need to be repeat for further line items and generate new document(Target contains Documents split into multiple documents of 999 lines. Last document will contain the remainder of the lines after splitting the second last document to 999 lines).

Please suggest right UDF & logic for this

Thanks in Advance.

Regards,

Venkatram

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Baskaran Elumalai Mar 13, 2017 at 12:39 PM
0

Hi Venkatram,

This is an interesting requirement. Can you just confirm one thing? Does your target structure should be split upto into individual messages of 999 line items?

For e.g. If you input file has 3000 line items, does the output should be of 4 different messages (individual messages) processed out of PI?

Regards

Baski

Share
10 |10000 characters needed characters left characters exceeded