Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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