PROBLEM WITH EXPRESSION

imoratal — Thu, 16 Dec 2010 15:35:43 GMT

I have a table Name Value
A 1
B 2
C 3
how I can do that with an IF if I have another table where it says A or B or C type your value?

boorgura — Thu, 16 Dec 2010 15:55:32 GMT

you can simply use mapping in this case:

MapTable:

mapping load * inline [

x,y

A,1

B,2

C,3

];

Fact_table:

LOAD
applymap('MapTable', <field_name>) as field_name

from filename.qvd (qvd);

where field_name is the field which has values A/B/C and needs to be mapped to 1/2/3.

topic PROBLEM WITH EXPRESSION in QlikView