ETL and Data Integration tools - Modern ETL software for everyone

Hi, I want to map an XML tag-name to the target XML as a Node's value,
like this:

<root>
<XMLTagA>123</XMLTagA>
<XMLTagB>456</XMLTagB>
</root>


<target>
<node>
<name>XMLTagA</name>
<value>123</value>
</node>
<node>
<name>XMLTagB</name>
<value>456</value>
</node>
</target>

Is this possible?
Robert

You can treat your xml file as usual text file

First of all you need to get rid of of <root> tag

This can be done by using data validator

than you need to get tag name this can be done by using substring function
You can get the actual value you use substring as well
Than you can create xml again by using encode xml function
If you are having difficulties we can create a working example for you

Mike