Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Create an Additional Date Column during Data Source Import

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

0 Replies