topic Problem with load Alphanumeric Field in QlikView

Problem with load Alphanumeric Field

jpengiu — Mon, 08 Mar 2010 11:38:36 GMT

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

Problem with load Alphanumeric Field

Miguel_Angel_Baeyens — Mon, 08 Mar 2010 12:03:28 GMT

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.

Problem with load Alphanumeric Field

Mon, 08 Mar 2010 12:17:01 GMT

Code sample ;


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

Problem with load Alphanumeric Field

jpengiu — Mon, 08 Mar 2010 12:57:17 GMT

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

thanks a lot