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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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