Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
thank you very much greeshma.k its working