Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
NUM#(Filed) solved the issue.
NUM#(Filed) solved the issue.