problem in keeping references of previous records…

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › problem in keeping references of previous records…

Viewing 1 reply thread
  • Author
    Posts
    • February 9, 2007 at 1:20 AM #17611
      community-content

        Hi All,

        I'm very new to BizTalk and want to produce XML Schema for a flat file that looks like:Tag+CategoryName+Code+CategoryId+ParentcategoryID

        Input File is :

        Category+Cname1+00.00+Cname1Id+CName1Id
        Category+Cname2++Cname2Id+CName1Id
        Category+Cname3++Cname3Id+CName1Id

        My problem is that:I want that child code should be parentcode+.00 or parentcode+.01 etc…with each chilren category found

        like for above file
        Cname1 code is 00.00
        i want Cname2 code = 00.00.01
        likewise Cname3 code should be = 00.00.02 (as its the second category of same parent).

        Can i do this by BizTalk mapping.

         

      • February 9, 2007 at 10:39 AM #17624
        community-content

          Anon –

          You may want to define the header row as a record and the child code as a subordinate loop.

          You can calculate the child codes with a counter and format the value to the appropriate format you seek.

           -wa

          • February 9, 2007 at 10:40 AM #17625
            community-content

              "You may want to define the parent as its own record and the child records as a subordinate loop record" is what I meant to write -wa

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