What's new in Customer Journeys?

Connect and learn more! ×
Splitting Input Files based on unique id — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Splitting Input Files based on unique id

Received Response
51
Views
5
Comments
edited Oct 25, 2018 9:06AM in Integration 5 comments

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)?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!