Somehow I always get the chills when I need to deal with XML in Talend.
I need to produce such a schema, and tried various ways, to get it, using different mechanism, ... but nothing works.
The other side of the integrations wants this format of the schema
<root> <a> <a1>a1</a1> <a2>a2</a2> </a> <a> <a1>a1</a1> <a2>a2</a2> </a> <b> <b1>b1</b1> <b2> <b21>b21</b21> <b22>b22</b22> </b2> </b> <b> <b1>b1</b1> <b2> <b21>b21</b21> <b22>b22</b22> </b2> </b> <root>
both a and b are childnodes of the root.
I'm banging my head around this, but simply can't figure it out.
Dont believe you unless you show me a real example... this is duplicate stuff exact same <a> ...
<a> <a1>a1</a1> <a2>a2</a2> </a> <a> <a1>a1</a1> <a2>a2</a2> </a>
Yes, better, now an example of your source data please.
Because you need to transform from type A -> XML , we need to understand that to.
However you could try it with tXMLMap and in the output create a one column of Document type.
see example: the example is from another post I did... but give it a go, not sure if it works...
Set your most elementary element as loop.
Otherwise the tJavaFlex needs to do the trick and code a little bit of java... pretty easy.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema