PROBLEM WITH EXPRESSION

[imoratal]

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]

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.