Hi Everyone,
I have a preceding-sibling if statement that is always evaluating true. I think it is getting stuck inside a nested node, and not searching the whole document. I am trying to avoid printing out rows with the same part number. My XML is below...


<Node Name="DCM Buhler">
<Shift Name="Night Shift">
    <DataType Name="Counters">
        <Identifier Name="Part Number" Value="772100">
            <Identifier Name="Die/Cavity" Value="#23">
                <Variable Name="DC Shot Counter">data</Variable>
                <Variable Name="DC Parts Cast">data</Variable>
                <Variable Name="DC Parts Scrapped Auto">data</Variable>
            </Identifier>
        </Identifier>
        <Identifier Name="Part Number" Value="721115">
            <Identifier Name="Die/Cavity">
                <Variable Name="DC Shot Counter">data</Variable>
                <Variable Name="DC Parts Cast">data</Variable>
                <Variable Name="DC Parts Scrapped Auto">data</Variable>
            </Identifier>
        </Identifier>
    </DataType>
</Shift>
<Shift Name="Morning Shift">
    <DataType Name="Counters">
        <Identifier Name="Part Number" Value="772100">
            <Identifier Name="Die/Cavity" Value="#23">
                <Variable Name="DC Shot Counter" Type="1" Unit="cts">data</Variable>
                    <Variable Name="DC Parts Cast">data</Variable>
                    <Variable Name="DC Parts Scrapped Auto">data</Variable>
                </Identifier>
            </Identifier>
            <Identifier Name="Part Number" Value="721115">
                <Identifier Name="Die/Cavity" Value="14" PartsPerShot="1" Duration="1378">
                    <Variable Name="DC Shot Counter">data</Variable>
                    <Variable Name="DC Parts Cast">data</Variable>
                    <Variable Name="DC Parts Scrapped Auto">data</Variable>
                </Identifier>
            </Identifier>
        </DataType>
    </Shift>
etc...


The XSL I'm using is as follows...

<xsl:for-each select="//Node">
    <xsl:variable name="Cell" select="@Name"/>
    <xsl:for-each select="//Node[@Name=$Cell]/Shift/DataType[@Name='Counters']/Identifier[@Name = 'Part Number' and ./Identifier/Variable/VRD[@Value != '' and @Value != '0']]">

        <xsl:sort data-type="text" select="@Value"/>
        <xsl:variable name="PartNo" select="@Value"/>

        <xsl:if test="not(preceding-sibling::node()/@Value = $PartNo)">

            <xsl:for-each select="Identifier[@Name = 'Die/Cavity' and ./Variable/VRD[@Value != '' and @Value != '0']]">
                <xsl:variable name="DieCavity" select="@Value"/>
                <xsl:variable name="PartsCast" select="sum(//Node[@Name=$Cell]/Shift/DataType[@Name='Counters']/Identifier[@Name='Part Number' and @Value=$PartNo]/Identifier[@Name='Die/Cavity' and @Value=$DieCavity]/Variable[@Name = 'DC Parts Cast']/VRD[@Value != '']/@Value)"/>
                <xsl:variable name="PartsScrapped" select="sum(//Node[@Name=$Cell]/Shift/DataType[@Name='Counters']/Identifier[@Name='Part Number' and @Value=$PartNo]/Identifier[@Name='Die/Cavity' and @Value=$DieCavity]//Variable[@Name = 'DC Parts Scrapped Auto' or @Name = 'DC Parts Scrapped Operator']/VRD[@Value != '']/@Value)"/>
                <xsl:variable name="PotentialCast" select="(ancestor::node()/@GPURate) * (ancestor-or-self::node()/@Duration) div 60"/>

                <!-- CREATE TABLE HERE.../>

            </xsl:for-each>
        </xsl:if>
    </xsl:for-each>
</xsl:for-each>

As you can probably tell by my code, I'm pretty new to this stuff.

Anybody have any ideas? I have been stumped for hours now!

Thanks a lot!





Andrew

Too late on a Friday for an in depth look I'm afraid. However you may find Muenchian Grouping will help here.

--

Joe (Microsoft MVP - XML)

<xsl:if test="not(preceding-sibling::node()/@Value = $PartNo)">
This only tests if the directly preceding sibling (one node) does not have the same part number.

What you want could be:
<xsl:if test="not(preceding-sibling::*[@Value = $PartNo])">
Test if any of the preceding-siblings have the same value..
WARNING!: This only tests nodes within the same Dataype. Did you want to test all nodes, eg have the Night Shift match up with the morning shift?
yeah, I think Muenchian grouping would make it easier too.

---
what are you going for as a final result? seems a lot of your x-path's could use simplifying, eg. "./" is always redundant.

This is WRONG!

 <xsl:if test="not(preceding-sibling::node()/@Value = $PartNo)">
This only tests if the directly preceding sibling (one node) does not have the same part number.

What you want could be:
<xsl:if test="not(preceding-sibling::*[@Value = $PartNo])">
Test if any of the preceding-siblings have the same value..

The first example tests all preceding-sibling nodes (all nodes with the same parent, that precede the context node). The second example only tests preceding-sibling element nodes.

Michael Kay

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

In this:

<xsl:for-each select="//Node[@Name=$Cell]/Shift/DataType[@Name='Counters']/Identifier[@Name = 'Part Number' and ./Identifier/Variable/VRD[@Value != '' and @Value != '0']]">

You will get an empty node-set if there are no VRD elements in your data. I don't see any VRD elements in your data.



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

Thanks for all your help guys. Is there a way to do it that will find all of the identical Part No.'s regardless of DataType and Shift? All I'm interested in is duplicate Part No.'s under the "Cell" Node.

P.S. Michael, I have VRD's in my real data, I just didn't include them here. Sorry for the confusion!

Andrew

So let me see if I'm summarizing this right:
XPath of grouping field: "/Node/Shift/DataType[@Name='Counters']/Identifier[@Name = 'Part Number']/@Value"
Restrictions: Identifier has Variable/VRD/@Value with non-zero, non-empty value.
Grouping by: Identifiers? first level?

So placing these into a key:
<xsl:key name="part-by-value" match="Identifier" use="@Value" />
selecting each group:
<xsl:for-each select="/Node/Shift/DataType[@Name='Counters']/Identifier[@Name = 'Part Number' and Identifier/Variable/VRD[@Value != '' and @Value != '0']][count(.|key('part-by-value',@Value)[1])=1]">

now within that group did you want to select all of the nodes with the same value, or just the first one?
Selecting each node with the same value:
<xsl:for-each select="key('part-by-value',@Value)">

WARNING: since you have Identifier's inside Identifier's, you may run into conflicts if any of the values of the inside identifiers has the same value as an outside identifiers value. What key('part-by-value' @Value) does, is selects all Identfier nodes with the same Value, regardless of level.