(Im a beginner) Having problems finding how to achieve that several subnodes are shown under a parent node, without repeating the parent node.
My input would be a csv with 8 col, one is header:
name,projectNo,invoiceDate,productNo,description,qty,price,vatPercent
Free text field,12345,12.06.2022,1,Free text description1,4,385,0
Free text field,12345,12.06.2022,1,Free text description2,5,247,0
Free text field,31312,18.07.2022,1,Free text description3,2,192,0
Free text field,31312,18.07.2022,1,Free text description4,3,914,0
Wanted output XML is:
<?xml version="1.0" encoding="utf-8"?>
<orders>
<order>
<name>Free text field</name>
<projectNo>12345</projectNo>
<invoiceDate>2022-12-06</invoiceDate>
<orderLines>
<orderLine>
<productNo>1</productNo>
<description>Free text description1</description>
<qty>4</qty>
<price>385</price>
<vatPercent>0</vatPercent>
</orderLine>
<orderLine>
<productNo>1</productNo>
<description>Free text description2</description>
<qty>5</qty>
<price>247</price>
<vatPercent>0</vatPercent>
</orderLine>
</orderLines>
</order>
<order>
<name>Free text field</name>
<projectNo>31312</projectNo>
<invoiceDate>2022-18-07</invoiceDate>
<orderLines>
<orderLine>
<productNo>1</productNo>
<description>Free text description3</description>
<qty>2</qty>
<price>192</price>
<vatPercent>0</vatPercent>
</orderLine>
<orderLine>
<productNo>1</productNo>
<description>Free text description4</description>
<qty>3</qty>
<price>914</price>
<vatPercent>0</vatPercent>
</orderLine>
</orderLines>
</order>
</orders>
What I’m getting with Rename Cols transformation f.i. ordeLines.orderLine.productNo is a repeat of everything for every orderline.