logo

Live Production Software Forums

www.vmix.com

Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Xpath question - combining datasets
Options
Go to last post Go to first unread
Previous Topic Next Topic
rgdts  
#1 Posted : Tuesday, March 25, 2025 8:07:30 AM(UTC)
rgdts

Rank: Newbie

Groups: Registered
Joined: 3/25/2025(UTC)
Posts: 1
Hey everybody, I'm wondering if there is any way using xpath to combine these two sets of data into one row using the unique identifier of playerlinkid?

xpath = //battinglineup | //battingstats gives two separate rows as follows:
Johnny Rocket 3 1234567 2B 1 0 1
Rocket, J 1234567 2B 4 1 0 0 0 1 1 0 .259

Pretty new to xpath, hoping to be able to get this to keep my workflow more simple. Any help is much appreciated, or for somebody to tell me it's not possible!

Code:
<?xml version="1.0" encoding="UTF-8"?>
<boxscore scoringtype="SA">
  <battinglineup>
    <home>
      <player>
        <name>Johnny Rocket</name>
        <jersey>3</jersey>
        <playerlinkid>1234567</playerlinkid>
        <position>2B</position>
        <order>1</order>
        <suborder>0</suborder>
        <ingame>1</ingame>
      </player>
    </home>
  </battinglineup>
  <battingstats>
    <home>
      <player>
        <name>Rocket, J</name>
        <jersey/>
        <playerlinkid>1234567</playerlinkid>
        <position>2B</position>
        <ab>4</ab>
        <runs>1</runs>
        <hits>0</hits>
        <hr>0</hr>
        <rbi>0</rbi>
        <bb>1</bb>
        <so>1</so>
        <sb>0</sb>
        <avg>.259</avg>
      </player>
	 </home>
  </battingstats>
</boxscore>
Back to top

Wanna join the discussion?! Login to your vMix Forums forum account, or Register a new forum account.
Back to top  
doggy  
#2 Posted : Tuesday, March 25, 2025 3:24:45 PM(UTC)
doggy

Rank: Advanced Member

Groups: Registered
Joined: 12/27/2012(UTC)
Posts: 5,361
Belgium
Location: Belgium

Thanks: 300 times
Was thanked: 989 time(s) in 821 post(s)
Originally Posted by: rgdts Go to Quoted Post
Hey everybody, I'm wondering if there is any way using xpath to combine these two sets of data into one row using the unique identifier of playerlinkid?

xpath = //battinglineup | //battingstats gives two separate rows as follows:
Johnny Rocket 3 1234567 2B 1 0 1
Rocket, J 1234567 2B 4 1 0 0 0 1 1 0 .259

Pretty new to xpath, hoping to be able to get this to keep my workflow more simple. Any help is much appreciated, or for somebody to tell me it's not possible!



Sure, based on the detailed information given regarding the goal and setup i would say use a script read both rows, stick them together and save them to another datasource file like a CSV for example.
Back to top
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET | YAF.NET © 2003-2025, Yet Another Forum.NET
This page was generated in 0.151 seconds.