Experts,
Need help in this mapping (using PI 7.1 EHP 1). One source file, required multiple output files.
Source SampleHeaderSampleHeader Items AC1 Product1 21.01.2011 01.00 3.4 23 12.2 AC1 Product1 21.01.2011 02.00 4.3 43 23.2 AC1 Product1 21.01.2011 03.00 5.6 33 32 AC1 Product2 22.01.2011 01.00 4.3 23 213 AC1 Product2 22.01.2011 02.00 5.6 43 23 AC1 Product2 22.01.2011 03.00 7.7 45 23 AC1 Product3 21.01.2011 01.00 7.7 34 232 AC1 Product3 21.01.2011 02.00 8.2 2 3 AC1 Product3 21.01.2011 03.00 2.3 23 4354 Output File1 Header Product1-21.01.2011 01.00-21.01.2011 03.00 Item 3.4 4.3 5.6 File2 Header Product1-21.01.2011 01.00-21.01.2011 03.00 Item 23 43 33 File3 Header Product1-21.01.2011 01.00-21.01.2011 03.00 Item 12.2 23.2 32 Same for Product2, and till Product N.
Which is the best way to split this file as required output file.
If it can be done using UDF's, let me know.Thanks for looking into this.
^KK