HI, I have a following requirement.
Input Message: Flat File
Schema
<STD_5th_Passing_Year>1990-1991
<STD_5th_Result>Pass
<STD_5th_Subject_1_Marks>78
<STD_5th_Subject_1_Result>Pass
<STD_5th_Subject_2_Marks>85
<STD_5th_Subject_2_Result>Pass
<STD_6th_Passing_Year>1991-1992
<STD_6th_Result>Pass
<STD_6th_Subject_1_Marks>69
<STD_6th_Subject_1_Result>Pass
<STD_6th_Subject_2_Marks>81
<STD_6th_Subject_2_Result>Pass
Required Output: Nested XML File
Schema
<STDs>
<Std>
<Name>5th</Name>
<PassingYear>1990-1991</PassingYear>
<Result>Pass</Result>
<Subjects>
<Subject>
<Name>1</Name>
<Marks>78</Marks>
<Result>Pass</Result>
</Subject>
<Subject>
<Name>2</Name>
<Marks>85</Marks>
<Result>Pass</Result>
</Subject>
</Subjects>
</Std>
<Std>
<Name>6th</Name>
<PassingYear>1991-1992</PassingYear>
<Result>Pass</Result>
<Subjects>
<Subject>
<Name>1</Name>
<Marks>69</Marks>
<Result>Pass</Result>
</Subject>
<Subject>
<Name>2</Name>
<Marks>81</Marks>
<Result>Pass</Result>
</Subject>
</Subjects>
</Std>
</STDs>
I tried various combinations of looping functoid as well as table looping functoid. But i am not getting the desired output.
Any word on this?