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

    Direct Discovery show implicit fields values

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

      Hello

       

      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:
      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.