Convert numeric data type value to Text datatype

[#1]

Hi All,

Please help me on this, I Have a column containing Month value in Format Jan, feb, Mar, .....etc i want current and previous month togather but by doing - "Jan -1" instead of "Dec" i am getting 12. How can I convert this "12" in to Dec.

Hope I m clear at my point....

Please help me on this....Thanks

Rahul

[sparur]

Hi, Rahul.

You can to use a map table:

monthnum, mothname

1, Jan

2, Feb

...

12, Decand use this table to convert your expression (12 into Dec). see more details about mapping in help, search by words: mapping, applymap

[spsrk_84]

Hi,

Write a calculated Dimension if u wnat to see the output in charts else use a if condition in script like if( MnthValue=1,'Jan',if( MnthValue=2,'feb'

Like above repeat the if statements till u reach 12 th month.

Regards,

Ajay

[spsrk_84]

eveb Mapping Table is very usefull in this regard.