Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 13, 2017 at 12:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded