Checking an Element Against Multiple Elements

ritagr · May 25th, 2011, 05:37 PM

Hello.

I have an XML file as follows:

Code:

<TRCINFO>
  <RCLINE>
    <RCCODE>ABC1</RCCODE>
  </RCLINE> 
  <RCLINE>
    <RCCODE>ABC2</RCCODE>
  </RCLINE> 
</TRCINFO>

<TRCINFO2>
  <RCLINE>
    <RCCODE>ABC2</RCCODE>
  </RCLINE> 
</TRCINFO2>

I only want to print "ABC2" in TRCINFO2/RCLINE/RCCODE if it's not equal to any TRCINFO/RCLINE/RCCODE values.

I tried the following code but it's not working.
[code]
<xsl:template match="TRCINFO2">
<xsl:if test="RCLINE/RCCODE=TRCINFO/descendant::RCLINE/RCCODE" >

Any suggestions will be greatly appreciated.

Thanks,
Rita

mhkay · May 25th, 2011, 06:46 PM

You seem to be muddled about XPath navigation and context.

Try

Code:

<xsl:if test="not(RCLINE/RCCODE=../TRCINFO/RCLINE/RCCODE)" >

ritagr · May 25th, 2011, 07:17 PM

Thanks Michael for your quick response.
Yes, at this point I'm definitely muddled! I'm relatively new to XSLT.

I tried your code but am still getting "ABC2" printing out.
I need it not to print out from the <TRCINFO2> template because "ABC2" will be printed out when I run the template for the <TRCINFO> element.

That's why I thought using "descendant::" it would find all the
/TRCINFO/RCLINE/RCCODE values (ABC1 and ABC2) so I could compare them to
/TRCINFO2/RCLINE/RCCODE (ABC2) and not print the
/TRCINFO2/RCLINE/RCCODE (ABC2) value since it was found in
/TRCINFO/RCLINE/RCCODE.

Thanks,
Rita

mhkay · May 26th, 2011, 05:33 AM

You need to show a complete stylesheet and a complete source document, plus the output you are getting and the output that you want.

mrame · May 26th, 2011, 10:44 AM

Try the below:

Code:

<xsl:template match="root">
<xsl:apply-templates select="TRCINFO"/>
</xsl:template>
 
<xsl:template match="TRCINFO">
<xsl:variable name="rcccode_1" select="../TRCINFO2/RCLINE/RCCODE"/>
<xsl:if test="RCLINE/RCCODE[. != $rcccode_1]">
<xsl:value-of select="$rcccode_1"/>
</xsl:if>
</xsl:template>

I included a root element <root> to your xml input.

ritagr · May 26th, 2011, 01:34 PM

Thanks Rummy for your suggestion.

Your code works when there's just one TRCINFO/RCLINE/RCCODE.
However, when there are multiple TRCINFO/RCLINE/RCCODE lines, it does not work as it only checks the first occurrence of TRCINFO/RCLINE/RCCODE.

ritagr · May 26th, 2011, 01:54 PM

Hi Michael.

Here's the XML file (I've removed the non pertinent elements).

Code:

<?xml version='1.0'?><!DOCTYPE doc SYSTEM 'xml_med7_dtd_2.0.54.dtd'>
<doc>
    <EOB>
        <VERSION>2.0.54</VERSION>
        <TRCINFO>
            <RCHEADER>FL Reduction Explanations:</RCHEADER>
            <RCLINE>
                <RCCODE>FL 90</RCCODE>
                <RCEXPLANATION>
                    <LINE>Paid: no modification to the information</LINE>
                    <LINE>provided on the medical bill: payment made</LINE>
                    <LINE>pursuant to Florida Workers&apos; Compensation Health</LINE>
                    <LINE>Care Provider Reimbursement Manual.</LINE>
                </RCEXPLANATION>
            </RCLINE>
        </TRCINFO>
        <CRCSTATERCINFO>
            <RCLINE>
                <RCCODE>FL 92</RCCODE>
                <RCEXPLANATION>
                    <LINE>Paid: no modification to the information</LINE>
                    <LINE>provided on the medical bill: payment made</LINE>
                    <LINE>pursuant to Florida Workers&apos; Compensation</LINE>
                    <LINE>Reimbursement Manual for Hospitals.</LINE>
                </RCEXPLANATION>
            </RCLINE>
            <RCLINE>
                <RCCODE>FL 90</RCCODE>
                <RCEXPLANATION>
                    <LINE>Paid: no modification to the information</LINE>
                    <LINE>provided on the medical bill: payment made</LINE>
                    <LINE>pursuant to Florida Workers&apos; Compensation Health</LINE>
                    <LINE>Care Provider Reimbursement Manual.</LINE>
                </RCEXPLANATION>
            </RCLINE>
        </CRCSTATERCINFO>
    </EOB>
</doc>

Here's my XSLT code that processes the <CRCSTATERCINFO> element.
I've included Rummy's suggestion which only works if there is one TRCINFO/RCLINE/RCCODE. I've also left out the table formatting code.

Code:

      <xsl:if test="EOB/CRCSTATERCINFO/RCLINE[descendant::RCEXPLANATION/LINE!='']">
        <fo:block>
          <xsl:apply-templates select="EOB/CRCSTATERCINFO"/>
        </fo:block>
      </xsl:if>

  <xsl:template match="CRCSTATERCINFO">
      <fo:table-body>
        <xsl:for-each select="RCLINE">
          <xsl:variable name="trccodes" select="/doc/EOB/TRCINFO/RCLINE/RCCODE" />
           <xsl:if test="RCCODE[.!=$trccodes]"> 
             <xsl:value-of select="RCCODE"/>

Here's the current output.
FL 90 Paid: no modification to the information etc.
(from TRCINFO/RCLINE/RCEXPLANATION)
FL 92 Paid: no modification to the information etc.
(from CRCSTATERCINFO/RCLINE/RCEXPLANATION)
FL 90 Paid: no modification to the information etc.
(from CRCSTATERCINFO/RCLINE/RCEXPLANATION)

Here's what I need to output.
FL 90 Paid: no modification to the information etc.
(from TRCINFO/RCLINE/RCEXPLANATION)
FL 92 Paid: no modification to the information etc.
(from CRCSTATERCINFO/RCLINE/RCEXPLANATION)

Don't print the second "FL 90" line (from CRCSTATERCINFO/RCLINE/RCEXPLANATION) since it's the same as that from TRCINFO/RCLINE/RCEXPLANATION.

I'm not showing the code to print the TRCINFO/RCLINE/RCEXPLANATION code since it's pretty straight foreward and justs prints whateve is in the RCEXPLANATION lines.

Just a quick note - for the XML info supplied here, my code works but if there are two <TRCINFO> elements and the "FL 90" was in the second one, it does not work!

Thanks for all your help!

Rita

mhkay · May 26th, 2011, 06:50 PM

Don't use [.!=$trccodes], use [not(.=$trccodes)]. The first returns true if $trccodes contains a value that is not equal to "."; the second returns true if $trccodes does not contain a value that is equal to ".". The second is almost invariably what you want.

I haven't checked whether this is the only error in your code.

ritagr · May 26th, 2011, 07:18 PM

Wow! I made the change per your suggestion and it's now working!
Thanks so much for your help.