Skip to Content
avatar image
Former Member

Custom Action Block : Split large XML into 'n' number of Small XML's

Hello,

I have a requirement where i have to split a large XML(approx. 5000 nodes) into small small XML's with specific count let's say 500 records in single XML.

Do we have any custom action block in SAP MII for this or is their any  XSLT transformation approach which can fullfill this requirment.

I am using SAP MII 12.1.5

Thanks,

Regards,

Pankaj Behl

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Feb 17, 2014 at 07:27 AM

    Hi Pankaj,

    By below way of action blocks, we might achieve

    1. Use 'While loop' action block and assign original XML file

    2. Create XML file with SAP MII XML Output action blocks (i.e. Document, Rowset, Row, Data elements)

    3. Add condition, if suppose if want to make 100 nodes as single XML file then keep validation for every loop count = '100', insert XML file as a row with column XML file in a DB table

    4. Clear the row and Data elements after 100 nodes.

    Hope it helps

    Regards,

    Praveen Reddy

    Add comment
    10|10000 characters needed characters exceeded