I am attempting to map the xml tender offer out of OTM into an EDI format using Sterling Integrator. I am stuck at the stop level because of the format of the XML. My problem is that both the Location tags and the ShipUnit tags are at the same level as the ShipmentStop, not children of the ShipmentStop so I have no way to loop through the ShipmentStop records properly (I cannot find which locations are for which stop nor can I accumulate weights at the stop level). Is there a way to modify the XSL within OTM to make the Location records and the ShipUnit records children of the appropriate ShipmentStop tags? If not, has anyone mapped the tender in Sterling Integrator with success? If so, how did you accomplish this? Thanks for any help you can provide. I am looking for the following format if possible:
< ShipmentStop> -- Stop 1
<Location>
<ShipUnit>
<ShipmentStop> -- Stop 2
<Location>
<ShipUnit>
Right now, the format comes out of OTM looking like this:
< ShipmentStop>
< ShipmentStop>
< Location>
< Location>
< ShipUnit>
< ShipUnit>