Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Solution

Accepted Solutions
SunilChauhan
Champion
Champion

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

Sunil Chauhan

View solution in original post

1 Reply
SunilChauhan
Champion
Champion

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

Sunil Chauhan