Graphics

 View Only

  • 1.  Search huge csv Datalinq values through Keys

    Posted 04-03-2018 18:18
    Dear support team

    What would be the simplest way to receive the values of a specific team number (out of around 3000) that is listed in a csv file?

    I want to be able to input in Dashboard the number of the team - let's say team number 483 which actually is on place/column 36 at the moment - and get the output of that specific column.

    My attempt was to loop through the values with keys (for 1 to 4000...) and then exit the loop when the Team-Number matches the input value. I belive this is too intense on the machine because it has to refresh the datalinq values for each time it loops again.

    A solution with dashboard doing the magic would be great as well.

    I'd be very thankful for a quick answer. Thank you guys in advance and kind regards

    Remo


  • 2.  RE: Search huge csv Datalinq values through Keys

    Posted 04-03-2018 18:33
    Can you provide the data as XML instead? Datalinq would be able to query for a record with a specific team number and return those particular results.

    #XPression


  • 3.  RE: Search huge csv Datalinq values through Keys

    Posted 04-03-2018 19:57
    Is there maybe a possibility with an XPression script?
    #XPression