Accumulative date

[qliknexus_kgcru]

i was wondering if you could add an additional field from this code so that it can have an additonal field like these:

[Date Field]

2016

Jan 2017

Feb 2017

Mar 2017

April 2017

May 2017

LOAD * Inline

[

DATE_1,YEAR_1, MONTH_1

01/01/2016,2016,01

02/01/2016,2016,02

03/01/2016,2016,03

04/01/2016,2016,04

05/01/2016,2016,05

06/01/2016,2016,06

07/01/2016,2016,07

08/01/2016,2016,08

09/01/2016,2016,09

10/01/2016,2016,10

11/01/2016,2016,11

12/01/2016,2016,12

01/01/2017,2017,01

02/01/2017,2017,02

03/01/2017,2017,03

04/01/2017,2017,04

05/01/2017,2017,05

];

for the additional field, it has a data of 2016, Jan 2017, Feb 2017, and so on

[antoniotiman]

Hi,

if I have understood correctly, like this

LOAD *,MonthName(DATE_1,11+MONTH_1) as MonthYear Inline [
DATE_1,YEAR_1, MONTH_1
01/01/2016,2016,01
02/01/2016,2016,02
03/01/2016,2016,03
04/01/2016,2016,04
05/01/2016,2016,05
06/01/2016,2016,06
07/01/2016,2016,07
08/01/2016,2016,08
09/01/2016,2016,09
10/01/2016,2016,10
11/01/2016,2016,11
12/01/2016,2016,12
01/01/2017,2017,01
02/01/2017,2017,02
03/01/2017,2017,03
04/01/2017,2017,04
05/01/2017,2017,05
];

Regards,

Antonio