Subject:Outer joins Author:Roel van der Hoeven Date:17 Oct 2012 04:16 AM
Thanks for your input. It has helped me a bit in understanding the base. Still I can't seem to get it to work in my situation. Attached is the actual input. The elements I need to loop over are in a loop with variable $xlCargoDetails called xlBerthVisitContainerHandling and xlBerthVisitFlatHandling. They have children xlEquipmentCategoryCode (key field), xlNumberFullEquipmentLoaded, xlNumberEmptyEquipmentLoaded, xlNumberFullEquipmentDischarged and xlNumberEmptyEquipmentDischarged.
This will have to be transformed in the output as berthVisitEquipmentHandling with children equipmentCategoryCode (the former key field), numberFullLoaded, numberEmptyLoaded, numberFullDischarged and numberEmptyDischarged.