I have a positional flat file that i'd like to output in multiple xml files.
Example flat file is Route, Stop, Order#, DeliveryDate. There are multiple stops and orders per route and multiple routes per file. For each route, I'd like to output a layered XML. <RoutePlan><Route><Rt>1</Rt><Stops><StopNo>1</StopNo><DelDate>1/1/07</DelDate><Order><OrdNo>456</OrdNo>
</Order><Order><OrdNo>789</OrdNo></Order></Stops></Route></RoutePlan>
What's the best way to accomplish this in BT2004? I'm stumped.
Thanks, Nick