I need to create a xml file where the elements has a particular order.
And some of the elements only needs a single element.
Code:
<root>
<sub1a/> <sub1b>
<sub2a>Some String</sub2a>
</sub1b>
<sub1c/>
<sub1d/>
</root>
I created one xml snippet (add xml column):
Code:
<root>
<sub1a/> <sub1b/>
<sub1c/>
<sub1d/>
</root>
And wanted to join the xml snippet with a xml join
Code:
<sub2a>Some String</sub2a>
I tried to use add xml column to create this snippet, But I need to define a root level, which is added to the snippet.
At this moment I solved it by defining two constant fields with the pre en post tag, mask the xml content and concatenate these three fields.
But it is not a nice solution, does anybody knows a better solution?