mapping problem zero values

[#1]

I have a problem with mapping. In my database I have an optionfield with 4 values: 0,1,2 and 3. I am using mapping to give a description:

PostingType_map:

MAPPING LOAD * INLINE [

0,Purchase,

1,Sale,

2,Consumption,

3,Output
];

The conversion works for 1,2 and 3 but not for 0. The zero stays zero. Any ideas?

[SunilChauhan · Accepted solution]

Please use some field name because first row in inline is considered as column Name

PostingType_map:

MAPPING LOAD * INLINE [
ID,Name//<---------------------------------for example
0,Purchase,

1,Sale,

2,Consumption,

3,Output
];

hope this helps