Spent last 2 hours figuring out which nodes to use. I am struggling and need help!
I have two input files
- Input Table01.csv
- Input Table02.csv
Table01.csv looks like below
C0046658, MBH WTP:Water Treatment Plant
C0047847, MMT WTP:Water Treatment Plant
Table02.csv looks like below
C0047184, MBH WTP:Distribution System:Mechanical:Pumps
C0047185, MBH WTP:Dosing System:Mechanical:Pumps
I wish to create an xml file which incorporates the data of Table01 followed by data of Table02 into a single xml file like below.
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Table01>
<Asset_Number>C0046658</Asset_Number>
<Asset_Description>MBH WTP:Water Treatment Plant</Asset_Description>
</Table01>
<Table01>
<Asset_Number>C0047847</Asset_Number>
<Asset_Description>MMT WTP:Water Treatment Plant</Asset_Description>
</Table01>
<Table02>
<Asset_Number>C0047184</Asset_Number>
<Asset_Description>MBH WTP:Distribution System:Mechanical:Pumps</Asset_Description>
</Table02>
<Table02>
<Asset_Number>C0047185</Asset_Number>
<Asset_Description>MBH WTP:Dosing System:Mechanical:Pumps</Asset_Description>
</Table02>
</NewDataSet>
Attached are the input and output samples.
Input Table01.xlsx (9.7 KB) Input Table02.xlsx (10.4 KB) Output DataSet.xml (5.4 KB)