Accumulations (Group By) in BizTalk 2006

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Accumulations (Group By) in BizTalk 2006

Viewing 2 reply threads
  • Author
    Posts
    • September 29, 2006 at 9:06 AM #15897
      community-content

        We have a Data message with invoice details loaded from a SQL Server database consisting of 10-15 fields.  In essence we want to optionally perform a grouping and flatten those invoice details into a single record for the month containing only 5 of the 15 fields, but only if one of the fields has a specific value.  I am relatively new to BizTalk and wondering what the best way I can do this is (i need to be pointed into the right direction :-).  The difficulty is added by the fact that this needs to be configurable to an extent (i.e., accumulate daily vs. monthly, or not at all).  The system takes this source data, optionally flattens it and then transforms it into a flat file of a pre-specified format.

        Thanks for any direction you may provide.

         Ken McAfee, MCSD

      • September 29, 2006 at 1:12 PM #15902
        community-content

          You need a Logical Functoid (Equalto) and link its value to different Value Mapping (Flattening) functoid (for as many values as you care to have in the destination instance). Look them up.

        • September 29, 2006 at 1:14 PM #15903
          community-content

            You need a Logical (EqualTo) functoid and link its value to as many of Value Mapping (Flattening) functoid as you want elements to map – each of whose second input should be the values you want to map.

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