Hi guys,
I'm loading a data source with around 20 columns. 3 of these contains date information in the format YYYY-MM-DD HH:MM:SS.
I would like to modify my import script in order to create 3 additional columns with the convertion of the data in the format YYYY-MM. Below an example of what I have and what I would like to have:
As Is Data Source:
Column A | Column B | Column C | Column D ...... | Column N
2015/02/01 07:00:00 | 2015/02/01 07:00:00 | 2015/02/01 07:00:00 | myname | revenues
To Be Data Source:
Column A | Column B | Column C | Column D ...... | Column N | ALIAS Column A
2015/02/01 07:00:00 | 2015/02/01 07:00:00 | 2015/02/01 07:00:00 | myname | revenues | 2015-02
Thanks to everybody
Maurizio
