Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Is it possible to show implicit field value?
For example I load table containing fields A and B.
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.
If I use count() function it shows correct value.
In attachment test qvw and excel.
Is is possible, but you should use any aggregation function which supports by odbc driver.
In above case work min() and max() functions.