Skip to Content
0
Former Member
Feb 17, 2011 at 05:40 PM

Message splitting to multile files based on context

37 Views

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