Solved: Loading and storing text containing numbers - Qlik Community

Report Inappropriate Content · ‎2010-07-16

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 · ‎2010-07-16

Try using the following in your load script:

Text(Value) AS Value

nathanfurby · ‎2010-07-16

Try using the following in your load script:

Text(Value) AS Value

Report Inappropriate Content · ‎2010-07-16

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 · ‎2010-07-16

That's exactly what I was suggesting.

Report Inappropriate Content · ‎2010-07-16

Sorry, I misunderstood your reply.

Thanks for your support.

Report Inappropriate Content · ‎2011-01-16

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 ?

Loading and storing text containing numbers