Problem with load Alphanumeric Field

[jpengiu]

I have wrote this simple script in Qlik

LOAD * INLINE [

Cod, Desc

7E2, Deesc1

700, Desc2

4E2, Desc3

400, Desc4

];

then I create a simple table and when I select the code 7E2 over the column "Cod" the table show 2 row "7E2" and "700".

The same thing with "4E2" and "400".

Qlik trasform the alphanumeric cod 7E2 in 7*10^2 =700 and 4E2=4*10^2=400

Is there a solution?

Thanks

[Miguel_Angel_Baeyens]

Hello,

There is, indeed. You should use TEXT() function when loading a possible numeric value when its text. It won't work with INLINE loads, as functions are not evaluated, but it will when extracting from your datasource

LOAD ... TEXT(Cod) AS Cod ...

Regards.

[#3]

Code sample ;

LOAD TEXT(Cod) AS Cod,Desc;
LOAD * INLINE [
Cod, Desc
7E2, Deesc1
700, Desc2
4E2, Desc3
400, Desc4
];

[jpengiu]

I try an this is the solution also for load data from AS00.....for all

thanks a lot