Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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