Loading and storing text containing numbers

[#1]

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 · Accepted solution]

Try using the following in your load script:

Text(Value) AS Value

[#3]

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]

That's exactly what I was suggesting.

[#5]

Sorry, I misunderstood your reply.

Thanks for your support.

[#6]

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 ?