Record Count Issue

Home Page Forums BizTalk 2004 – BizTalk 2010 Record Count Issue

Viewing 1 reply thread
  • Author
    Posts
    • #21379

      Hi,

      I want to calculate total no of a chailed record.

      schema structure is as follows:

      <Root>
      <body>—Max/Min Occur: 1
      <Record1>Max Occur: Unbound
          <subRecord1>Max Occur: Unbound
          <Field11>   
          <Field12>
          <Field13>
             <subRecord2>Max Occur: Unbound
             <Field21>
             <Field22>
             <Field23>    
      I want to map count of <subRecord2> to Field12(body->subRecord1->Field12).

      we can use Record count,but, which returns count of records/fields in input message instance.

      I want count of <subRecord2> at <Record1> level, Cause Record1 is also repeating.

      using Iteration Funtoid, I am able to get count of <subRecord2> but it returns each iteration number.

      But I need final Iteration Number only.

      Can anybody help me … Please Its Very Urgent…

    • #21400

      Hi!

      Connect a scripting-functoid between subRecord2 and the target-node where you need the count-value. Configure functoid script, select “Inline Xslt Call Template” and paste the following code:

      <xsl:template name=”MyCountTemplate”>
      <xsl:param name=”inRecord” />
      <!– Below, the name of the target-node –>
      <xsl:element name=”Field12″>
      <xsl:value-of select=”count(./*)” />
      </xsl:element>
      </xsl:template>

      //Niklas – Connecta AB

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