topic mapping problem zero values in QlikView

mapping problem zero values

Fri, 08 Feb 2013 13:43:28 GMT

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 — Fri, 08 Feb 2013 13:57:01 GMT

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