Qlik Sense Enterprise on Windows: Possible text misinterpretation

[Albert1177]

Hello, as I'm developing an app which loads data via load * inline statement, I got an unexpected behavior from Qlik Sense (May 2024 SR6):

In my DLE I have the following code:

MyTable:

load * inline [
id_product, cod_product, value
27447, 1330600, 50000
697586, 13306E2, 10400
];

Loading data show no errors. I would expect the cod_product to be interpreted as text given the value '13306E2' in the second line. However, when I create a table and add those 3 fields, the cod_product shows strange values, i.e. 1330600 for all rows (see the picture):

In the data model viewer preview the same issue, and the tag is $numeric integer.
It looks like QS does not recognize the cod_product field data type value and assuming it is a number, it changes the value of id_product 27447 to 1330600 instead of 13306E2. 
As a troubleshoot step, I have enclosed cod_product values into single or double quotes, with no success, still 1330600. 
Any hints on how to mitigate that? 
This applies to Qlik Sense Cloud also, I should be missing some steps.
Hint1: casting did not help either
Hint2: same happens when you load data via SQL from an ODBC connection. 

[seanbruton]

Hi,

To overcome this try

text(cod_product) as cod_product 

Regards

[Albert1177]

Hi, that didn't help. 
I believe that is due to how the QV/QS Engine stores data values. More on this:
https://community.qlik.com/t5/Official-Support-Articles/How-Is-Data-Stored-In-Qlik-Sense-And-QlikVie...