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

Split Denormalized Flat Files into 2 Files

Received Response
edited Aug 16, 2020 1:50PM in Integration 5 comments


Hi Experts,

I am trying to build an OIC integration that process a flat file from FTP. That file is a denormalized file. For example, order header fields and line fields are on the same line. If there is multiple lines, header fields will repeat on the 2nd lines, 3rd lines, etc.

However, there are a few key fields. I have to use those key fields to determine the uniqueness of header. The target output is 2 flat files. 1 is the header level and the other is the line level. How to achieve that in OIC? Any thoughts on it?


Howdy, Stranger!

Log In

To view full details, sign in.


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