mapping value in different level

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › mapping value in different level

Viewing 1 reply thread
  • Author
    Posts
    • January 22, 2007 at 12:14 PM #17357
      community-content

        input file:

        POH,val1,val2,20070122
        POL,val1,val2,val3
        POL,val1,val2,val3
        POH,val1,val2,20070205
        POL,val1,val2,val3
        POL,val1,val2,val3

        output file should look like this: (the date should be copied to every lines that belong to that header)

        POH,val1,val2
        POL,val1,val2,val3,20070122
        POL,val1,val2,val3,20070122
        POH,val1,val2
        POL,val1,val2,val3,20070205
        POL,val1,val2,val3,20070205

         I used looping functoid and test result is:

        POH,val1,val2
        POL,val1,val2,val3,20070122
        POL,val1,val2,val3,20070122
        POH,val1,val2,20070122,20070205
        POL,val1,val2,val3,20070122
        POL,val1,val2,val3,20070122

        Seems the date in the first header is copied to all the rest Header and Lines….Can map cope with this case, or i have to use orchestration, then how to use xpath to tell if two element belong to a same level….

         Appreciate for any information.

      • January 22, 2007 at 1:29 PM #17359
        community-content

          What are your specific mapping requirements here?

          I would like to help but I'm not sure I understand the pattern.

          • January 22, 2007 at 2:35 PM #17360
            community-content

              Figured it out. I didn't set up the schema properly, after adding tag for Header and Line items and using Looping, the value in Header is correctly copied to all Lines belong to it.

               Thanks

        • Author
          Posts
        Viewing 1 reply thread
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.