Debatching based on schema attribute vlaue.

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Debatching based on schema attribute vlaue.

Viewing 1 reply thread
  • Author
    Posts
    • August 28, 2009 at 3:43 AM #23140
      community-content

        I have a source schema and destination schema. In the source schema I have 4 records.

        For Ex:  ID        Name

                      100      raj

                       200     ram

                       100       shiva

                       200       Krishna.

        In the Destination Id is an attribute. When I map the source to destination I should get two records based on Attribute key like

        <Employee ID = 100>

             <Name>ram</Name>            

             <Name>shiva</Name>      </Employee>

        <Employee ID = 200>

             <Name>Krishna</Name>            

             <Name>shiva</Name>      </Employee>

         Please help me How can I get the above out put.

        Thanks in advance

      • August 29, 2009 at 3:03 PM #23155
        community-content

          Hi,

          In your map, you should have a Loop functoid connecting your source record node to your target record node, in addition to your other field mappings; that should resolve your issue.

          Daniel.

          • August 31, 2009 at 12:39 AM #23163
            community-content

              Thanks for the reply Daniel,

              I tried as you mentioned, but is displaying as different records.  I need the out put when the attribute values are same it should come under single record.

              Regards,

              Praveen.

              • August 31, 2009 at 9:12 PM #23174
                community-content

                  Hi Praveen,

                     You will need to change your destination schema to the following:

                  <RecordType1 Attribute=EmployeeID>

                         <RecordType2 Attribute=Name>

                         </RecordType2>

                  </RecordType1>

                      Both RecordType1 and RecordType2 will have unlimited maximum number of occurrences.

                   

                  Daniel.

                  • September 9, 2009 at 6:08 AM #23205
                    community-content

                      Daniel, My requirement is

                      If ID value is same then it should come under one record.

                      For Ex If Id value is same for 5 records all the five records should come under one <Employee> tag.  Please help me getting this…

                      Thanks in advance

                      • September 21, 2009 at 1:38 AM #23284
                        community-content

                          Hi Daniel,

                          I got the solution for this.

                          the solution is we have to use the grouping and debatching concept.

                          Thank you…

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