Direct Discovery show implicit fields values

[mrybalko]

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.

[mrybalko]

Is is possible, but you should use any aggregation function which supports by odbc driver.

In above case work min() and max() functions.