QlikView doesn't convert all text values to numbers

[ahmed_hassan]

Dear Community,

I used the below mapping to merge several values e.g.  9 (as text) &  9B &  9A  into 9 (as number). However, for some reason QlikView does not convert e.g.  9 (as text) to 9 (as number) as shown in the screenshot. Any idea what I can do? Thanks

Mapping Load * Inline[

From, To
9 , 9
9B, 9 
9A, 9
8 , 8 
8+, 8 
8-, 8
7 , 7 
7+, 7 
7-, 7
6 , 6 
6+, 6 
6-, 6
5 , 5 
5+, 5 
5-, 5
4 , 4 
4+, 4 
4-, 4
3 , 3 
3+, 3 
3-, 3 
2+, 2 
2-, 2 
2 , 2
];

[ahmed_hassan · Accepted solution]

NUM#(Filed) solved the issue.