How to replace dimension data

[Anonymous]

Hi ,

One of my field data is like below

Month

Jan

Feb

Mar

sep

aug

I am excepting o/p is like this in Dimension level(UI Level only need)

Month

January

February

March

August

Thanks,

[Chanty4u]

try this

date(fieldname,'MMMM')

[Chanty4u]

or may be

=Dual(Month(field),date(field,'MMMM'))

[Anonymous]

Not for montht field Dimension is like below....

type code is dimension

red

raj

nag

babu

o/p

reddy

raju

nagaraju

babureddy

[Chanty4u]

you have limited values or more values you have?

[Anonymous]

You should use the function "month(Month)" and set the variable in the beginning of the script before the load like this :

SET MonthNames='January;February;March;August';

[mato32188]

Hi,

add as dimension:

Pick( Match(Month,'Jan','Feb','Mar','Apr','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),

'January','February','March','April','June','July','August','September','October','November','December' )

BR

Martin

[Anil_Babu_Samineni]

Question not clear, You could create one more field with full names and use the same where you want?

[its_anandrjs]

Pick() function is the right way but you can try with if also or may be in the script level also.

By Calculated Dimension

=if(Match(Month,'Jan'),'January',

if(Match(Month,'Feb'),'February',

if(Match(Month,'Mar'),'March',

if(Match(Month,'Apr'),'April',

if(Match(Month,'May'),'May'

)))))