Graphics

 View Only
Expand all | Collapse all

Referencing an Excel Row via a Column

  • 1.  Referencing an Excel Row via a Column

    Posted 01-29-2024 12:07

    I am currently designing baseball graphics and I am trying to use a jersey number to pull stats from multiple columns from this Table. I have the jersey being pulled automatically from Live Stats, and I am trying to tell DataLinq to look at the jersey number and pull a stat from the same row. I have used similar setups to this when referencing XMLs but cannot get it to work with Excel.



    ------------------------------
    John Spitznagel
    Video Production Engineer
    Elon University
    ------------------------------



  • 2.  RE: Referencing an Excel Row via a Column

    Posted 30 days ago
    Hi John, 
    I am attaching a screenshot of how I have datalinq from Excel set up for my baseball stats. 
    Column = the name of the column exactly how it appears in your spreadsheet.
    Row = 1 (always)
    Table = SELECT [should match the column field above] FROM [name of table your pulling stats from in Excel] WHERE [JERSEY] = this could be your %datlinqkey% or @textobject@ 
    I hope that helps. Let me know if anything is unclear.


    ------------------------------
    Matt Finlayson
    Brigham Young University
    ------------------------------



  • 3.  RE: Referencing an Excel Row via a Column

    Posted 30 days ago

    Matt (or anyone paying attention to this thread),

    May I ask what version of XPression you are using where this works? I am trying to do the exact same thing you have provided a screen grab of, but it is breaking at the @text object@ macro. I have also tried a %datalinqkey% in that same spot with no success. If I type the referenced string in quotes it works fine, however. I am using XPression Designer v10.0 build 5275.

    Thanks for posting,



    ------------------------------
    J.R. Schulz
    Real-Time Graphics Developer
    The E.W. Scripps Company
    ------------------------------



  • 4.  RE: Referencing an Excel Row via a Column

    Ross Staff
    Posted 30 days ago

    macros and datalinqkeys work in v10. 



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 5.  RE: Referencing an Excel Row via a Column

    Posted 30 days ago

    I am on version 11.5, but I believe I first started using this at version 10 or 10.5. 

    I should've mentioned that "WHERE [JERSEY] =" section is referencing the column name of the player number. In my case, the Excel column is called "JERSEY". Yours may be different.



    ------------------------------
    Matt Finlayson
    Brigham Young University
    ------------------------------



  • 6.  RE: Referencing an Excel Row via a Column

    Ross Staff
    Posted 30 days ago

    You should also consider your jersey number may be a string, not an integer so it needs to be in quotes. 



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 7.  RE: Referencing an Excel Row via a Column

    Posted 30 days ago

    Thanks, Simon. The field I'm trying to access with a macro is also a string. Where would the quotes you've mentioned go in this scenario (in my 'Non-Working' example below, where @Area@ should yield the same result as 'United States')?

    Not working:

    Working:



    ------------------------------
    J.R. Schulz
    Real-Time Graphics Developer
    The E.W. Scripps Company
    ------------------------------



  • 8.  RE: Referencing an Excel Row via a Column

    Ross Staff
    Posted 30 days ago

    "@Area@"



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------



  • 9.  RE: Referencing an Excel Row via a Column

    Posted 30 days ago

    Try putting Name in brackets.

    SELECT [Name] FROM [blade_election...



    ------------------------------
    Matt Finlayson
    Brigham Young University
    ------------------------------



  • 10.  RE: Referencing an Excel Row via a Column

    Posted 29 days ago

    Thanks Matt! This worked perfectly. Appreciate the help!



    ------------------------------
    John Spitznagel
    Video Production Engineer
    Elon University
    ------------------------------



  • 11.  RE: Referencing an Excel Row via a Column

    Posted 29 days ago

    I am now in good shape as well! Appreciate the help, fellas. Adding the quotation marks plus assigning the Name column to an additional Text Object seems to have done the trick. Hitting the browse button still makes it look like it's not working (that was throwing me off) but it is now passing the correct fields to the assigned column text object when I'm in sequencer mode. Thanks again. I'm a longtime Vizrt user and have really enjoyed my transition to XPression, btw.



    ------------------------------
    J.R. Schulz
    Real-Time Graphics Developer
    The E.W. Scripps Company
    ------------------------------



  • 12.  RE: Referencing an Excel Row via a Column

    Posted 29 days ago

    Okay, so now I have it working without the additional text object. I think it was really just the quotation marks that were necessary for this to work. I'm also able to add more statements to the query with great success. Thanks again!



    ------------------------------
    J.R. Schulz
    Real-Time Graphics Developer
    The E.W. Scripps Company
    ------------------------------



  • 13.  RE: Referencing an Excel Row via a Column

    Ross Staff
    Posted 29 days ago

    no problem :)



    ------------------------------
    Simon Redmile
    Senior Graphic Programmer & Designer
    Ross Video
    Bristol United Kingdom
    ------------------------------