qlikview loads the columns as null

[#1]

Hi All

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.

• Qlikview Table viewer also fails to recognize the column values and displays just null
• Tried num, num# and text and a combination of these but nothing helped

Any help please.

Regards

Prashant

[Peter_Cammaert]

Try using ...TO_CHAR(COL1) "COL1_CHAR"... in your SQL SELECT statement, before sending the data through ODBC to QlikView.

[#3]

I tried to_char and it did not work. Also tried to_number but no success.

[marcus_sommer]

I would check directly in the database how the content of these fields look like and if they could be transformed. I mean to use a query with len(), isnum(), istext() and similar checks and also several transformations with cast(), to_char(), to_number() and similar to look if it worked there.

A following step might be to create a table-dump with this kind of query and then to pull this dump into qlikview.

Beside this I would try to pull various tables/fields (only a few records) into qlik to see if there are other salience with NULL's, wrong formattings and/or values.

- Marcus