Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

mapping problem zero values

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?

Tags (2)
1 Solution

Accepted Solutions
SunilChauhan
Esteemed Contributor

Re: mapping problem zero values

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

1 Reply
SunilChauhan
Esteemed Contributor

Re: mapping problem zero values

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