1 Reply Latest reply: Mar 21, 2013 1:24 PM by Максим Рыбалко RSS

    Direct Discovery show implicit fields values

    Максим Рыбалко



      Is it possible to show implicit field value?


      For example I load table containing fields A and B.

      Буфер обмена-2.jpg


      ODBC CONNECT TO [Test_Excel;DBQ=H:\Direct.xlsx];
      Direct SELECT A
      FROM `H:\Direct.xlsx`.`Лист1$`;


      Field A is a key field, field B is an implicit text field. Then I want create chart: dimension A and expression B, but it does not work - null value is shown.

      Буфер обмена-1.jpg



      If I use count() function it shows correct value.


      In attachment test qvw and excel.