Solved: how can i remove empty nodes from message mapping?

i have this result when i execute my messagge mapping, but i don't konw how i can remove the empty nodes (red color). I've been testing with various functions "Node functions" but i don't get solve it.

i have this:

<?xml version="1.0" encoding="UTF-8"?>

<ns1:Z_RFC1 xmlns:ns1="urn:sap-com:document:sap:rfc:functions">

<TABLE_1>

<item>

<FIELD1>value1</FIELD1>

<FIELD2>value2</FIELD2>

</item>

<item>

<FIELD1>value1</FIELD1>

<FIELD2>value2</FIELD2>

</item>

</ns1:Z_RFC1>

i want this:

<?xml version="1.0" encoding="UTF-8"?>

<ns1:Z_RFC1 xmlns:ns1="urn:sap-com:document:sap:rfc:functions">

<TABLE_1>

<item>

<FIELD1>value1</FIELD1>

<FIELD2>value2</FIELD2>

</item>

<item>

<FIELD1>value1</FIELD1>

<FIELD2>value2</FIELD2>

</item>

</ns1:Z_RFC1>

can anyone help me?

thanks

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi Mariano,

You could use this xsl, in the operation mapping (interface mapping), to remove all empty tags:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    <xsl:strip-space elements="*"/>
    <xsl:template match="node()|@*">
        <xsl:copy>
            <xsl:apply-templates select="node()|@*"/>
        </xsl:copy>
    </xsl:template>
    <xsl:template match="*[not(@*) and not(*) and (not(text()) or .=-1)]"/>
</xsl:stylesheet>

If you have this XMLfor example:

<?xml version="1.0" encoding="UTF-8"?>
<table>
    <Item>
        <field1>1</field1>
        <field2/>
        <fielda>1</fielda>
        <fieldb/>
        <fieldc/>
        <fieldd/>
        <fielde/>
        <fieldf/>
        <fieldg/>
    </Item>
</table>

You will obtain this one:

<?xml version="1.0" encoding="UTF-8"?>
<table>
    <Item>
        <field1>1</field1>
        <fielda>1</fielda>
    </Item>
</table>

Note:

To import the XSL you need to create an imported archive:

And put this mapping as the last mapping in the operation mapping:

Regards.

Message was edited by: Iñaki Vila

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

perfect.

thank you very much

Hello,

I am using below XSLT to remove empty noded in PI

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:strip-space elements="*"/>

<xsl:template match="node()|@*">

<xsl:copy>

<xsl:apply-templates select="node()|@*"/>

</xsl:copy>

</xsl:template>

<xsl:template match="*[not(@*) and not(*) and (not(text()) or .=-1)]"/>

</xsl:stylesheet>

My XML structure is

Item -> policies -> policy -> Item (many),

It is generating 1st Item and finishing, how to loop for all Item nodes.

Thank you

John

Input

<?xml version="1.0" encoding="UTF-8"?>

<rfc:ZHRO_PBCV3_BEN_INTERFACE1 xmlns:rfc="urn:sap-com:document:sap:rfc:functions">

<ZHR_PBC_XI>

<item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Single</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Vancouver</CITY>

<LINE1>2561 Triumph Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Antonio</FIRSTNAME>

<LASTNAME>Benitez</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Labourer 2</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Single</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>New Westminster</CITY>

<LINE1>821 Burnaby Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Johnathan</FIRSTNAME>

<LASTNAME>Boersma</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Park Patroller</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>PartTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>John Luigi</FIRSTNAME>

<LASTNAME>ARTUSO</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Thomas Paolo Renato</FIRSTNAME>

<LASTNAME>ARTUSO</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Samantha Lauren</FIRSTNAME>

<LASTNAME>ARTUSO</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>4631 E. Pender Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Artuso</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Graphics Technician</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Anisha</FIRSTNAME>

<LASTNAME>Nagpal</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Karan</FIRSTNAME>

<LASTNAME>Nagpal</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Imanjot</FIRSTNAME>

<LASTNAME>CHHINA</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Jaswant K.</FIRSTNAME>

<LASTNAME>CHHINA</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Armrit</FIRSTNAME>

<LASTNAME>CHHINA</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Surrey</CITY>

<LINE1>8917 - 134a Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Kuljinder</FIRSTNAME>

<LASTNAME>Chhina</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Foreman 1 - Grounds Maint</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Stephen John</FIRSTNAME>

<LASTNAME>CHITTICKS</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Gary James</FIRSTNAME>

<LASTNAME>CHITTICKS</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>CHITTICKS</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>6503 Sperling Avenue</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Marilyn</FIRSTNAME>

<LASTNAME>Chitticks</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Booking Coordinator</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>DIERSCH</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>DIERSCH</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>DIERSCH</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>DIERSCH</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>6569 Nolan Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Thomas</FIRSTNAME>

<LASTNAME>Diersch</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Asst Director - Applicati</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Jaclyn Ann</FIRSTNAME>

<LASTNAME>DUNNETT</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Cameron Alan</FIRSTNAME>

<LASTNAME>DUNNETT</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>5488 Mckee Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Linda</FIRSTNAME>

<LASTNAME>Dunnett</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Admin Officer - Licence O</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>KOZAK</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Couple</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Vancouver</CITY>

<LINE1>3280 Laurel Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Edward</FIRSTNAME>

<LASTNAME>Kozak</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Asst Director - Current P</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>PartTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Vancouver</CITY>

<LINE1>1528 East 37th Avenue</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Trung</FIRSTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Building Service Worker L</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Jocelyn D.</FIRSTNAME>

<LASTNAME>Margison</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Couple</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>216 - 5340 Hastings Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Margison</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Labourer 2</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Single</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>North Vancouver</CITY>

<LINE1>693 Sylvan Avenue</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Richard</FIRSTNAME>

<LASTNAME>Mester</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Mgr Business Process & Re</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>PartTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>PERRIN</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Myles David</FIRSTNAME>

<LASTNAME>GILMOUR</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Marcus Daniel</FIRSTNAME>

<LASTNAME>PERRIN</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>GILMOUR</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Wesley Austin</FIRSTNAME>

<LASTNAME>PERRIN</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Elizabeth</FIRSTNAME>

<LASTNAME>Perrin</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Recreation Leader 2</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Teodorico M.</FIRSTNAME>

<LASTNAME>PACSON</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Vermie Ruth</FIRSTNAME>

<LASTNAME>PACSON</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Vermie Ruth</FIRSTNAME>

<LASTNAME>PACSON</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Theo Chris</FIRSTNAME>

<LASTNAME>PACSON</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>PACSON</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>44-5330 Broadway</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Veronidia</FIRSTNAME>

<LASTNAME>Pacson</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Library Clerk 3</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Teresa Ann</FIRSTNAME>

<LASTNAME>LOCKETT</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Meagan Alexis</FIRSTNAME>

<LASTNAME>PELLETIER</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Kaitlin Jean</FIRSTNAME>

<LASTNAME>PELLETIER</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Port Coquitlam</CITY>

<LINE1>1446 Gloria Drive</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Pelletier</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Director - Planning & Bui</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Gary William</FIRSTNAME>

<LASTNAME>JORGENSON</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Couple</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>5935 Elgin Place</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Denise</FIRSTNAME>

<LASTNAME>Jorgenson</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Director - Finance</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>ROBERTSON</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>ROBERTSON</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>ROBERTSON</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>ROBERTSON</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Port Coquitlam</CITY>

<LINE1>3960 Ambleside Close</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Joseph</FIRSTNAME>

<LASTNAME>Robertson</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Staff Officer</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>DETHER</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>SAMESHIMA</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>#105 - 1655 Augusta Avenue</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Janice</FIRSTNAME>

<LASTNAME>Sameshima</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Recreation Leader 2</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>ARLYN MONA MAE</FIRSTNAME>

<LASTNAME>HOULAHAN</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Houlahan</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>HOULAHAN</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>7491 Magnolia Terrace</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Diane</FIRSTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Library Information Clerk</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Kerry Louise</FIRSTNAME>

<LASTNAME>WEISMILLER</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Sarah Louise</FIRSTNAME>

<LASTNAME>WEISMILLER</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>WEISMILLER</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Surrey</CITY>

<LINE1>18935 58 Avenue</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Ronald</FIRSTNAME>

<LASTNAME>Weismiller</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Civil Engineer - Public W</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>PartTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Single</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Vancouver</CITY>

<LINE1>101 - 1345 Comox Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Michelle</FIRSTNAME>

<LASTNAME>Blanchard</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Lifeguard/Instructor Aqua</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Krysta</FIRSTNAME>

<LASTNAME>Shore</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Couple</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Maple Ridge</CITY>

<LINE1>13270 239B Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Shore</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Labourer 2</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>PartTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Violet</FIRSTNAME>

<LASTNAME>Anderson</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Anderson</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Vancouver</CITY>

<LINE1>3444 Nairn Avenue</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Lyndsay</FIRSTNAME>

<LASTNAME>Anderson</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Client Svcs Supervisor</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Single</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Burnaby</CITY>

<LINE1>8059 17th Avenue</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Clodwyn</FIRSTNAME>

<LASTNAME>Patano</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Parks Janitor</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Single</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Port Moody</CITY>

<LINE1>814 Dundonald Drive</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Connor</FIRSTNAME>

<LASTNAME>Ready</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Labourer 2</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>PartTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Pierre</FIRSTNAME>

<LASTNAME>Pluff</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Douglas-Pluff</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Kaden</FIRSTNAME>

<LASTNAME>Douglas-Pluff</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>North Vancouver</CITY>

<LINE1>829 Roche Point Drive</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Monica</FIRSTNAME>

<LASTNAME>Douglas</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Recreation Clerk 2</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Michael S.</FIRSTNAME>

<LASTNAME>Noble</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Christopher</FIRSTNAME>

<LASTNAME>Noble</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>North Vancouver</CITY>

<LINE1>4378 Lions Avenue</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Shararae</FIRSTNAME>

<LASTNAME>Noble</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Database Administrator</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Christine Ann</FIRSTNAME>

<LASTNAME>Morton</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Gig Lorne</FIRSTNAME>

<LASTNAME>Morton</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Cheyenne Madeline</FIRSTNAME>

<LASTNAME>Morton</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Jess Antje</FIRSTNAME>

<LASTNAME>Morton</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

<DEPENDENTSUBCATEGORY>Student</DEPENDENTSUBCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>New Westminster</CITY>

<LINE1>1102 - 892 Carnarvon Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Morton</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Building Inspector 3</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

<item>

<CODE/>

<item>

<CLASS>

</CLASS>

<TYPE>FullTimeHourly</TYPE>

</CURRENTEMPLOYMENTRECORD>

<TYPE/>

</CURRENTINCOME>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Sloat</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>SPOUSE</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<FIRSTNAME>Samuel</FIRSTNAME>

<LASTNAME>Sloat</LASTNAME>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

<item>

</COVERAGEDECLINES>

</CONTACTS>

<CITY/>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Sloat</LASTNAME>

<SEX>Female</SEX>

</COVEREDLIFEHOLDER>

<DEPENDENTCATEGORY>CHILD</DEPENDENTCATEGORY>

</item>

</COVEREDLIFE>

</DEPENDENTS>

</DIVISION>

<FAMILYCATEGORY>Family</FAMILYCATEGORY>

</HEALTHCARESPENDINGACCOUNT>

</COVERAGEDECLINES>

</CONTACTS>

<CITY>Vancouver</CITY>

<LINE1>3785 Maxwell Street</LINE1>

</DEFAULTADDRESS>

<DATA/>

</DEFAULTEMAIL>

<DATA/>

</DEFAULTPHONE>

<LASTNAME>Sloat</LASTNAME>

</COVEREDLIFEHOLDER>

<STATUS>Active</STATUS>

</INSUREDCOVEREDLIFE>

<JOBTITLE>Planner 1</JOBTITLE>

<PLAN>

</PLAN>

</REGIONALADMINISTRATION>

<CODE/>

</SECTION>

</item>

</CERTIFICATE>

</CERTIFICATES>

</item>

</POLICY>

</POLICIES>

</item>

</ZHR_PBC_XI>

</rfc:ZHRO_PBCV3_BEN_INTERFACE1>

Hello

I have input file format like below :

I am using below XSLT in my mapping:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:strip-space elements="*"/>

<xsl:template match="node()|@*">

<xsl:copy>

<xsl:apply-templates select="node()|@*"/>

</xsl:copy>

</xsl:template>

<xsl:template match="*[not(@*) and not(*) and (not(text()) or .=-1)]"/>

</xsl:stylesheet>

I am receiving output file as:

current XSLT logic is only eliminating attributes of the empty node.

How can I remove both empty nodes and all empty attributes from my input message.

Thank you

John

Answers (4)

<?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="node()|@*"> <xsl:if test="normalize-space(string(.)) != ''"> <xsl:copy> <xsl:apply-templates select="node()|@*"/> </xsl:copy> </xsl:if> </xsl:template> </xsl:stylesheet>

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Gracias por tu pronta respuesta.

Hi Mariano, Inaki's solution is good if you can work with imported functions.

I assume you want to do this only with graphic mapping. If yes, probably use the Exists plus CreateIf node function based on Field1/2 when mapping to the item node.

Please give more example of what you've tried, and what your logic flow is currently in the GUI mapping. Maybe post a screen shot?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Mariano,

Use below logic

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Mariano,

did you try with CreateIf node function as below also,

also change context also.

if not then please that can solve ur problem i think.

Regards

Gagandeep

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Ask a Question

Top Q&A Solution Author

User

Count

how can i remove empty nodes from message mapping?

Accepted Solutions (1)

Accepted Solutions (1)

Answers (4)

Answers (4)

Re: How to Get history of SQL Statements ran for o...

How to Get history of SQL Statements ran for one y...

Re: CAP authentication

Re: Has the SAP Master Data Integration service be...

Infix filters in CAP Node.js not working