Get field to a spreadsheet

 
1
0
-1

A Query is made in load binder of a spreadsheet and produce a MARK, for example 87.

I have a defined table :

How should i do in a spreadsheet to produce value GRADE A- and VALUE 3,7 from MARK 87 (between 85 - 89).

Thank you ..

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi there,

      Assuming your query is something like this :

      SELECT c_grade, c_value from tablename...

      simply insert the query column name without the prefix "c_" into the spreadsheet properties under Edit Spreadsheet > Columns > Value

       

      1. Kurt Cobain

        I'm sorry, It's not working like that, because I've tested, maybe your image is not full :(

      CommentAdd your comment...