I have given my XML and XSL below. The rest all is taken care of. All I
want to do is Combine all cost_allocation_product into one and append
all values for the attributes when doing thiss.
<cost_allocation_product>
<dbfield name ="cost_allocation_product_project" value= "1725 -
Project1,1774 - Project2,1755 - Project3" />
<dbfield name="cost_allocation_product_percent" value="12,1,87" />
</cost_allocation_product>
This is my XML:
<?xml version="1.0" encoding="utf-8"?>
<payload id="eRequest.Purchase Desktop or Laptop Inventory.Initiate">
<erpayload>
<basicinfo basicinfo_requestPriority="Normal"
basicinfo_requestExpectedDate="" />
<genericrequestdetail genericrequestdetail_description="testing"
genericrequestdetail_include_section="true" />
<purchasing purchasing_purchasing_status=" "
purchasing_acknowleged="" purchasing_btn_Add_CER_PO=""
purchasing_details="" purchasing_gl_account="12n (12233)"
purchasing_capital_sequence_number="82"
purchasing_gl_project="170System" purchasing_budget_year="26"
purchasing_item_description="testing" purchasing_amount="0.00"
purchasing_include_section="true">
<add_CER_PO id="0" cer_number="" cer_created="" po_number=""
po_created="" Vendor="" />
<cost_allocation_product id="0" project="170upport" percent="12"
/>
<cost_allocation_product id="1" project="171stem" percent="1" />
<cost_allocation_product id="2" project="170tem" percent="87" />
</purchasing>
<generalcomments generalcomments_comments=""
generalcomments_copyToChild="true"
generalcomments_include_section="true" />
<attachments attachments_copyToChild="true"
attachments_include_section="true" />
<promoted-property />
</erpayload>
</payload>
MY XSL:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform";>
<xsl:output method="xml"/>
<xsl:template match="/">
<erpayload>
<xsl:apply-templates select="//erpayload/* | //erpayload/*/*"/>
</erpayload>
</xsl:template>
<
l:copy-of select="."/>
<basicinfocondensed>
<xsl:apply-templates select="@basicinfo_initiatorFullName"/>
<xsl:apply-templates select="@basicinfo_initiatorPhone"/>
<xsl:apply-templates select="@basicinfo_requestedForFullName"/>
<xsl:apply-templates select="@basicinfo_requestedForPhone"/>
<xsl:apply-templates select="@basicinfo_department_name"/>
<xsl:apply-templates select="@basicinfo_location"/>
</basicinfocondensed>
</xsl:template>
<xsl:template match="generalcomments">
<xsl:copy-of select="."/>
</xsl:template>
<xsl:template match="add_CER_PO">
<xsl:element name="{name()}">
<xsl:apply-templates select="@cer_number"/>
<xsl:apply-templates select="@cer_created"/>
<xsl:apply-templates select="@po_number"/>
<xsl:apply-templates select="@po_created"/>
<xsl:apply-templates select="@Vendor"/>
</xsl:element>
</xsl:template>
<xsl:template match="@cer_number | @cer_created | @po_number |
@po_created | @Vendor">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="concat('add_CER_PO_',node())"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="cost_allocation_factor" >
<xsl:value-of select="." />
<xsl:text>,</xsl:text>
</xsl:template>
<xsl:template match="*">
<xsl:element name="{name()}">
<xsl:apply-templates select="@*"/>
</xsl:element>
</xsl:template>
<xsl:template match="@*">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="name()"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@basicinfo_initiatorFullName">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="name()"/>
</xsl:attribute>
name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@basicinfo_initiatorPhone">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="name()"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@basicinfo_requestedForFullName">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="name()"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@basicinfo_requestedForPhone">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="name()"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@basicinfo_initiatorFullName">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="name()"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@basicinfo_initiatorFullName">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="name()"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@basicinfo_department_name">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="name()"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@basicinfo_location">
<dbField>
<xsl:attribute name="name">
<xsl:value-of s
ttribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@subrequest">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="concat(name(parent::node()),
'_subrequest')"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
<xsl:template match="@subrequestguid">
<dbField>
<xsl:attribute name="name">
<xsl:value-of select="concat(name(parent::node()),
'_subrequestguid')"/>
</xsl:attribute>
<xsl:attribute name="value">
<xsl:value-of select="."/>
</xsl:attribute>
</dbField>
</xsl:template>
</xsl:stylesheet>
-----Original Message-----
From: Abel Braaksma [mailto:abel(_dot_)online(_at_)xs4all(_dot_)nl]
Sent: Thursday, March 29, 2007 12:41 PM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Output multiple occurence into one and concatenate
values
Shaikh, Parvez wrote:
I have an XML that has 2 or more occurences of data. I want to comma
delimit the attribute values and output it only once. How do you do
that
You did not include your XSLT, so I have no clues as to how you go wrong
or what you tried. Do you use XSLT 1 or 2? In XSLT 2 you can do this:
<xsl:value-of select="//@project" separator="," />
make sure you place it in the right context. But to help you with that,
we need to have a look at your current XSLT and what it currently
(wrongly) produces.
In XSLT 1, btw, you can simply use apply-templates on the selection of
the attribute nodes and do this in the matching template:
<xsl:template match="@project" >
<xsl:value-of select="." />
<xsl:text>,</xsl:text>
</xsl:template>
Cheers,
-- Abel Braaksma
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.
il: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--
-----------------------------------------
The information contained in this transmission may be privileged and
confidential and is intended only for the use of the person(s) named
above. If you are not the intended recipient, or an employee or agent
responsible
for delivering this message to the intended recipient, any review,
dissemination,
distribution or duplication of this communication is strictly prohibited. If
you are
not the intended recipient, please contact the sender immediately by reply
e-mail
and destroy all copies of the original message. Please note that we do not
accept
account orders and/or instructions by e-mail, and therefore will not be
responsible
for carrying out such orders and/or instructions. If you, as the intended
recipient
of this message, the purpose of which is to inform and update our clients,
prospects
and consultants of developments relating to our services and products, would not
like to receive further e-mail correspondence from the sender, please "reply"
to the
sender indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New
York,
NY 10105.
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--