Skip to Content
0
Jun 15, 2020 at 03:24 AM

xslt to split/chunks/separate message when the source file is having more than 1 record/order

125 Views

Hi,

Need to split/separate/Chunck the source xml file when the file contains more than 1 order.

Source file:

<?xml version="1.0" encoding="UTF-8"?>

http://Test.com/Test">

<Orders>

<ID>202005280038-0000000</ID>

<terms>Ok</terms>

<LineItems>....</LineItems>

</Orders>

<Orders>

<ID>202005280038-0000001</ID>

<terms>Ok</terms>

<LineItems>....</LineItems>

</Orders>

<Orders>

<ID>202005280038-0000002</ID>

<terms>Ok</terms>

<LineItems>....</LineItems>

</Orders>

<owner>Main</owner>

<SubContractor>No</SubContractor>

</ns0:PurchaseOrder>

Expected outupt :

<?xml version="1.0" encoding="UTF-8"?>

http://Test.com/Test">

<Orders>

<ID>202005280038-0000000</ID>

<terms>Ok</terms>

<LineItems>....</LineItems>

</Orders>

<owner>Main</owner>

<SubContractor>No</SubContractor>

</ns0:PurchaseOrder>

next message as

<?xml version="1.0" encoding="UTF-8"?>

http://Test.com/Test">

<Orders>

<ID>202005280038-0000001</ID>

<terms>Ok</terms>

<LineItems>....</LineItems>

</Orders>

<owner>Main</owner>

<SubContractor>No</SubContractor>

</ns0:PurchaseOrder>

3rd message as

<?xml version="1.0" encoding="UTF-8"?>

http://Test.com/Test">

<Orders>

<ID>202005280038-0000002</ID>

<terms>Ok</terms>

<LineItems>....</LineItems>

</Orders>

<owner>Main</owner>

<SubContractor>No</SubContractor>

</ns0:PurchaseOrder>