foreach - XSLT Group by using 2 different elements -


i'm new xslt. i'm trying group 2 different elements. first worker, pay code. please see amounts sum because of group paycode. below before sample xsl, sample after xsl output.

before:

<?xml version='1.0' encoding='utf-8'?> <file   xmlns:is="java:com.workday.esb.intsys.xpath.parsedintegrationsystemfunctions"     xmlns:tv="java:com.workday.esb.intsys.typedvalue">     <worker>         <detail>             <employeeid>0008765</employeeid>             <firstname>robert</firstname>             <paycode>rsvest</paycode>             <amount>5572.800000</amount>         </detail>         <detail>             <employeeid>0008765</employeeid>             <firstname>robert</firstname>             <paycode>fica</paycode>             <amount>40.000000</amount>         </detail>     </worker>     <worker>         <detail>             <employeeid>0008765</employeeid>             <firstname>robert</firstname>             <paycode>rsvest</paycode>             <amount>13545.000000</amount>         </detail>     </worker>     <worker>         <detail>             <employeeid>00012345</employeeid>             <firstname>russell</firstname>             <paycode>rsvest</paycode>             <amount>84811.050000</amount>         </detail>     </worker> </file>

what output, grouping first worker, group pay code. amounts sum because of grouping:

<?xml version='1.0' encoding='utf-8'?> <file xmlns:xs="http://www.w3.org/2001/xmlschema"     xmlns:tv="java:com.workday.esb.intsys.typedvalue">     <worker>         <detail>             <employeeid>0008765</employeeid>             <firstname>robert</firstname>             <paycode>rsvest</paycode>             <amount>19117.800000</amount>         </detail>         <detail>             <employeeid>0008765</employeeid>             <firstname>robert</firstname>             <paycode>fica</paycode>             <amount>40.000000</amount>          </detail>     </worker>     <worker>         <detail>             <employeeid>00012345</employeeid>             <firstname>russell</firstname>             <paycode>rsvest</paycode>             <amount>84811.050000</amount>         </detail>     </worker> </file>

below xsl doesn't work:

<?xml version="1.0" encoding="utf-8"?> <xsl:stylesheet version="2.0" exclude-result-prefixes="xsl wd xsd env"     xmlns:wd="urn:com.workday/bsvc"      xmlns:xsd="http://www.w3.org/2001/xmlschema"     xmlns:xsl="http://www.w3.org/1999/xsl/transform"      xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"     xmlns:this="urn:this-stylesheet">      <xsl:output indent="yes" method="xml"/>        <xsl:template match="/">               <file>             <worker>                 <xsl:for-each-group select="file" group-by="worker">                     <detail>                                       <employeeid><xsl:value-of select="worker/current-group()/employeeid"></xsl:value-of></employeeid>                         <firstname><xsl:value-of select="//current-group()//firstname"></xsl:value-of></firstname>                         <paycode><xsl:value-of select="paycode"></xsl:value-of></paycode>                         <amount><xsl:value-of select="format-number(sum(current-group()/number(translate(amount,',',''))),'######.00')"></xsl:value-of></amount>                     </detail>                   </xsl:for-each-group>             </worker>         </file>     </xsl:template> </xsl:stylesheet>

can please put sl transform above desired output?
i've been working on hours , waving white flag lol.

thank you!

if want have group each employeeid, , within each such group subgroup each paycode, need nest two xsl:for-each-group instructions. , nodes need grouping detail elements, not root file element of there one.

xslt 2.0

<xsl:stylesheet version="2.0"  xmlns:xsl="http://www.w3.org/1999/xsl/transform"> <xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/> <xsl:strip-space elements="*"/>  <xsl:template match="/file">           <xsl:copy>         <xsl:for-each-group select="worker/detail" group-by="employeeid">             <worker>                 <xsl:for-each-group select="current-group()" group-by="paycode">                     <detail>                                       <xsl:copy-of select="employeeid | firstname | paycode"/>                         <amount>                             <xsl:value-of select="format-number(sum(current-group()/amount),'#.000000')"/>                         </amount>                     </detail>                   </xsl:for-each-group>             </worker>         </xsl:for-each-group>     </xsl:copy> </xsl:template>  </xsl:stylesheet>

-

Comments

Post a Comment

Popular posts from this blog

python - How to insert QWidgets in the middle of a Layout? -

Image
i'm using qt framework build graphical user interface. use qgridlayout position qwidgets neatly. gui looks this: my application regularly adds new widgets gui @ runtime. these new widgets not added @ end of qlayout, somewhere in middle. the procedure bit cumbersome. applied on figure above, need take out widg_c , widg_d , ... qgridlayout. next, add widg_x and widg_y , , put other widgets again. how remove widgets qgridlayout: for in reversed(range(mygridlayout.count())): self.itemat(i).widget().setparent(none) ### as long you're dealing small amount of widgets, procedure not disaster. in application display lot of small widgets - perhaps 50 or more! application freezes second while procedure ongoing, annoying user. there way insert widgets somewhere in qlayout, without need take out other widgets? edit: apparently solution qvboxlayout simple. use function insertwidget(..) instead of addwidget(..) . docs can found link: http://doc.qt.io/qt-5/qboxlayou
Read more

python - serve multiple gunicorn django instances under nginx ubuntu -

i need serve 2 webs apps (django) on gunicorn under different domain names using nginx on ubuntu. started using tutorial: https://www.digitalocean.com/community/tutorials/how-to-set-up-django-with-postgres-nginx-and-gunicorn-on-ubuntu-16-04 it worked fine 1 using that. tried same thing second gives me 502 gateway second domain. tried following tutorial: http://michal.karzynski.pl/blog/2013/10/29/serving-multiple-django-applications-with-nginx-gunicorn-supervisor/ i'm @ part run gunicorn start script: sudo bin/gunicorn_start i response: starting webuildblack root traceback (most recent call last): file "/home/devin/webuildblack/bin/gunicorn", line 7, in <module> gunicorn.app.wsgiapp import run importerror: no module named 'gunicorn.app'; 'gunicorn' not package you have named program gunicorn.py gunicorn -package. rename file , remove gunicorn.pyc file.
Read more

module - Prestashop displayPaymentReturn hook url -

i new prestashop developer , trying create paymentmodule. have got show payment method can not proceed purchase because not know hot works. does know should redirect run hooddisplaypaymentreturn method? i happy if explain me complete navigation map make purchase. anyway, can find relation between hooks , pages? when have new module payment rely on simplest provided prestashop: bankwire. inside can find 3 hooks. hookpayment: public function hookpayment($params) { if (!$this->active) return; if (!$this->checkcurrency($params['cart'])) return; $this->smarty->assign(array( 'this_path' => $this->_path, 'this_path_bw' => $this->_path, 'this_path_ssl' => tools::getshopdomainssl(true, true).__ps_base_uri__.'modules/'.$this->name.'/' )); return $this->display(__file__, 'payment.tpl'); } hookdisplaypaymenteu: public fun
Read more