Create distinct XML complexes
Posted: Tue May 21, 2013 1:40 pm
I am reading contents in a table and writing them to an XML file using the XML Output stage.
Table Contents are as follows,
The expected XML output is as follows,
However, the current output is as follows,
Any ideas on how do I get the expected output?
Table Contents are as follows,
Code: Select all
ColA ColB ColC
A1 B1 C1
A2 B1 C1
A3 B3 C3
Code: Select all
<tag>
<tagColA>A1</tagColA>
<tagColB>B1</tagColB>
<tagColC>C1</tagColC>
</tag>
<tag>
<tagColA>A2</tagColA>
<tagColB>B1</tagColB>
<tagColC>C1</tagColC>
</tag>
<tag>
<tagColA>A3</tagColA>
<tagColB>B3</tagColB>
<tagColC>C3</tagColC>
</tag>
Code: Select all
<tag>
<tagColA>A1</tagColA>
<tagColA>A2</tagColA>
<tagColB>B1</tagColB>
<tagColC>C1</tagColC>
</tag>
<tag>
<tagColA>A3</tagColA>
<tagColB>B3</tagColB>
<tagColC>C3</tagColC>
</tag>