breaking continuous records into desired format

Home Page Forums BizTalk 2004 – BizTalk 2010 breaking continuous records into desired format

Viewing 2 reply threads
  • Author
    Posts
    • #12128

      Hello.

      I would use custom XSLT with input parameters of your input message like Name, Project, Day1, Day2, and ext. I think you would have 16 parameters total.

      Then, I would use code like this inside a Script Functoid – using XSLT Template:
      <xsl:template name=\”yourNameHere\”>
      <xsl:param name=\”param1\”/>
      <xsl:param name=\”param2\”/>
      <xsl:param name=\”param3\”/>
      <xsl:param name=\”param4\”/>
      <xsl:param name=\”param5\”/>
      <xsl:param name=\”param6\”/>
      <xsl:element name=\”General\”>
      <xsl:element name=\”Name\”><xsl:value-of select=\”$params1\” /></xsl:element>
      <xsl:element name=\”Project\”><xsl:value-of select=\”$params2\” /></xsl:element>
      <xsl:element name=\”Day\”><xsl:value-of select=\”$params3\” /></xsl:element>
      <xsl:element name=\”Time\”><xsl:value-of select=\”$params4\” /></xsl:element>
      </xsl:element>
      <xsl:element name=\”General\”>
      <xsl:element name=\”Name\”><xsl:value-of select=\”$params1\” /></xsl:element>
      <xsl:element name=\”Project\”><xsl:value-of select=\”$params2\” /></xsl:element>
      <xsl:element name=\”Day\”><xsl:value-of select=\”$params5\” /></xsl:element>
      <xsl:element name=\”Time\”><xsl:value-of select=\”$params6\” /></xsl:element>
      </xsl:element>
      </xsl:template>

      Note this is not complete.

      Hope this helps.

      • #12129

        Ok, you are getting past my XSLT knowledge

        You might want to try using some type of If logic and checking the input node name to get it to work. Maybe even pass in a default value if the node is null.

        Just some thoughts.

        Hope this helps.

        • #12130

          Hi there,
          I am having a problem in mapping in Biztalk using functoids

          Input :

          <UserInfo>
          <Name>Vishal Dube</Name>
          <Project>Project Name</Project>
          <Day>Mon 3</Day>
          <Day>Tue 4</Day>
          <Day>Wed 5</Day>
          <Day>Thu 6</Day>
          <Day>Fri 7</Day>
          <Day>Sat 8</Day>
          <Day>Sun9</Day>
          <Time>8h</Time>
          <Time>8h</Time>
          <Time>8h</Time>
          <Time>8h</Time>
          <Time>8h</Time>
          <Time>0h</Time>
          <Time>0h</Time>
          </UserInfo>

          Output :

          <General>

          <Name> Vishal Dube</Name>
          <Project>Project Name</Project>
          <Day>Mon 3</Day>
          <Time>8H</Time>

          </General>

          <General>

          <Name> Vishal Dube</Name>
          <Project>Project Name</Project>
          <Day>Tue 4</Day>
          <Time>8H</Time>

          </General>

          <General>

          <Name> Vishal Dube</Name>
          <Project>Project Name</Project>
          <Day>Wed 5</Day>
          <Time>8H</Time>

          </General>

          <General>

          <Name> Vishal Dube</Name>
          <Project>Project Name</Project>
          <Day>Thus 6</Day>
          <Time>8H</Time>

          </General

          <General>
          <Name> Vishal Dube</Name>
          <Project>Project Name</Project>
          <Day>Fri 7</Day>
          <Time>8H</Time>

          </General

          <General>
          <Name> Vishal Dube</Name>
          <Project>Project Name</Project>
          <Day>Sat 8</Day>
          <Time>0H</Time>

          </General

          <General>
          <Name> Vishal Dube</Name>
          <Project>Project Name</Project>
          <Day>Sun 9</Day>
          <Time>0H</Time>

          </General

          Please help me with these and as soon as possible

          With Regards,
          Vishal Dube

    • #12127

      [quote:d97f42590f]Hi
      It works when the number of records are constant but if the number of records are not constant pleae reply with that
      [/quote:d97f42590f]

    • #49682
      biztalkgurus

        Pumpkinheads ~ Rainbow Rowell ~ 9781250312853

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