Hello, I'm new with XSLT and I got assigned to do an xslt spreadsheet at work but I got stuck in this point:
XML:
Code:
  <Intro BillingCycles="12 Billing Cycles"
  FlipDate="None"
  Tier="1">
    Purchase=0.00:F
    BT=0.00:F
    CC=0.00:F
    BillingCycles=12 Billing Cycles
    FlipDate=None
    <Purchase APR="0.00" />
    <BT APR="0.00" />
  </Intro>

  <Intro BillingCycles="12 Billing Cycles"
  FlipDate="None"
  Tier="2">
    Purchase=0.00:F
    BT=0.00:F
    CC=0.00:F
    BillingCycles=12 Billing Cycles
    FlipDate=None
    <Purchase APR="0.00" />
    <BT APR="0.00" />
  </Intro>
  <Intro BillingCycles="12 Billing Cycles"
  FlipDate="None"
  Tier="3">
    Purchase=0.00:F
    BT=0.00:F
    CC=0.00:F
    BillingCycles=12 Billing Cycles
    FlipDate=None
    <Purchase APR="0.00" />
    <BT APR="0.00" />
  </Intro>


<Goto BillingCycles="None"
  FlipDate="None"
  Tier="1">
    Purchase=14.24:V
    BT=14.24:V
    CC=14.24:V
    BillingCycles=None
    FlipDate=None
    <Purchase APR="14.24" />
    <BT APR="14.24" />
  </Goto>

<Goto BillingCycles="None"
  FlipDate="None"
  Tier="2">
    Purchase=14.24:V
    BT=14.24:V
    CC=14.24:V
    BillingCycles=None
    FlipDate=None
    <Purchase APR="14.24" />
    <BT APR="14.24" />
  </Goto>
<Goto BillingCycles="None"
  FlipDate="None"
  Tier="3">
    Purchase=14.24:V
    BT=14.24:V
    CC=14.24:V
    BillingCycles=None
    FlipDate=None
    <Purchase APR="14.24" />
    <BT APR="14.24" />
  </Goto>


I have to select the Intro/@Tier that applies with:
IF<INTRO;PURCHASE;APR> != “None” or is NOT equal to <GOTO;PURCHASE;APR> but from the same Tier.
Example <INTRO[@Tier = 1];PURCHASE;APR> != "None" and <GOTO[@Tier = 1];PURCHASE;APR>

This is what I got so far:
Code:
<xsl:variable name="IntroTiers" select="Intro[@Tier = * and Purchase/@APR!='None' and not(Purchase/@APR != /Goto[@Tier = *]/Purchase/@APR) ]/@Tier" />

This select doesn't work because the second * is selecting "any Tier" and not the same Tier that the first * . I can not think of a way to compare different nodes from the same Tier.
BTW, I can't change the XML, I have to work with that one :(

Sorry for my english.

Thanks


Report this post

I'm afraid I don't understand the notation that you are using to express your requirement, that is: IF<INTRO;PURCHASE;APR> != “None” or is NOT equal to <GOTO;PURCHASE;APR>.

I don't know what you're trying to achieve with

Intro[@Tier = *]

what this actually means is "select all the Intro elements whose @Tier attribute is equal to one of their child elements".

This clause also looks wrong:

not(Purchase/@APR != /Goto[@Tier = *]/Purchase/@APR)

/Goto will select a Goto element at the top level of the document. You haven't shown the top level of your document, but somehow I doubt it is a Goto element.

I suspect you're trying to construct a join query using "*" as a range variable. Joins are quite hard (sometimes impossible) in a single XPath 1.0 expression. You probably need to move up to the XSLT level:

<xsl:variable name="top" select="."/>
  <xsl:for-each select="Intro">
    <xsl:variable name="Tier" select="@Tier"/>
    <xsl:for-each select="$top/Goto">
      <xsl:if test="@Tier != $Tier">...





Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thank you for replying.
I came up with a pretty long logic that works:



It's not a generic logic because I couldn't figure out how to do it but this one worked just fine.

Anyway, thanks.

Not nice. You didn't say whether you're using XPath 1.0 or 2.0. In 2.0 you can reduce this a bit, something like this if I understand it right:

<xsl:variable name="IntroTiers" select="
Intro[some $t in 1 to 4 satisfies (@Tier = $t and Purchase/@APR!='None' and BT/@APR!='None' and Purchase/@APR != /CCAP/Goto[@Tier = $t]/Purchase/@APR and BT/@APR != /CCAP/Goto[@Tier = $t]/BT/@APR and not(*/@APR = preceding-sibling::Intro/*/@APR))]/@Tier " />

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Here we use XPath 1.0