XSLT mapping for CSV to Nested XML conversion in CPI

Hi Folks,

We required XSLT code for converting CSV to Nested XML in SAP CPI. Please find below details for your reference.

CSV Input file :

H,30004,3333,USA,10,P1001

L,30004,1111,10,USA,10,P10033

XML Output file:

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

<sales_orders>

<header>

<Sales_OrderNo>30005</Sales_OrderNo>

<OrderDate>2022/10/10</OrderDate>

<shipToCountry>USA</shipToCountry>

<Sales_Org>attune</Sales_Org>

<Po_Number>P1001</Po_Number>

</header>

<line_item>

<Sales_OrderNo>30005</Sales_OrderNo>

<lineItemNo>10</lineItemNo>

<productID>P1001</productID>

<quantity>10</quantity>

<price>7.50</price>

<amount>75.00</amount>

</line_item>

</sales_orders>

Regards,

Ahmad