xslt - How to group at more than one level? -

-

i have xml file:

<document>     <line id="0">         <field id="2">x111</field>         <field id="3">1</field>         <field id="4">222222222222</field>     </line>     <line id="1">         <field id="2">x111</field>         <field id="3">1</field>         <field id="4">111111111111</field>     </line>     <line id="2">         <field id="2">x222</field>         <field id="3">1</field>         <field id="4">111111111111</field>     </line>     <line id="3">         <field id="2">x222</field>         <field id="3">1></field>         <field id="4">111111111111</field>     </line>     <line id="4">         <field id="2">x333</field>         <field id="3">1</field>         <field id="4">111111111111</field>     </line> </document>

from xml file should group field2 (after field4 ), question not how group field 2 , 3 documents how group field4 if same?

output:

<document> <result>     <header>         <field2>x111</field2>     </header>     <line>         <position>1</position>         <field4>222222222222</field4>         <sum>1<sum>         <position>2</position>         <field4>111111111111</field4>         <sum>1<sum>     </line> </result> <result>     <header>         <field2>x222</field2>     </header>     <line>         <position>1</position>         <field4>111111111111</field4>         <sum>2<sum>     </line> </result> <result>     <header>         <field2>x333</field2>     </header>     <line>         <position>1</position>         <field4>111111111111</field4>         <sum>1</sum>     </line> </result> </document>

i'm stuck in grouping lines, didn't know how group same , different fields id= 4.

my program looks:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform" xmlns:fo="http://www.w3.org/1999/xsl/format">     <xsl:output method="xml" encoding="utf-8" indent="yes"/>     <xsl:key name="kline" match="line" use="string(field[@id=2])"/>     <xsl:key name="bline" match="line" use="field[@id=4]"/>     <xsl:template match="document">         <document>             <xsl:apply-templates select="line[count( . | key('kline', string(field[@id='2']))[1]) = 1]"/>         </document>     </xsl:template>     <xsl:template match="line">         <xsl:variable name="field2" select="field[@id='2']"/>         <result>             <header>                 <xsl:value-of select="field[@id='2']"/>             </header>             <line>             <xsl:for-each select="//line[field[@id='2']=$field2]">                 <position>                     <xsl:value-of select="position()"/>                 </position>                 <field4><xsl:value-of select="field[@id='4']"/></field4>                 <sum><xsl:value-of select="sum(key('bline', field[@id='4'])/field[@id='3'])"/></sum>             </xsl:for-each>             </line>         </result>     </xsl:template> </xsl:stylesheet>

you're asking how group @ multiple levels. following stylesheet:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/xsl/transform">     <xsl:key name="byfield2" match="line" use="field[@id='2']" />     <xsl:key name="byfield2andfield4" match="line"              use="concat(field[@id='2'], '|', field[@id='4'])" />     <xsl:template match="/">         <document><xsl:apply-templates /></document>     </xsl:template>     <xsl:template         match="line[generate-id() =                      generate-id(key('byfield2', field[@id='2'])[1])]">         <result>             <header>                 <field2><xsl:value-of select="field[@id='2']" /></field2>             </header>             <line>                 <xsl:apply-templates                     select="key('byfield2', field[@id='2'])                          [generate-id() =                           generate-id(key('byfield2andfield4',                              concat(field[@id='2'], '|', field[@id='4']))[1])]"                     mode="field4" />             </line>         </result>     </xsl:template>     <xsl:template match="line" mode="field4">         <position><xsl:value-of select="position()" /></position>         <field4><xsl:value-of select="field[@id='4']" /></field4>         <sum>             <xsl:value-of               select="sum(key('byfield2andfield4',                  concat(field[@id='2'], '|', field[@id='4']))/                      field[@id='3'])" />         </sum>     </xsl:template>     <xsl:template match="line" /> </xsl:stylesheet>

on input:

<document>     <line id="0">         <field id="2">x111</field>         <field id="3">1</field>         <field id="4">222222222222</field>     </line>     <line id="1">         <field id="2">x111</field>         <field id="3">1</field>         <field id="4">111111111111</field>     </line>     <line id="2">         <field id="2">x222</field>         <field id="3">1</field>         <field id="4">111111111111</field>     </line>     <line id="3">         <field id="2">x222</field>         <field id="3">1></field>         <field id="4">111111111111</field>     </line>     <line id="4">         <field id="2">x333</field>         <field id="3">1</field>         <field id="4">111111111111</field>     </line> </document>

produces desired result:

<document>     <result>         <header>             <field2>x111</field2>         </header>         <line>             <position>1</position>             <field4>222222222222</field4>             <sum>1</sum>             <position>2</position>             <field4>111111111111</field4>             <sum>1</sum>         </line>     </result>     <result>         <header>             <field2>x222</field2>         </header>         <line>             <position>1</position>             <field4>111111111111</field4>             <sum>2</sum>         </line>     </result>     <result>         <header>             <field2>x333</field2>         </header>         <line>             <position>1</position>             <field4>111111111111</field4>             <sum>1</sum>         </line>     </result> </document>

we use 2 keys. first groups field 2. second groups concatenation of fields 2 , 4.


Comments

Post a Comment

Popular posts from this blog

php - What is the difference between $_SERVER['PATH_INFO'] and $_SERVER['ORIG_PATH_INFO']? -

-
what’s difference between $_server['path_info'] , $_server['orig_path_info'] ? how use them? when run print_r($_server) , path_info , orig_path_info not present in array. why not? how can enable them? i have read php manual on them, still don’t understand them. the path_info variable present if invoke php script this: http://www.example.com/phpinfo.php/hello_there it's /hello_there part after .php script. if don't invoke url that, there won't $_server["path_info"] environment variable. the porig_ prefix uncommon. path_info standard cgi-environment variable, , should never prefixed. did read that? (there issues around php3/php4 if invoked php interpreter via cgi-bin/ - hardly has such setups today.) for reference: http://www.ietf.org/rfc/rfc3875
Read more

fortran - Function return type mismatch -

-
i'm attempting recode old c++ program in fortran make use of lapack (i'm aware c++ have lapack++, i'm having lot of trouble installing it, gave up). i didn't have problems compilation, when had variables declared real . when started coding section of program required lapack, found parameters passed dsyev need double precision . tried change double precision (including changing hard coded numbers double precision counterparts, i.e. 0.0 -> 0.0d0) when try compile, following error of functions , subroutines i've written: error: return type mismatch of function <function> @ (1) (real(4)/real(8)) i'm not sure coming from, in program has been changed double precision. for example, i've declared following: double precision :: alpha(3),d(3),zeta1,zeta2 double precision :: a1(3),a2(3),d1(3),d2(3) double precision :: pi pi = 3.14159265359d0 alpha = (/0.109818d0, 0.405771d0, 2.22766d0/) d = (/0.444635d0, 0.535328d0, 0.154329d0 /) 10 i=1,3 ...
Read more

queue - mq_receive: message too long -

-
i implementing communication between 2 processes using queue. problem when call function mq_receive, error: message long. i have done following: struct mq_attr attr; long size = attr.mq_msgsize; .... // initializing queue "/gateway" int rc = mq_receive(gateway, buffer, size, &prio); if print size value, size=1, while when print same size program (got same mechanism), not long integer ( -1217186280 )... how can solve error?....so while size = 1, believe it's right "message long" why 1? p.s. have tried put : int rc = mq_receive(gateway, buffer, sizeof(buffer), &prio); but no result. it seems need read docs more carefully. when call mq_receive should pass size of destination buffer. this size must greater mq_msgsize attribute of queue . in addition, seems have error in queue attributes initialisation makes proper mq_receive call impossible. here standard message queue session: fill mq_attr struct ( doc ): struct mq_a...
Read more