Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
greeshma_k
Contributor III

Re: Mapping function

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

2 Replies
greeshma_k
Contributor III

Re: Mapping function

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

Re: Mapping function

thank you very much greeshma.k its working