Parent – Child – Sub child Message Mapping.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Parent – Child – Sub child Message Mapping.

Viewing 0 reply threads
  • Author
    Posts
    • #24524

      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?


       

       

       

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.