13 Replies Latest reply: Nov 21, 2017 7:24 AM by Staffan Johansson RSS

    Problem with numbers with SQL select script

    Maxime Golinvaux

      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

      BE001200610061

       

      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:

      Capture.png

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

      Capture2.png

      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:

      Capture3.png

      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.