Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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