CSV to XML any pointers?

Spent last 2 hours figuring out which nodes to use. I am struggling and need help!

I have two input files

  1. Input Table01.csv
  2. 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)

Hi Shai,

you need the XML nodes to to that :slight_smile:



Attached an example on your excel-files:
KNIME_project7.knwf (19.9 KB)

4 Likes

@Shai did this help with your problem? :confused:
Any feedback? :slight_smile:

Hey AnotherFraudUser!
Thanks for your effort. I have got distracted but will be getting back into this on Monday. Really, really appreciate your keen intent

I was eager to sort this. Finally I could.
Thanks @AnotherFraudUser
Your example helped a lot.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.