Create an Additional Date Column during Data Source Import

Wed, 01 Apr 2015 13:22:36 GMT

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:

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

topic Create an Additional Date Column during Data Source Import in QlikView

Create an Additional Date Column during Data Source Import