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