xsl-list
[Top] [All Lists]

RE: Using key and position()

2004-11-17 09:06:12
Hi Micheal,
Thanks for the advice. 

I have an input XML like this:

<action>
  - <ParentGroup Desc> Desc Node1 </ParentGroup Desc>
  - <ParentGroup> Node1 </ParentGroup>
  - <ChildGroup> Node1.1 </ChildGroup>
  - <Child Node1>1.1.1 </Child Node1>
  - <Child Node2>1.1.2 </Child Node2>
  - <Child Node3>1.1.3 </Child Node3>   
  - <ParentGroup Desc> Desc Node1 </ParentGroup Desc>
  - <ParentGroup> Node1 </ParentGroup>
  - <ChildGroup> Node1.2 </ChildGroup>
  - <Child Node1>1.2.1 </Child Node1>
  - <Child Node2>1.2.2 </Child Node2>
  - <Child Node3>1.2.3 </Child Node3>   
  - <ParentGroup Desc> Desc Node1 </ParentGroup Desc>
  - <ParentGroup> Node1 </ParentGroup>
  - <ChildGroup> Node1.3 </ChildGroup>
  - <Child Node1>1.3.1 </Child Node1>
  - <Child Node2>1.3.2 </Child Node2>
  - <Child Node3>1.3.3 </Child Node3>   
  - <ParentGroup Desc> Desc Node1 </ParentGroup Desc>
  - <ParentGroup> Node1 </ParentGroup>
  - <ChildGroup> Node1.3 </ChildGroup>
  - <Child Node1>1.3.x </Child Node1>
  - <Child Node2>1.3.y </Child Node2>
  - <Child Node3>1.3.z </Child Node3>   
  
  - <ParentGroup Desc> Desc Node2 </ParentGroup Desc>
  - <ParentGroup> Node2 </ParentGroup>
  - <ChildGroup> Node2.1 </ChildGroup>
  - <Child Node1>2.1.1 </Child Node1>
  - <Child Node2>2.1.2 </Child Node2>
  - <Child Node3>2.1.3 </Child Node3>   
  - <ParentGroup Desc> Desc Node2 </ParentGroup Desc>
  - <ParentGroup> Node2 </ParentGroup>
  - <ChildGroup> Node1.2 </ChildGroup>
  - <Child Node1>2.2.1 </Child Node1>
  - <Child Node2>2.2.2 </Child Node2>
  - <Child Node3>2.2.3 </Child Node3>   
  - <ParentGroup Desc> Desc Node2 </ParentGroup Desc>
  - <ParentGroup> Node2 </ParentGroup>
  - <ChildGroup> Node2.3 </ChildGroup>
  - <Child Node1>2.3.1 </Child Node1>
  - <Child Node2>2.3.2 </Child Node2>
  - <Child Node3>2.3.3 </Child Node3>   
..........
</action>

Please Note: All the above nodes are at the same
level. I have to change the input XML level wise like
this:

<Document>
 <ParentGroup Node1>
  <PRIMARY_CUST_DESC>Desc Node1</PRIMARY_CUST_DESC>
  <ChildGroup Node1.1 >
        <ACCOUNT_SUMMARY>
        - <Child Node1>1.1.1 </Child Node1>
        - <Child Node2>1.1.2 </Child Node2>
        - <Child Node3>1.1.3 </Child Node3>
        <ACCOUNT_SUMMARY>
  </ChildGroup>
  <ChildGroup Node1.2 >
        <ACCOUNT_SUMMARY>
        - <Child Node1>1.2.1 </Child Node1>
        - <Child Node2>1.2.2 </Child Node2>
        - <Child Node3>1.2.3 </Child Node3>
        </ACCOUNT_SUMMARY>
  </ChildGroup>
  <ChildGroup Node1.3 >
        <ACCOUNT_SUMMARY>
        - <Child Node1>1.3.1 </Child Node1>
        - <Child Node2>1.3.2 </Child Node2>
        - <Child Node3>1.3.3 </Child Node3>
        </ACCOUNT_SUMMARY>
        <ACCOUNT_SUMMARY>
        - <Child Node1>1.3.x </Child Node1>
        - <Child Node2>1.3.y </Child Node2>
        - <Child Node3>1.3.z </Child Node3>
        </ACCOUNT_SUMMARY>
  </ChildGroup>
 </ParentGroup> 
 <ParentGroup Node2>    
 <PRIMARY_CUST_DESC>Desc Node1</PRIMARY_CUST_DESC>
  <ChildGroup Node2.1 >
        <ACCOUNT_SUMMARY>
        - <Child Node1>2.1.1 </Child Node1>
        - <Child Node2>2.1.2 </Child Node2>
        - <Child Node3>2.1.3 </Child Node3>
        </ACCOUNT_SUMMARY>
  </ChildGroup>
  <ChildGroup Node1.2 >
        <ACCOUNT_SUMMARY>
        - <Child Node1>2.2.1 </Child Node1>
        - <Child Node2>2.2.2 </Child Node2>
        - <Child Node3>2.2.3 </Child Node3>
        </ACCOUNT_SUMMARY>
  </ChildGroup>
  <ChildGroup Node2.3 >
        <ACCOUNT_SUMMARY>
        - <Child Node1>2.3.1 </Child Node1>
        - <Child Node2>2.3.2 </Child Node2>
        - <Child Node3>2.3.3 </Child Node3>
        </ACCOUNT_SUMMARY>
  </ChildGroup>
 </ParentGroup> 
...........
</Document>


Please Note these constraints:
 - If you see I have only 2 distinct ParentGroups
   <ParentGroup> Node1 </ParentGroup> and
   <ParentGroup> Node2 </ParentGroup>
 - I have two <ChildGroup> Node1.3 </ChildGroup> 
   under <ParentGroup Node1>
   So I have to further sub-group on the ChildGroups


With the 
 <xsl:for-each-group group-starting-with="ParentGroup"

I get all the <ParentGroup> groups (I have 162 in
total)..but then I am not able to further find the
distinct <ParentGroup> (which should be 2)
After that I have to further sub-group on the
ChildGroups


Using preceding-sibling I am able to find the position
and then I can group these correctly
but its taking a hell lot of time to process.

regards,
Bhupendra.







 --- Michael Kay <mike(_at_)saxonica(_dot_)com> wrote: 
Firstly, $p is a node-set, whereas you appear to be
using it in a predicate
as if it were a number. When $p is a node-set,
$seq[$p] will give you all
the nodes in $seq if $p is non-empty, or none of the
nodes in $seq if it is
empty. You almost certainly meant to write
$seq[number($p)].

However, if $var_27[$p] is displaying nothing, then
there must be yet
another bug in your code, because it means that
either $p is empty (in which
case number($p) isn't going to be useful) or $var_27
is empty (in which case
selecting it's $p'th item isn't going to do any
good).

I've found it: you're calling key() with
generate-id() as the second
argument, but the nodes are indexed on the value of
@id. There's no reason
why the generate-id() of a node should match the @id
attribute - you seem to
be confused about its purpose.

As I suggested before, I think you would be better
off explaining the
problem you are trying to solve, because I strongly
suspect the way you are
going about it might be completely wrong.

Michael Kay
http://www.saxonica.com/
 

-----Original Message-----
From: Bhupendra Singh
[mailto:skbhupendra(_at_)yahoo(_dot_)co(_dot_)uk] 
Sent: 16 November 2004 21:08
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: RE: [xsl] Using key and position()

Michael,
My problem is something else.

I am not able to access the variable. So I am
getting
an undefined value for $p

<xsl:variable name="p" select="key('parentGroups',
generate-id())/@pos" />

I think the problem is with the key/variable
definition, which is giving nothing for $p.

Your suggestion below will be useful only if I get
some value of $p.
But currently the <xsl:value-of select="$p"/> is
printing a blank.


<PRI_HEADER><xsl:value-of select="$p"/>
   <xsl:value-of select="$var_27[$p]"/>
</PBU_HEADER>


 --- Michael Kay <mike(_at_)saxonica(_dot_)com> wrote: 
position() returns the position of a node in the
list of nodes that you are
currently iterating over. So

<xsl:variable name="parentGroup">
  <xsl:for-each select="ParentGroup">
    <parentgroup id="generate-id()"
pos="position()"/>
  </xsl:for-each>
</xsl:variable>

will give you values 1,2,3 etc.

You will get what you are looking for by:

<xsl:variable name="parentGroup">
  <xsl:for-each select="*">
    <xsl:if test="self::parentGroup">
       <parentgroup id="generate-id()"
pos="position()"/>
    </xsl:if>
  </xsl:for-each>
</xsl:variable>

However, there might be a much easier way of
doing
what you are trying to
do, if you explained your overall problem rather
than your approach to
solving it.

Michael Kay
http://www.saxonica.com/

-----Original Message-----
From: Bhupendra Singh
[mailto:skbhupendra(_at_)yahoo(_dot_)co(_dot_)uk] 
Sent: 16 November 2004 16:13
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: [xsl] Using key and position()

Hi,
I have an input XML like this:

<action>
        - <ParentGroup> Node1 </ParentGroup>
        - <ChildGroup> Node1.1 </ChildGroup>
        - <Child Node1>1.1.1 </Child Node1>
        - <Child Node2>1.1.2 </Child Node2>
        - <ParentGroup> Node1 </ParentGroup>
        - <ChildGroup> Node1.2 </ChildGroup>
        - <Child Node1>1.2.1 </Child Node1>
        - <Child Node2>1.2.2 </Child Node2>
        - <ParentGroup> Node1 </ParentGroup>
        - <ChildGroup> Node1.3 </ChildGroup>
        - <Child Node1>1.3.1 </Child Node1>
        - <Child Node2>1.3.2 </Child Node2>
        - <ParentGroup> Node1 </ParentGroup>
        - <ChildGroup> Node1.3 </ChildGroup>
        - <Child Node1>1.3.x </Child Node1>
        - <Child Node2>1.3.y </Child Node2>

        - <ParentGroup> Node2 </ParentGroup>
        - <ChildGroup> Node2.1 </ChildGroup>
        - <Child Node1>2.1.1 </Child Node1>
        - <Child Node2>2.1.2 </Child Node2>
        - <ParentGroup> Node2 </ParentGroup>
        - <ChildGroup> Node2.2 </ChildGroup>
        - <Child Node1>2.2.1 </Child Node1>
        - <Child Node2>2.2.2 </Child Node2>
        - <ParentGroup> Node2 </ParentGroup>
        - <ChildGroup> Node2.3 </ChildGroup>
        - <Child Node1>2.3.1 </Child Node1>
        - <Child Node2>2.3.2 </Child Node2>
...........
</action>

I want to capture the position of each of the
<ParentGroup> elements and store it in a
variable
by
going through the document only once. 

<xsl:variable name="parentGroup">
  <xsl:for-each select="ParentGroup">
    <parentgroup id="generate-id()"
pos="position()"/>
  </xsl:for-each>
</xsl:variable>


Then I want to use this variable to get the
position
of each <ParentGroup> and find its
coresponding
<ChildGroup> and <Child Nodes>.

When I print the contents of the variable(@id
and
@pos), then I find that the content is
correct,
but
when I try to retreive the content using key
then
I
get nothing.  Here is the XSL that I have.


<?xml version="1.0" ?>
<xsl:stylesheet

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

<!-- Key to group distinct ChildGroup's -->
<xsl:key name="SEC_CUST" match="ChildGroup"
use="."/>

<!-- Key to group distinct ParentGroup's -->
<xsl:key name="PRI_CUST" match="ParentGroup"
use="."/>

<!-- Key to find position of ParentGroup's -->
<xsl:key name="parentGroups"
match="parentGroup"
use="@id"/>

<xsl:template match="/">
        <xsl:apply-templates/>
</xsl:template>


<xsl:template match="action">

=== message truncated === 

________________________________________________________________________
Yahoo! India Matrimony: Find your life partner online
Go to: http://yahoo.shaadi.com/india-matrimony

--~------------------------------------------------------------------
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>
--~--



<Prev in Thread] Current Thread [Next in Thread>