I tried writing XSLT from below given XML but not getting right output.
<?xml version="1.0" encoding="UTF-8"?>
<n0:EPCISDocument xmlns:n0="urn:epcglobal:epcis:xsd:1" schemaVersion="1.2" creationDate="2024-03-12T14:28:47.272374Z">
<EPCISBody>
<EventList>
<AggregationEvent>
<parentID>urn:epc:id:sscc:0361958.1000010007</parentID>
<childEPCs>
<epc>urn:epc:id:sgtin:539150714.0666.354159881283</epc>
<epc>urn:epc:id:sgtin:539150714.0666.438941790942</epc>
</childEPCs>
</AggregationEvent>
<AggregationEvent>
<parentID>urn:epc:id:sscc:0361958.1000010008</parentID>
<childEPCs>
<epc>urn:epc:id:sgtin:539150714.0666.497811017409</epc>
<epc>urn:epc:id:sgtin:539150714.0666.600301574096</epc>
</childEPCs>
</AggregationEvent>
<AggregationEvent>
<parentID>urn:epc:id:sscc:0361958.0001052872</parentID>
<childEPCs>
<epc>urn:epc:id:sscc:0361958.1000010007</epc>
<epc>urn:epc:id:sscc:0361958.1000010008</epc>
</childEPCs>
</AggregationEvent>
</EventList>
</EPCISBody>
</n0:EPCISDocument>
………………………………………………………………………………………………………….
—————————————————————————–
Actual output-
<?xml version="1.0" encoding="UTF-8"?>
<tns:despatchAdvice xmlns:tns="urn:ean.ucc:deliver:2">
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode>
<serialShippingContainerCode>urn:epc:id:sscc:0361958.1000010007</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<levelId>
<levelIdentification>urn:epc:id:sscc:0361958.1000010007</levelIdentification>
</levelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>urn:epc:id:sscc:0361958.1000010007</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode> <serialShippingContainerCode>urn:epc:id:sscc:0361958.1000010007</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<levelId>
<levelIdentification>urn:epc:id:sscc:0361958.1000010007</levelIdentification>
</levelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>urn:epc:id:sscc:0361958.1000010008</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode> <serialShippingContainerCode>urn:epc:id:sscc:0361958.1000010007</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<levelId>
<levelIdentification>urn:epc:id:sscc:0361958.1000010007</levelIdentification>
</levelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>urn:epc:id:sscc:0361958.1000010007</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode> <serialShippingContainerCode>urn:epc:id:sscc:0361958.1000010007</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<levelId>
<levelIdentification>urn:epc:id:sscc:0361958.1000010007</levelIdentification>
</levelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>urn:epc:id:sscc:0361958.1000010008</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode> <serialShippingContainerCode>urn:epc:id:sscc:0361958.1000010007</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<levelId>
<levelIdentification>urn:epc:id:sscc:0361958.1000010007</levelIdentification>
</levelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>urn:epc:id:sscc:0361958.1000010007</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode> <serialShippingContainerCode>urn:epc:id:sscc:0361958.1000010007</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<levelId>
<levelIdentification>urn:epc:id:sscc:0361958.1000010007</levelIdentification>
</levelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>urn:epc:id:sscc:0361958.1000010008</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
</tns:despatchAdvice>
Expected output-
<?xml version="1.0" encoding="UTF-8"?>
<ns3:despatchAdvice xmlns:ns3="urn:ean.ucc:deliver:2" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode>
<serialShippingContainerCode>urn:epc:id:sscc:0361958.0001052872</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<levelId>
<levelIdentification>urn:epc:id:sscc:0361958.0001052872</levelIdentification>
</levelId>
</despatchAdviceLogisticUnitLineItem>
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode>
<serialShippingContainerCode>urn:epc:id:sscc:0361958.1000010007</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<parentLevelId>
<levelIdentification>urn:epc:id:sscc:0361958.0001052872</levelIdentification>
</parentLevelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>urn:epc:id:sgtin:539150714.0666.354159881283</serialNumber>
</listForEachItem>
<listForEachItem>
<serialNumber>urn:epc:id:sgtin:539150714.0666.438941790942</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode>
<serialShippingContainerCode>urn:epc:id:sscc:0361958.1000010008</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<parentLevelId>
<levelIdentification>urn:epc:id:sscc:0361958.0001052872</levelIdentification>
</parentLevelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>urn:epc:id:sgtin:539150714.0666.497811017409</serialNumber>
</listForEachItem>
<listForEachItem>
<serialNumber>urn:epc:id:sgtin:539150714.0666.600301574096</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
</ns3:despatchAdvice>
Below is the XSLT code I tried but not giving expected output.
<xsl:template match="/">
<tns:despatchAdvice>
<xsl:for-each select="/ns0:EPCISDocument/EPCISBody/EventList/AggregationEvent">
<xsl:for-each select="/ns0:EPCISDocument/EPCISBody/EventList/AggregationEvent[contains(childEPCs/epc, 'sscc')]/childEPCs/epc">
<despatchAdviceLogisticUnitLineItem>
<logisticUnitIdentification>
<serialShipmentContainerCode>
<serialShippingContainerCode>
<xsl:value-of select="/ns0:EPCISDocument/EPCISBody/EventList/AggregationEvent/parentID"/>
</serialShippingContainerCode>
</serialShipmentContainerCode>
</logisticUnitIdentification>
<levelId>
<levelIdentification>
<xsl:value-of select="/ns0:EPCISDocument/EPCISBody/EventList/AggregationEvent/parentID"/>
</levelIdentification>
</levelId>
<despatchAdviceItemContainmentLineItem>
<listForEachItem>
<serialNumber>
<xsl:value-of select="."/>
</serialNumber>
</listForEachItem>
</despatchAdviceItemContainmentLineItem>
</despatchAdviceLogisticUnitLineItem>
</xsl:for-each>
</xsl:for-each>
</tns:despatchAdvice>
</xsl:template>
Can someone please suggest what is missing here in XSLT code I have written. Please suggest how to achieve right output from XSLT.