I need to remove duplicate records from source and map to destination.
The source and destination schemas are same.
Source File/Schema:
<ns0:ExternalEmployees xmlns:ns0="http://BizTalk_Server_Project2.Schema1">
<packages>
<package>
<AddOns>
<AddOn-Bundled Category="Legal" SubType="Independent" Type="Core" />
<AddOn-Bundled Category="Home" SubType="Independent" Type="Core" />
<AddOn-Bundled Category="Home" SubType="Independent" Type="Core" />
</AddOns>
</package>
</packages>
</ns0:ExternalEmployees>
Map XSLT :
<?xml version="1.0" encoding="UTF-16"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:var="http://schemas.microsoft.com/BizTalk/2003/var" exclude-result-prefixes="msxsl var s0" version="1.0" xmlns:ns0="http://BizTalk_Server_Project2.Schema2" xmlns:s0="http://BizTalk_Server_Project2.Schema1">
<xsl:output omit-xml-declaration="yes" method="xml" version="1.0" />
<xsl:template match="/">
<xsl:apply-templates select="/s0:ExternalEmployees" />
</xsl:template>
<xsl:template match="/s0:ExternalEmployees">
<ns0:ExternalEmployees>
<packages>
<xsl:for-each select="packages">
<xsl:for-each select="package">
<package>
<AddOns>
<xsl:for-each select="AddOns/AddOn-Bundled">
<AddOn-Bundled>
<xsl:if test="@Category">
<xsl:attribute name="Category">
<xsl:value-of select="@Category" />
</xsl:attribute>
</xsl:if>
<xsl:if test="@SubType">
<xsl:attribute name="SubType">
<xsl:value-of select="@SubType" />
</xsl:attribute>
</xsl:if>
<xsl:if test="@Type">
<xsl:attribute name="Type">
<xsl:value-of select="@Type" />
</xsl:attribute>
</xsl:if>
</AddOn-Bundled>
</xsl:for-each>
</AddOns>
</package>
</xsl:for-each>
</xsl:for-each>
</packages>
</ns0:ExternalEmployees>
</xsl:template>
</xsl:stylesheet>
ExpectedOutput
<ns0:ExternalEmployees xmlns:ns0="http://BizTalk_Server_Project2.Schema1">
<packages>
<package>
<AddOns>
<AddOn-Bundled Category="Legal" SubType="Independent" Type="Core" />
<AddOn-Bundled Category="Home" SubType="Independent" Type="Core" />
</AddOns>
</package>
</packages>
</ns0:ExternalEmployees>