converting number

[nagasekhar]

How to convert 

001,002,003,004,005,011,012

into

1,2,3,4,5,11,12

[Saravanan_Desingh · Accepted solution]

Try something like,

My_Field-0

Or

Num(My_Field)

tab1:
LOAD F1, F1-0 As F2, Num(F1) As F3 INLINE [
    F1
    001
    002
    003
    004
    005
];

[Andrei_Cusnir]

Further updates regarding this post are shared in "converting 001 and 011 to 1,11" [1], you can follow that link for additional updates as well.

[1] https://community.qlik.com/t5/New-to-Qlik-Sense/converting-001-and-011-to-1-11/m-p/1841148#M192693