Need *URGENT* Help on XML
Posted: Fri Nov 28, 2014 4:12 pm
Hi,
My XML File is like this,
<Batch>
--<A>
--<B>
--<BatchDetails>
----<C>
----<D>
--<Worksheet>
----<E>
----<F>
----<Items>
------<G>
------<H>
My Job structure is like this,
External Source->XMLStage(to divide data)->3 Transformer(one for Batch,Worksheet,Items each)->XML Stage<To form XML file again)
I am succesful till the division of data, transformation and again forming an XML.
But in the new XML formed, I am getting duplicate <item> values(same number of duplicates as the first field <BatchDetails> where it should be only one. How to avoid this?
My XML File is like this,
<Batch>
--<A>
--<B>
--<BatchDetails>
----<C>
----<D>
--<Worksheet>
----<E>
----<F>
----<Items>
------<G>
------<H>
My Job structure is like this,
External Source->XMLStage(to divide data)->3 Transformer(one for Batch,Worksheet,Items each)->XML Stage<To form XML file again)
I am succesful till the division of data, transformation and again forming an XML.
But in the new XML formed, I am getting duplicate <item> values(same number of duplicates as the first field <BatchDetails> where it should be only one. How to avoid this?