Hi, I am in the process of creating a data warehouse using a dimensional model and Kettle Data Integration for the ETL process. I have started to create a date dimension containing different columns such as date, year, month, day of week, etc. However, I am having some difficulties converting from date to string. I want to display the month as a string (january-december).
Right now I have a transformation that generates a start date using Generate Row, from that I use Add Sequence to add dates and a Calculator to calculate a row of dates. I format the dates to Date format and calculate Month of date using the Calculator, which displays the month of the date in an integer. This works fine, but now I want to display the month as a string. I use Select Value to change the format from integer to string and set the format to MMMM, but it doesn't work as I cannot get it to display the string. Does anyone know why this is?
Any help is appreciated.