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

[Former Member]

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

[Former Member]

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