My requirement is File - XI - R/3 (IDOC). Before processing the file, it should be sorted out based on a particular field.
Eg. The input file may have this pattern. I need to sort the file based on second field.
Records after sorting
I tried the following way. Read the whole record as a node, so there are 3 nodes for the above example. With in adapter module, retrieve all records and based on the second field sort and then construct the XML with each record containing all 4 fields. I am using DOM parser for this.
Issue: My actual input file has 27 fields and the size of the file is expected around 2 to 20 MB. It is really diffucult to construct the output XML. Is there any other alternative or a better way to handle such scenario?
Share your ideas.