babemangirl
New Member
I try to transform a hierarchical XML file to a flat file schema using Biztalk 2010.It works fine. Every file is mapped. But the hierarchy is destroyed.My input xml structure looks like this:\[code\]<root> <node> <element1></element1> <element2></element2> <subnode1> <element1></element1> <element2></element2> </subnode1> <subnode2> <element1></element1> <element2></element2> </subnode2> </node></root>\[/code\]The flat file schema looks like this:\[code\]<root> <node> <element1></element1> <element2></element2> </node> <subnode1> <element1></element1> <element2></element2> </subnode1> <subnode2> <element1></element1> <element2></element2> </subnode2></root>\[/code\]My input is like this:\[code\]<root> <node> <element1>Test1</element1> <element2>Test2</element2> <subnode1> <element1>Sub11</element1> <element2>Sub12</element2> </subnode1> <subnode2> <element1>Sub21</element1> <element2>Sub22</element2> </subnode2> </node> <node> <element1>Test3</element1> <element2>Test4</element2> <subnode1> <element1>Sub31</element1> <element2>Sub32</element2> </subnode1> <subnode2> <element1>Sub41</element1> <element2>Sub42</element2> </subnode2> </node></root>\[/code\]What I expect as output is:\[code\]Test1;Test2Sub11;Sub12Sub21;Sub22Test3;Test4Sub31;Sub32Sub41;Sub42\[/code\]But what I get is:\[code\]Test1;Test2Test3;Test4Sub11;Sub12Sub21;Sub22Sub31;Sub32Sub41;Sub42\[/code\]Any ideas how I can make Biztalk keep the hierarchy?