How to set a default value to an destination schema element in BizTalk Map

HI All,

I have a requirement in BizTalk map, where

1.I will map some elements from source schema to destination
schema, where the values will be assigned to destination schema’s different elements
from the same elements in source schema based on some condition. That means my Source element loops, based on some id i have fetch the data and fill it to the flat structure in the destination schema.

2.If those values are not assigned, i need to send some default value (N/A).

1. My map is not One-to-One so that i can use a scripting functoid and
   send a default value, on top of that the destination schema is a flat
   file and in source schema i have to loop a lot.

so can any body give me some suggestion about “How to set a Default
value to a Element in Destination schema if nothing is mapped” using
BizTalk Map/some setting in schema.

What i have already tried is, I Opened the destination schema for
all the elements i have set the value ‘N/A’ to a property ->
“DefaultValue” which was there in the property tab but when nothing is
mapped the default value is not coming. Instead the node itself is not
created in the Output file.

Pls see the Map below for a good understanding

Source Schema is a XML schema.

Destination Schema is a Flat file schema.

Now in the above map, in my source schema i am having a node called F4706 which will loop.

1) when the element “TypeAddressNumber” within the F4706 is “1“,then i am the mapping the remaining fields of that F4706 instance to “ship to” details in my destination schema

2) when the element “TypeAddressNumber” within the F4706 is “2“,then i am the mapping the remaining fields of that F4706 instance to “Reseller” details in my destination schema

3) when the element “TypeAddressNumber” within the F4706 is “3“,then i am the mapping the remaining fields of that F4706 instance to “EndUser” details in my destination schema

Now if i connect a Logical NOT functoid to the Logical Equal functoid and assign some default value, then the my destination node occurs Three times as one time the “=” functiod returns true one time and false other two times. but what i want is, if anything is there to  map then map from “F4706” instance or assign the default value.

Find the INPUT File below

the ouput i m expecting and getting is :

Now if the Input file is like below :

that is when i dont have a “F4706” node with TypeAddressNumber=2, i need to fill “N/A” in Reseller related nodes in my destination schema. which should look like below :

If you go and check the XLST which is getting generated,(i have pasted for the first node “Reseller Name”)

it was like this, even if i modify this like the below it will create the node “Thrice” or how many time it loops that much time.[Because it is a Foreach, and i dont have any break or return in XLST i am unable to do it]

<xsl:for-each select=”F4706″>
<xsl:variable name=”var:v1″ select=”TypeAddressNumber” />
 <xsl:variable name=”var:v2″ select=”userCSharp:LogicalEq(string($var:v1) , &quot;2&quot;)” />
       <xsl:choose>
               <xsl:when test=”string($var:v2)=’true'”>
                    <xsl:variable name=”vartan1″ select=”100″ />
                        <ResName>
                               <xsl:value-of select=”Name” />
                          </ResName>
                  </xsl:when>
                  <xsl:otherwise>
                            <ResName>
                                <xsl:value-of select=”N/A” />
                            </ResName>
                    /xsl:otherwise>
                    </xsl:choose>
</xsl:for-each>

I also tried to use some global variable in XLST in First Loop and and second loop to access that and write the default value, unfortunately it doesn’t work too. Because a VARIABLE in XLST is not a TRUE variable. I think its a CONSTANT.

How to accomplish this ANY help is highly appreciated.

Advanced Thx

–santhosh(http://aledaata.blogspot.com)