Graphics

 View Only
  • 1.  Datlinq Keys and DakStats Baseball Datalinq Info

    Posted 03-21-2017 18:31

    Hi,
    So I work for a Minor League Baseball team that uses DakStats Baseball as our source for stat info inside of Xpression and I was wondering if there is any way for datalinq keys to tell the difference between two different versions of the same string. We use the datalinq key %Jersey% to parse a data field based off of Jersey number but the way DakStats baseball presents its data, as two separate entries for game/season, as marked in the second column ##G or ##S, it doesn't allow us to correctly parse each field because the datalinq key isn't able to tell the difference between 10G or 10S when entered in. Is there a way to fix this so that we can take only the fields labeled ##S instead of ##G that would still allow for the info to be based off of the Jersey Numbers?

    Thanks



  • 2.  RE: Datlinq Keys and DakStats Baseball Datalinq Info

    Posted 03-24-2017 20:25
    maybe you could use a query. This is how you would do it in Excel,

    So Set up DL, use whatever stat you need [STAT] for the Column and Row as 1. For table, write

    SELECT [STAT] FROM [HPlayerGmSn] WHERE [noID] = "%DataLinq Key%"

    now, whatever you type in the key will be searched in the noID column. So you can type 10s or 10g depending what you need.
    #XPression