field Not recognised in Qlikview

[#1]

Hello Guys,

I am confused why it does not work, but when I load the following table from the SQL Databank into Qlikview the category field does not give any fields. I wonder what can be the reason.

SQL Databank view:

Qlikview view:

I tried text(Category) as Category but it does not work. Any Ideas?

Thanks in advance

sravan

[d_pranskus]

Hi

Is there any possibility to send me a database backup? I will try to look at the problem. If not.

Please try different connection., If you use oledb, try odbc, or different oledb provider.

It could be a driver problem.

Cheers, Darius

[#3]

Hi Darius,

It worked in OLEDB connection and previously it was ODBC which did not show the fieldvalues. I wonder what the difference is.

Indeed a different connection helped.

@Tanel Your solution I tried. It gives the Ascii Numbers as 71,82,83

But char(ascii) does not work. May be there is another solution change ascii to character.

But anyway thanks:-)

Thankyou.

[tanelry]

Right, char function may be unavailable via ODBC.
Then you could use QV's chr function instead.

load
Id,
Sequence,
Name,
Description,
GoodProductYN,
chr(CategoryNum) as Category // convert to character
;
SQL SELECT
Id,
Sequence,
Name,
Description,
GoodProductYN,
ascii(Category) as CategoryNum // convert to number
FROM OEE1.dbo."View_Products";

[#5]

Thankyou Roland, Darius and Tanel

Learned a bit from you guys