Hi, i have an input as below:

ABC,1219,5,124292,101,0,0,5730,1.174,23.07
ABC,1219,5,124292,101,0,0,5722,.748,17.57
ABC,1219,5,124292,101,0,0,7037710024104,1,16.09
ABC,1219,5,124292,101,0,0,7037610221511,1,20.35
ABC,1219,5,124292,101,0,0,7025168009569,1,39.3
XYZ,1219,2015061825,"0927",5,124292,"",997094,0,"","","","",67
ABC,1219,5,101848,101,0,0,5730,1.174,23.0,7
ABC,1219,5,101848,101,0,0,5722,.748,17.57
ABC,1219,5,101848,101,0,0,7037710023754,1,16.09
ABC,1219,5,101848,101,0,0,70377764324104,1,16.09
ABC,1219,5,101848,101,0,0,7037710024104,1,16.09
ABC,1219,5,101848,101,0,0,7037710026344,1,16.09
ABC,1219,5,101848,101,0,0,7037610221511,1,20.35
ABC,1219,5,101848,101,0,0,7025168009569,1,39.3
XYZ,1219,2015061825,"0927",5,101848,"",997094,0,"","","","",78

ABC and XYZ are 2 seperate records with different number of fields in them. 
One whole loop is considered when the first XYZ record is encountered. (therefore, ABC is a repeated record and XYZ is non-repeating.)

That is 
loop 1 :
ABC,1219,5,124292,101,0,0,5730,1.174,23.07
ABC,1219,5,124292,101,0,0,5722,.748,17.57
ABC,1219,5,124292,101,0,0,7037710024104,1,16.09
ABC,1219,5,124292,101,0,0,7037610221511,1,20.35
ABC,1219,5,124292,101,0,0,7025168009569,1,39.3
XYZ,1219,2015061825,"0927",5,124292,"",997094,0,"","","","",67 
loop 2:
ABC,1219,5,101848,101,0,0,5730,1.174,23.07
ABC,1219,5,101848,101,0,0,5722,.748,17.57
ABC,1219,5,101848,101,0,0,7037710023754,1,16.09
ABC,1219,5,101848,101,0,0,70377764324104,1,16.09
ABC,1219,5,101848,101,0,0,7037710024104,1,16.09
ABC,1219,5,101848,101,0,0,7037710026344,1,16.09
ABC,1219,5,101848,101,0,0,7037610221511,1,20.35
ABC,1219,5,101848,101,0,0,7025168009569,1,39.3
XYZ,1219,2015061825,"0927",5,101848,"",997094,0,"","","","",78

I need to create my flatfile schema in the above order. Any help would be appreciated

Thanks n Regards.

• Edited by ReKi111 Tuesday, June 30, 2015 11:34 AM