Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Morning
How to format a date from 12.15.2015 to monthyear 12.2015 and a number 12,44567778 to decimal number 12,45 while loading for using later as dimension?
LOAD
monthyear
decimalnumber
Or how to format dimension?
Is it possible - I searched for solutions but didnt found.
Thank you.
LOAD
Date(Date#(monthyear, 'MM.DD.YYYY'), 'MM.YYYY') As Date,
Num(decimalnumber, '0,00', ',') As Number,
...
Date(MonthStart(date#('12.15.2015', 'MM.DD.YYYY')), 'MM.YYYY')
or without MonthStart
round(number, 0.01)
For date you can use date function and for number use Num() function
Date(DateField, 'MM.YYYY') as DateField,
Num(NumberField, '##.00') as NumberField
Thank you - I am happy now.