Home Page › Forums › BizTalk 2004 – BizTalk 2010 › breaking continuous records into desired format
- This topic has 4 replies, 1 voice, and was last updated 4 years, 3 months ago by
biztalkgurus.
-
AuthorPosts
-
-
October 29, 2005 at 10:12 PM #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.
-
November 7, 2005 at 11:26 PM #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.
-
October 28, 2005 at 9:24 AM #12130
Hi there,
I am having a problem in mapping in Biztalk using functoidsInput :
<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
-
-
-
November 7, 2005 at 12:38 PM #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] -
November 10, 2020 at 2:47 PM #49682
biztalkgurus
Pumpkinheads ~ Rainbow Rowell ~ 9781250312853
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.