Splitting Input Files based on unique id

Summary

Splitting Input Files based on unique id

Content

Hi,

Is there anyway we can split the incoming flat file (delimited) to multiple outbound files based on data content?

Example: If I have a flat file as below 

OrderNumber,LineNumber,OrderQty
100,1001,10
100,1002,12
101,1001,5
 

Is there anyway to translate the above to an xml schema as below using native schema? I tried using arrays, but can't make it work for nested arrays

<Orders>

  <Order>

   <OrderLine>

    <OrderNumber>100</OrderNumber>

    <LineNumber>1001</LineNumber>

    <OrderQty>10</OrderQty>

   </OrderLine>

   <OrderLine>

    <OrderNumber>100</OrderNumber>

    <LineNumber>1002</LineNumber>

    <OrderQty>12</OrderQty>

   </OrderLine>

  </Order>

  <Order>

   <OrderLine>

    <OrderNumber>101</OrderNumber>

    <LineNumber>1001</LineNumber>

    <OrderQty>5</OrderQty>

   </OrderLine>

  </Order>

</Orders>

 

Or is there any other option that's available in OIC that would enable the above input file to be split into multiple output files (based on unique ordernumber)?