Hierarchically Sorting XML and CSV Records
XML is an extremely versatile data transport format. By using the Jitterbit XSLT Transform Component, you can manipulate your XML using XSLT. Many stylesheets are posted online. If you’re new to XSLT, see this XSLT introduction. When wanting to sort a CSV file hierarchically, first convert it to XML. (In the wild, I’ve seen this need with Concur’s Employee import file.) With a parameterized XSLT style sheet, we can sort data in a parent/child sort order.