topic ODBC problem in QlikView

ODBC problem

Thu, 16 Dec 2010 18:26:26 GMT

Hi guys, here is the situation:

QV 9.00 SR6

platform/OS - Win7

ODBC used - 32bit - 4D Server

Problem:

I want to select several columns of a database table. With some columns it works fine; others not

Some columns have very long lenghts (text). Because of this (i guess) I cant query the hole table. It would be enough if I select for instance only the first 50 characters of each cell of this problematic column.

Has anybody a solution of this.

Thanks and regards,

Matthias

ODBC problem

pover — Thu, 16 Dec 2010 18:47:34 GMT

There's not much QlikView can do to control what the ODBC returns as data since the ODBC is an independent component.

Maybe this post will help you.

http://community.qlik.com/forums/t/37833.aspx

Regards

ODBC problem

gfarrell — Thu, 16 Dec 2010 19:39:31 GMT

Hi,

Did you try limiting select to the first 50 characters in the sql select? Alot of databases have a 'left' function....like SQL Server. ex: left(column1,50) .

Others like Oracle have a substring function ex: substr(column1,1,50)

ODBC problem

Thu, 16 Dec 2010 21:00:37 GMT

Hello, I will try to limit the characters (tomorrow morning in my office).

In the meantime (by analysing the data) I guess the problem is not the length of the data. It is the special content. There are sometime special signs like ? => in some cells. Maybe it will be able to export the database table via excel or access and delete this special signs. Then I will try it again. If this works, I need a automatically solution.

Thanks in advance

Matthias

ODBC problem

Fri, 17 Dec 2010 17:11:50 GMT

Hello to all,

thanks for your help. I have found a solution. There were a ? in one field, which caused the ODBC-problems.

Case closed

Matthias