Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
try this
date(fieldname,'MMMM')
or may be
=Dual(Month(field),date(field,'MMMM'))
Not for montht field Dimension is like below....
type code is dimension
red
raj
nag
babu
o/p
reddy
raju
nagaraju
babureddy
you have limited values or more values you have?
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';
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
Question not clear, You could create one more field with full names and use the same where you want?
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'
)))))