Graphics

I'm trying to figure out how to pull the starters for a tombstone slab from live stats.  I can't figure out how to do the datalinq query either with a straight XML source or event importing the players into an excel file. I see the column for "oncourt" and it's a Y or N.  I can get our SID's to text me the player number & I can get names from the XML using team<vh=%V-OR-H%>\player<uni=@STARTER_UNI_3@> in my datalinq column, but would love to automate this process where the 1st name pulls the 1st instance of oncourt=Y, 2nd name skips any oncourt=N and pulls the next oncourt=Y, and so on until the 5th name is populated. I feel like I'm missing something simple. Any advice?

Here's what a player's XML looks like

<player uni="32" code="32" name="Moore, Katie" checkname="MOORE,KATIE" class="FR" gp="1" gs="0" oncourt="Y">
      <stats fgm="0" fga="1" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="1" min="5" sec="+" oreb="1" dreb="0" treb="1" pf="1" tf="0" to="0" dq="0" fgpct="0" fg3pct="0" ftpct="0">
      </stats>
      <statsbyprd prd="1" fgm="0" fga="0" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="0" min="0" oreb="0" dreb="0" treb="0" pf="0" tf="0" to="0" dq="0">
      </statsbyprd>
      <statsbyprd prd="2" fgm="0" fga="0" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="0" min="0" oreb="0" dreb="0" treb="0" pf="0" tf="0" to="0" dq="0">
      </statsbyprd>
      <statsbyprd prd="3" fgm="0" fga="0" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="0" min="1" sec="+" oreb="0" dreb="0" treb="0" pf="1" tf="0" to="0" dq="0">
      </statsbyprd>
      <statsbyprd prd="4" fgm="0" fga="1" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="1" min="4" sec="-" oreb="1" dreb="0" treb="1" pf="0" tf="0" to="0" dq="0">
      </statsbyprd>
    </player>

Thanks!

Jay,

A DataLinq comparison key such as <club=ross> can have an additional index parameter such as <club=ross<2>>, which will retrieve the second item matching the key.

So in this case you should be able to pull the first Visitor or Home player on court with a <vh=%V-OR-H%>\player<oncourt=Y>, then the next with <vh=%V-OR-H%>\player<oncourt=Y<2>>, etc.

I'm trying to figure out how to pull the starters for a tombstone slab from live stats.  I can't figure out how to do the datalinq query either with a straight XML source or event importing the players into an excel file. I see the column for "oncourt" and it's a Y or N.  I can get our SID's to text me the player number & I can get names from the XML using team<vh=%V-OR-H%>\player<uni=@STARTER_UNI_3@> in my datalinq column, but would love to automate this process where the 1st name pulls the 1st instance of oncourt=Y, 2nd name skips any oncourt=N and pulls the next oncourt=Y, and so on until the 5th name is populated. I feel like I'm missing something simple. Any advice?

Here's what a player's XML looks like

<player uni="32" code="32" name="Moore, Katie" checkname="MOORE,KATIE" class="FR" gp="1" gs="0" oncourt="Y">
      <stats fgm="0" fga="1" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="1" min="5" sec="+" oreb="1" dreb="0" treb="1" pf="1" tf="0" to="0" dq="0" fgpct="0" fg3pct="0" ftpct="0">
      </stats>
      <statsbyprd prd="1" fgm="0" fga="0" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="0" min="0" oreb="0" dreb="0" treb="0" pf="0" tf="0" to="0" dq="0">
      </statsbyprd>
      <statsbyprd prd="2" fgm="0" fga="0" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="0" min="0" oreb="0" dreb="0" treb="0" pf="0" tf="0" to="0" dq="0">
      </statsbyprd>
      <statsbyprd prd="3" fgm="0" fga="0" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="0" min="1" sec="+" oreb="0" dreb="0" treb="0" pf="1" tf="0" to="0" dq="0">
      </statsbyprd>
      <statsbyprd prd="4" fgm="0" fga="1" fgm3="0" fga3="0" ftm="0" fta="0" tp="0" blk="0" stl="0" ast="1" min="4" sec="-" oreb="1" dreb="0" treb="1" pf="0" tf="0" to="0" dq="0">
      </statsbyprd>
    </player>

Thanks!