Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mapping function

i am trying to write a code in mapping function..but i have face some errors.. i am create 2 tables one table name is

Trans table.and another table is tab table.In that tab table i am creating mapping load inline table.my code problem is month..when i am execute the program  month field is comes in *****..but i want to display in month jan,feb like that ..please help me..i am upload my qvw file....

It shows like that

Year1     Month1  Month

2004     ****          1

2004     ****          3

but i am looking like that

Year1     Month1  Month

2004          jan     1

2004         march   3

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

In your mapping table, the field names are comma separated and actual values are separated by space. Change the mapping table as below

Mapping LOAD * Inline

[
month, desc
1,jan
2,feb
3,march
4,apr
5,may
6,jun
7,jul
8,aug
9,sep
10,oct
11,nov
12,dec
]
;

Regards,

Greeshma

View solution in original post

2 Replies
Anonymous
Not applicable
Author

Hi,

In your mapping table, the field names are comma separated and actual values are separated by space. Change the mapping table as below

Mapping LOAD * Inline

[
month, desc
1,jan
2,feb
3,march
4,apr
5,may
6,jun
7,jul
8,aug
9,sep
10,oct
11,nov
12,dec
]
;

Regards,

Greeshma

Not applicable
Author

thank you very much greeshma.k its working