Select Different Element Value as Same Position as First Value

ritagr · June 28th, 2016, 11:24 AM

Hello.

I have an XML file with the following <PRESCRIBINGPROVIDER> tag that occurs
within each <DETAILLINE>. I need to find the first occurrence of the
<PRESCRIBINGPROVIDER><FULLNAME> along with it's matching <NATIONALPROVIDERID>.

The problem is that for example, the first occurrence of <PRESCRIBINGPROVIDER> may have a value but it's <NATIONALPROVIDERID> may be blank.

The second occurrence may have a value for both tags.

It's OK to pick up the first occurrence of <PRESCRIBINGPROVIDER> but I need to pick up the same position() value for the <NATIONALPROVIDERID>, even if its empty.

The code I'm using picks up the first occurrence of <NATIONALPROVIDERID> but then the first occurrence of <NATIONALPROVIDERID> that is not blank from the second occurrence of <PRESCRIBINGPROVIDER>.

Code:

<xsl:variable name="varPrescriberName">
  <xsl:value-of select="/doc/EOB/DETAIL/DETAILLINE/PRESCRIBINGPROVIDER[FULLNAME!='']/FULLNAME"/>
</xsl:variable>
<xsl:variable name="varPrescriberNPI">
  <xsl:value-of select="/doc/EOB/DETAIL/DETAILLINE/PRESCRIBINGPROVIDER/NPIINFO[NATIONALPROVIDERID!='']/NATIONALPROVIDERID"/>
</xsl:variable>

Here's an example showing two occurrences of <PRESCRIBINGPROVIDER>.

Code:

<PRESCRIBINGPROVIDER>
  <FULLNAME>FULLNAME LINE 1</FULLNAME>
  <NPIINFO>
    <NATIONALPROVIDERID></NATIONALPROVIDERID>
    <QUALIFIER></QUALIFIER>
  </NPIINFO>
</PRESCRIBINGPROVIDER>
<PRESCRIBINGPROVIDER>
  <FULLNAME>FULLNAME LINE 2</FULLNAME>
  <NPIINFO>
    <NATIONALPROVIDERID>NPI LINE 2</NATIONALPROVIDERID>
    <QUALIFIER></QUALIFIER>
  </NPIINFO>
</PRESCRIBINGPROVIDER>

I need to be able to pick up <NATIONALPROVIDERID> from position(1) instead of position(2).

I've played around with the position function but have not been able to achieve what I need.

Any help will be greatly appreciated!
Rita

mhkay · June 28th, 2016, 12:05 PM

I'm sorry, Rita, I don't understand what it is that you are trying to achieve. Please provide specimen input and output and explain how they are related. If you want to know why your code is wrong, then please supply your complete code, not a vague description of it.

The most common mistakes with position() are (a) to assume that it gives you the position of a node among its siblings, rather than its position among the nodes selected for processing, and (b) to use it in a context (e.g. a predicate) that sets a new position.

ritagr · June 28th, 2016, 12:40 PM

Thanks Michael for your response. In my XML example, I inadvertently had a value in position(1) for <NATIONALPROVIDERID>. I've since updated it to have spaces.

So, position (1) of PRESCRIBINGPROVIDER/FULLNAME is "FULLNAME LINE 1" and position (1) of PRESCRIBINGPROVIDER/NPIINFO/NATIONALPROVIDERID> is blank.

position (2) <FULLNAME> is "FULLNAME LINE 2" and position (2) <NATIONALPROVIDERID> is "NPI LINE 2".

I need to pick up the first <FULLNAME> value that is not blank along with it's associated <NATIONALPROVIDERID>.

In my XML example that would translate to FULLNAME of "FULLNAME LINE 1" and
NATIONALPROVIDERID blank.

Using my code, however, I get FULLNAME value "FULLNAME LINE 1" and NATIONALPROVIDERID value "NPI LINE 2".

Hope this helps!

Thanks, Rita

ritagr · June 28th, 2016, 01:59 PM

I'm unable to attach files.

This is what I see under my posting rules:
You may post new threads
You may post replies
You may not post attachments
You may edit your posts

I went to edit my profile but could not see where to change the posting attachments.

mhkay · June 28th, 2016, 02:01 PM

I asked you to show your required output, and/or your code. You haven't done either.

ritagr · June 28th, 2016, 02:20 PM

I'm unable to attache files - I don't have permission to do this. I'm currently "chatting" with Wiley to help me regarding this.

I have the two files ready to attach. They are rather large but I can email them to you if you prefer.

samjudson · June 28th, 2016, 04:57 PM

Wouldn't the following give you what you want?

Code:

/doc/EOB/DETAIL/DETAILLINE/PRESCRIBINGPROVIDER[FULLNAME!='']/NPIINFO/NATIONALPROVIDERID

ritagr · June 28th, 2016, 05:20 PM

Thank you so much! That worked perfectly!!
So appreciate your help.