Generate monthly historical data

[rogeriobarbosa]

Hello, I have this data table

I want to generate monthly data observing the occupation change date, how to do it in the script so that I have this result:

[Taoufiq_Zarra]

can he have more than two occupations? or always 2 as in the example

[skiruthigadevi · Accepted solution]

may be this helps,

https://community.qlik.com/t5/Qlik-Design-Blog/Slowly-Changing-Dimensions/ba-p/1464187

[otaviofs · Accepted solution]

Base:
LOAD
Name,
Occupation,
Change_Date as End,
date(if(Name=peek(Name),previous(Change_Date),yearstart(Change_Date))) as Start
;
LOAD * INLINE [
Name, Occupation, Change_Date
Jhon, Programmer, 01/03/2019
Jhon, Program Analyst, 15/06/2019
Jhon, Manager, 10/08/2019
];

Base_1:
Load
*,
date((Start +iterno()-1)) as Date
Resident Base
While Start +iterno()-1 < End;

drop table Base;