Problem with numbers with SQL select script

[mgolinvaux]

Hello, I encounter a problem when I load data from an Oracle table with Qlikview.

The source table contains a column with an ID and an other with a part of this ID (last four numbers or more).

Example:

ID	LastNumbers
BE00120061	0061

When i load this table, i use this script:

Table:

SQL SELECT *

FROM "DB".TABLE;

store Table into TABLE.qvd(qvd);

The problem is, some data from the "LastNumbers" column are not loaded correctly when the number start with "0", like this:

The LastNumbers "62" should be "0062" like in source table:

That's really strange and totally illogic i think.

When i load only the line with ID "BE00120062"  whith a "WHERE" clause, the number is loaded correctly:

I tried to force the text format with text() function but that's not working...

This script have been tested with Qv 11.20 SR15 and QV12, the result is exactly the same.

I think there is a bug here...

Can someone helps?

Thank you.

[mgolinvaux]

Hello,

Unfortunately, the WORK_ID is not always a 4 digit number, sometimes it's more.

Regards.

[mgolinvaux]

Hello,

That's exactly the problem!

Some data in my source table contains "62".

I will solve this in the source table and the script should be working fine.

I just need to wait tomorrow because the source table is reloaded one time a day.

Regards.

[mgolinvaux]

Hello,

I can tell now that was exactly the problem. After suppressing the values with "62", my script works fine and load the lines with "0062" without problem.

Thanks!

[stabben23]

Great, QlikView is sometimes to smart for it self