I have a table with columns defined in oracle as varchar2(4000). When I do a simple load of this column it shows as null in the list box or table chart.
Any help please.
Can you show two different images which are they Oracle and QlikView to look? Varchar2() indicates Number + Text format in DB.
I am not facing any issue while loading from external DB(I have Postgresql). I believe if one DB source working as expected it should work in Other DB's too
DB Image Attached. Not sure, What if you used Trim(FieldName) as Fieldname in Qlikview?
I am surprised as well. not sure why is it happening.
Okay, third one won't help because we are picking the same inputs if we have Oracle then will try but not having. And, Can you try different data source from your end and check if it is still there..
May be try any one of these
Trim(Field) as Field
Floor(Field) as Field
Ceil(Field) as Field
Text(Field) as Field
Num, Num# etc..
I assume that rather the database-driver couldn't handle this varchar2(4000) and if I look on your data-example - just numbers - it doesn't look really suitable. I think I would try to convert these values with cast or to-number on the sql-level into a double fieldtype or something similar if the values are not mandatory numbers.