topic Loading and storing text containing numbers in QlikView

Loading and storing text containing numbers

Fri, 16 Jul 2010 13:37:03 GMT

When I load a text field containing numbers from a Database (IBM DB2), I get a single numeric value when the trimmed values are similar.

eg: 001, 01 and 1 are all represented as 1.

The same problem arises when I store those fields in a qvd file.

Regards

nathanfurby — Fri, 16 Jul 2010 13:46:19 GMT

Try using the following in your load script:

Text(Value) AS Value

Fri, 16 Jul 2010 15:36:44 GMT

Using Text(Value) AS Value is the right way, but is not enough.

Since I'm running the initial query against an ODBC source, I cant pass the TEXT() function to the DB2 Database, but I solved the problem this way.

Table:

LOAD

TEXT(Field) AS Field;

SQL SELECT

Field

FROM ORIGINALTABLE;

Thanks for your support

nathanfurby — Fri, 16 Jul 2010 15:41:37 GMT

That's exactly what I was suggesting.

Fri, 16 Jul 2010 16:03:00 GMT

Sorry, I misunderstood your reply.

Thanks for your support.

Sun, 16 Jan 2011 14:41:19 GMT

I had the same issue and this resolved it. Thanks.

Essentially, QV is ignoring the datatype from the database which is pretty confusing. Why would this not be considered a bug ?