Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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